10. Mashing Up Data with PowerPivot

PowerPivot is a free add-in for Excel 2010 brought to you by the SQL Server Analysis Services team at Microsoft. One of the themes for the 2010 release of Office was to improve Excel as a Business Intelligence tool. PowerPivot makes it possible to do jaw-dropping analyses in Excel.

Benefits and Drawbacks to PowerPivot

There are some pluses to PowerPivot, but also a few minuses. This chapter starts with the mega-pluses, which are the things that make you love PowerPivot.

Mega-Benefits of PowerPivot

Here are five ...

Get Pivot Table Data Crunching: Microsoft now with O’Reilly online learning.

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