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:

1. Power Query
2. Power Pivot & DAX
3. Power BI

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.

If you have any questions, visit our FAQ page or feel free to contact us

This is included in the online course:

• Full access to the online course in Power Pivot & DAX for 12 months
• Requirements: Basic knowledge in Excel is required. Excel installed in your PC.
• 15 lessons divided into 4 chapters
• Total video time: 37 min
• Time to complete to course including exercises and quizzes: 2,5h
• Average time per lesson: 2 minutes 49 seconds
• Personal diploma upon completion

Do you need to install Excel on your computer? You can buy Excel here at Microsoft