The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.
The course includes almost 4 hours of video in 24 lectures. You need some experience of Power Pivot and the DAX language, or you should take the Beginner and Intermediate courses before this one.
Sections included in this course:
- Creating Reports and KPI
- Advanced DAX Concepts
- Advanced DAX Functions
- DAX as a Query Language
- DAX Patterns
After this course, you will have all the tools and the knowledge to create complex calculations and models using Power Pivot for Excel.