Advanced Microsoft Power BI
5.0 /5- Offered byLinkedin Learning
Advanced Microsoft Power BI at Linkedin Learning Overview
Duration | 3 hours |
Total fee | ₹1,150 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
Advanced Microsoft Power BI at Linkedin Learning Highlights
- Earn a certificate of completion from LinkedIn Learning
Advanced Microsoft Power BI at Linkedin Learning Course details
- In this course, Helen Wall guides you through the advanced capabilities of the service
- She shows how to work with calculations, effectively leverage the DAX language, create advanced queries, and use the M language to improve the querying process
- Helen also demonstrates how to get data into Power BI using the Power Query editor and then model the loaded data using DAX columns, tables, and measures
Advanced Microsoft Power BI at Linkedin Learning Curriculum
Introduction
Explore advanced features of Power BI
What you should know
Exercise files
Working with Power BI
Introducing the course project
Power Query and M language
DAX language
Efficient data strategies
DAX Language
DAX tables and GENERATESERIES
DAX columns
DAX measures
DATE, YEAR, MONTH, and DAY date DAX functions
CALENDAR and CALENDARAUTO DAX functions
DAX measure evaluation context
CALCULATE DAX function
DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions
Challenge: Crop modeling
Solution: Crop modeling
DAX Formulas
ALL DAX function
POWER DAX function
DIVIDE DAX function
Variables in DAX formulas
Iterator DAX functions and SUMX
FILTER DAX function
Challenge: Rate of change by commodity
Solution: Rate of change by commodity
Advanced DAX Calculations
SELECTEDVALUE DAX function
IF DAX function for conditional formulas
EOMONTH DAX function
DATEDIFF DAX function
BLANK and ISBLANK DAX functions
Filtering between tables
DAX acrobatics
GENERATE and ROW DAX functions with calculated dates tables
DATESBETWEEN DAX function
DATEADD DAX function
MTD, QTD, and YTD date DAX functions
DAX quick measures
Power BI summarized view
Challenge: DAX time intelligence modeling
Solution: DAX time intelligence modeling
Continuing Your Power BI Learning Journey
Next steps and additional resources
Advanced Microsoft Power BI at Linkedin Learning Faculty details
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?