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