Contents
Introduction . .................................................................................................. 1
“There’s Row 20 Million” . .............................................................................................................. 2
“The PivotTable Field List Has Fields from Both Tables” . ............................................................... 2
Now, I Love VLOOKUPs . ........................................................................................................... 3
“How Much Will This Cost? Well, the Client Is Free” . ............................................................... 4
This Book Was Pitched Eight Hours Later . ............................................................................... 4
There Could Be Five Titles for This Book . ........................................................................................ 4
Who Are Those Other People in the Room? . .................................................................................. 5
This Book Is For The Excel People.............................................................................................. 6
How This Book Is Organized . .......................................................................................................... 7
Conventions Used in This Book . ..................................................................................................... 7
Text Conventions . .................................................................................................................... 7
Special Elements . ..................................................................................................................... 8
Cross References . ..................................................................................................................... 8
1 Downloading and Installing PowerPivot . .................................................. 9
System Requirements . ................................................................................................................... 9
32 Bit or 64 Bit? . ...................................................................................................................... 9
Not Excel Starter Edition . ....................................................................................................... 11
Not Excel Web Apps . .............................................................................................................. 11
Installing PowerPivot. .................................................................................................................. 11
The Many PowerPivot Tabs . .................................................................................................. 11
Ribbon Tabs in the PowerPivot Application ............................................................................ 12
Uninstalling PowerPivot . ............................................................................................................. 16
Next Steps . ............................................................................................................................ 16
2 The Promise of PowerPivot .........................................................................17
Preparing Your Data for PowerPivot . ............................................................................................17
Getting Your Data into PowerPivot . ............................................................................................. 18
Decide on a Sequence for Importing . ..................................................................................... 19
Import a Text File . ................................................................................................................. 19
Add Excel Data by Copying and Pasting .................................................................................. 22
Define Relationships . ................................................................................................................... 23
Add Calculated Columns Using DAX .............................................................................................. 25
Build a Pivot Table . ...................................................................................................................... 26
World-Class Data Compression . ................................................................................................... 31
Asymmetric Reporting with PowerPivot . ..................................................................................... 33
Next Steps