About this lesson
If you've worked with PivotTables, you'll appreciate that sometimes your source data can be too complex to work with in a PivotTable. In this video we will explore the un-solvable Pivot problem that Power Pivot can easily solve.
There are no related exercise files for this lesson.
The Need for Power Pivot
An overview of the importance of Power Pivot.
When to use
When you want to build a more complex data model than can be handled by a basic Pivot Table.
Limitations of basic Pivot Tables:
- Some data sources are too complex to flatten
- Calculated field language is very limited
- Types of aggregations that can be used are limited
Hints & tips
- The formula language for Power Pivot is Data Analysis eXpressions (or DAX)
Lesson notes are only available for subscribers.