Focus video player for keyboard shortcuts

Auto

- HD
- 720p
- 540p
- 360p

1.00x

cc
- 0.50x
- 0.75x
- 1.00x
- 1.25x
- 1.50x
- 1.75x
- 2.00x

We hope you enjoyed this lesson.

Cool lesson, huh? Share it with your friends

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