25. 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. But first, let’s start with the mega-pluses, the things that will make you love PowerPivot.

Mega-Benefits of PowerPivot

Following are five mega-benefits to using PowerPivot. Any one of these benefits are enough to make me upgrade to Excel 2010.

Process far more than a million rows of data—I’ve seen demos with 100 million rows. If ...

Get Microsoft Excel 2010 In Depth now with the O’Reilly learning platform.

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