To learn how to analyze data in PowerPivot for Excel, see the following topics.
Prepare Data for Analysis in PowerPivot
Create Reports, Charts, and PivotTables
Add Calculations to Your Reports, Charts, and PivotTables