Advanced Microsoft Power BI

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.

Introduction

• Explore advanced features of Power BI
• What you should know
• Exercise files

1. Working with Power BI

• Introducing the course project
• Power Query and M language
• DAX language
• Efficient data strategies

2. 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

3. 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

4. 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