2. The Promise of PowerPivot

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 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.