2. The Promise of PowerPivot

In This Chapter

Preparing Your Data for PowerPivot 17

Getting Your Data into PowerPivot 18

Define Relationships 23

Add Calculated Columns Using DAX 25

Build a Pivot Table 26

World-Class Data Compression 31

Asymmetric Reporting with PowerPivot 33

This chapter walks you through one process of building a PowerPivot report. You will learn how simple it is to merge data from two sources in a single PowerPivot pivot table.

You can download these data sets from http://www.MrExcel.com/powerpivotbookdata.html.

Before trying these steps in this chapter, make sure that you have installed the PowerPivot client in Excel 2010 as described in Chapter 1, “Downloading and Installing PowerPivot.”

Preparing Your Data for PowerPivot ...

Get PowerPivot for the Data Analyst: Microsoft® Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial