An overview of PowerPivot for Excel 2010
Part four of a six-part series of blogs

PowerPivot is a superb addition to Excel: it allows you to create pivot tables based on multiple tables taken from a variety of data sources, and its DAX language lets you report any statistic you want. This overview summarises how to get started with PowerPivot, and what it does.

  1. Getting started with PowerPivot for Excel 2010
  2. Stage 1 - Importing the tables we need
  3. Stage 2 - Creating a data model
  4. Stage 3 - Creating a Pivot Table (this blog)
  5. Stage 4 - creating measures using DAX
  6. Stage 5 - KPIs in PowerPivot for Excel

Posted by Andy Brown on 31 January 2013

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Stage 3 - Creating a Pivot Table

This is going to be the shortest part of this blog.  As for Excel, you can drag fields into the appropriate part of the pivot table:

The pivot table fields

Here we've put the decade as a vertical slicer, the director's name as a row label and the number of films as the values.

 

This would give the following pivot table:

Pivot table of 1990s films

Here we're showing only the 1990s films.

I'm assuming that readers of this blog already know what Excel pivot tables are and how to create them!

Now you have a pivot table, it's time to start adding additional measures - which is where the fun starts!

  1. Getting started with PowerPivot for Excel 2010
  2. Stage 1 - Importing the tables we need
  3. Stage 2 - Creating a data model
  4. Stage 3 - Creating a Pivot Table (this blog)
  5. Stage 4 - creating measures using DAX
  6. Stage 5 - KPIs in PowerPivot for Excel
This blog has 0 threads Add post