## 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.

## Exercise files

There are no related exercise files for this lesson.

## Quick reference

### 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.

### Instructions

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.