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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
