Benefits and Features
Data to Use with Power Pivot
Using Power Pivot Manager

Data recovery from the same file
Import from single file sources (Excel, text, etc.)
Import from an Access database

Understanding views
Hide data in client tools
Generate a date table

Use the Relation tool
Clean and format data
Design calculated fields and use DAX functions

Create pivot tables connected to Power Pivot Use
the Pivot table tools specific to Power Pivot
Create measures

Lab: Generate Pivot Tables with PowerPivot from External Sources