First take on PowerPivot

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 Server 2012
    • Windows Server 2008 R2, (64-bit only).
    • Windows Server 2008 SP2
    • Windows Server 2003 R2 with MSXML 6.0 (32-bit only)
    • Windows 7
    • Windows Vista SP2
    • Windows XP for PowerPivot for Excel 2010
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

2 thoughts on “First take on PowerPivot

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

Leave a Reply

Your email address will not be published.