What is PowerPivot for Excel?
PowerPivot brings the power of Data Modelling into your PC.
Traditionally, the DataWarehouse is built on a database server (SQL) and a data model is built on top of it (SSAS). Then, a front end is used to present the data to users.
Now, data can come from different sources and pulled into the PowerPivot engine, relationships defined, calculations done and reports presented on Excel.
What are the pre-requisites?
With Courtesy from Microsoft: PowerPivot for SharePoint deployment
- Windows Server 2008 (64-bit)
- Windows Server 2008 R2 (64-bit)
- Windows Server 2012
SharePoint 2010 Enterprise, with Excel Services, Secure Store Service, and the Claims to Windows Token Service configured in the same server farm.
|Windows features||Microsoft .NET Framework 4.0 (http://go.microsoft.com/fwlink/?linkid=229476) (Install before installing Office)|
|Excel version requirements||Excel 2010 (32-bit or 64-bit) is required to install PowerPivot for Excel.Excel 2013|
|Office features||Office Shared Features must be installed with Excel 2010..NET Programmability Support, in Microsoft Excel, must also be installed.Visual Studio 2010 Tools for Office Runtime (http://go.microsoft.com/fwlink/?linkid=229475) (Install before or after Office, but before using PowerPivot for Excel).|
What is it best used for?
Quick data modelling and proofs of concepts.
What did I like about it?
1. Slicers – With slicers defined, I can quickly change between different data views based on the filters defined as the slicer. Very quick and great ability to spot trends.
2. KPI visualisations are easily set up and usable. Definitely one for my books!
Try out PowerPivot on SharePoint server