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.
Minimum Requirement | |
Operating system |
|
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!
Next steps
Try out PowerPivot on SharePoint server
Thumbs Up! please allow me to raise this blog into favorites..
Hi,I read your blogs named “First take on PowerPivot | Terry’s Business Intelligence” daily.Your humoristic style is witty, keep it up! And you can look our website about fast proxy list.