Mastering Power Pivot
Crunch more data with less effort
Analyze millions of rows of data faster than standard Excel formulas
There’s a better way to do data analysis in Excel.
Excel calculations can slow down significantly as the number of rows of data increases. In our data-driven world, that is not great.
When workbooks become too big, too slow, or too complex, more formulas, different formulas, are rarely the answer.
What if you could overcome this barrier, analyze massive datasets, and create powerful reports, all without leaving Excel?
That’s exactly what Power Pivot allows you to do.
You need a tool that works with you, not against you.
Power Pivot is a tool baked right into Excel. It can handle millions of rows and perform lightning-fast calculations.
However, learning Power Pivot on your own can be intimidating. Many users don’t know where to begin.
Mastering Power Pivot is the course to guide you from zero to hero. It gives you a step-by-step path to mastering one of Excel’s most powerful calculation engines.
No matter your current experience level, whether you’re a business analyst, financial professional, or data enthusiast, this course will transform how you work with Excel.
Mastering Power Pivot is only available within the Excel Academy.
What will you learn?
The course starts with the foundations: what Power Pivot is, where to find it, and how it fits into the modern Excel ecosystem.
Next, we explore how to build data models that are scalable and reliable. Covering normalization, dimension vs. fact tables, and creating relationships between data tables.
Then, we dive into DAX, the formula language behind Power Pivot. You’ll master the core functions such as CALCULATE, FILTER, time intelligence, and more. Including practical examples that show how everything connects.
Finally, we look at Cube formulas and learn how to integrate Power Pivot with Power BI and Excel Online for dynamic dashboards and reports.
What’s included?
✓ 5 hours of on-demand video (60+ lessons).
✓ Work through common calculation scenarios
✓ Certificate of completion
✓ English closed captions
✓ Ask questions and get expert answers
Syllabus:
Introduction
- Power Pivot – Introduction
- Short history of Power Pivot
- Workbook paradigm
- Calculation concepts
- Installing Power Pivot
- Power Pivot user interface tour
- Download sample files
Building robust data models
- What is a data model
- Normalization
- Dimension vs. fact tables
- What about Merge in Power Query?
- Creating relationships
- Relationship errors
- Calendar tables – Method #1
- Calendar tables – Method #2
- Calendar tables – Method #3
- Managing relationships
- Star vs Snowflake schema
- Optimizing tables for a Star schema
- Relationship cardinality
- Working with multiple fact tables
- Filter direction and shared dimensions
- Progress Recap
DAX calculations
- Introduction to DAX
- Calculated columns
- Measures
- Implicit vs Explicit Measures
- Create a table to hold measures
- Creating DAX measures step-by-step
- Understanding Grand Total & Sub Totals
- Applying sort order
- Aggregator functions
- Iterator aggregators
- DIVIDE function
- CALCULATE function
- Understanding the CALCULATE function
- FILTER function
- ALL, ALLEXCEPT and ALLSELECTED functions
- CALCULATE – Example #1
- CALCULATE – Example #2
- CALCULATE – Example #3
- Disconnected Tables
- IF, HASONEVALUE, VALUES
- SWITCH
- Dealing with Grand Totals and disconnected tables
- VAR and RETURN statements
- Time intelligence
- KPIs
- Progress Recap
Cube formulas
- Introducing cube formulas
- Add slicers to existing CUBEVALUE functions
- Add dimensions to existing cube functions
- Writing cube functions from scratch
- Using sub-dimensions
- CUBESET, CUBESETCOUNT & CUBERANKEDMEMBER functions
- Spill cube functions with SEQUENCE, MAP & LAMBDA
- Add slicers to CUBESET functions
- Progress recap
Working with other tools
- DAX Formatter
- Working with Power BI
- Cube formulas from Power BI
- Power BI with Excel Online
Wrap up
- Wrap-up
- Feedback
- Certificate
Learn Power Pivot today and master your data.
Join the Excel Academy
Enrol today to get instant access to the Mastering Power Pivot course.
Follow the course
Discover how to build robust data models and leverage the DAX calculation engine.
Apply the learning
Apply the skills and start saving time today.
What will you gain from Mastering Power Pivot?
✓ The confidence to build complex data models without breaking a sweat
✓ The skills to write powerful DAX formulas that adapt and scale
✓ The ability to build dashboards to impress stakeholders and drive better decisions
✓ The peace of mind that your models will stay accurate and up-to-date
Stop fighting Excel. Start mastering it.
Mastering Power Pivot is only available within the Excel Academy.