Learn advanced uses of Microsoft Power BI. Learn how to perform calculations, effectively leverage the DAX language in data modeling, make advanced queries, and more.
Overview
Syllabus
Introduction
- Explore advanced features of Power BI
- What you should know
- Exercise files
- Introducing the course project
- Power Query and M language
- DAX language
- Efficient data strategies
- 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
- 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
- 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
- Next steps and additional resources
Taught by
Helen Wall
