- Downloading and Installing PowerPivot
- Getting your Data into PowerPivot
- Linking an Excel Table to PowerPivot
- Importing Data into PowerPivot
- Adding DAX Calculations to the Grid
- Creating Pivot Tables from PowerPivot
- Defining a Relationship Between Worksheets
- Using Automatic Relationship Detection
- Using Explicit Relationships
- Using the RELATED Function in the PowerPivot Grid
- Adding Slicers to Drive All Pivot Elements
- Adding DAX Calculations to the PivotTable
- Entering a Measure
- Using the X Functions
- Using CountRows and Distinct
- PowerPivot Is a Home Run
PowerPivot Is a Home Run
Considering that PowerPivot solves five difficult problems, it is a home run for a version 1 product from Microsoft. Version 2 is expected to be released in early 2011 with more functionality, including support for billion-row data sets.
To recap, PowerPivot solves these issues:
- Mashes up data from anywhere in Excel.
- Loads more than a million rows into Excel.
- Uses the new calculation functions offered in the DAX language to perform calculations in the grid or in a pivot table.
- Joins data from multiple worksheets into a single pivot table without doing VLOOKUP functions.
- New time intelligence functions handle fiscal years, parallel periods, and more.
Bill Jelen is an Excel MVP, host of MrExcel.com, and the author of 30+ books about Excel, including Pivot Table Data Crunching and PowerPivot for the Data Analyst.