O'Reilly logo

PowerPivot for the Data Analyst: Microsoft by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required