Who’s this course for?
The online course in Power Pivot & DAX is for anyone who wants to further increase their knowledge within Excel. If you work with large volumes of data, then this is a course perfect for you.
This online course is included in our course package Power Bundle. With Power Bundle, you will become an expert in data modeling technology. Our online courses in Power BI and Power Query are included. Read more about Power BI and Power Query
We recommend you to take the online courses in following order:
What will I learn?
Power Pivot is a powerful add on for Excel and DAX (Data Analysis Expressions) includes additional functions to use when you work with relational data and dynamic aggregation. With Power Pivot & DAX you can create data models, data analysis and import data from different various sources.
In this course we’ll start with go through Power Pivot’s basic functions, and how we can apply them to different situations. We’ll then move forward and learn about relational data, DAX and KPI. Further down in this page you can see which chapters and lessons are included in the course.
This is included in the online course:
Do you need to install Excel on your computer? You can buy Excel here at Microsoft