For the analysts out there who haven’t embraced PowerPivot and Power View in Excel, there is a great tutorial to help you get started: PivotTable data analysis using a Data Model in Excel 2013.

However, if you just want the finished spreadsheet, I have created one that is the result of walking through the tutorial, with only two minor modifications:

  1. Worksheets have names and colors. The black worksheets originated as data from other spreadsheets or databases
  2. The "Count of SalesKey" calculated field has a KPI attached to it and can be seen in the Pivot Table

There are numerous things that should be done to clean up the spreadsheet and make the pivot table more useable, but it’s a good example to start with.

You can download the Contoso PowerPivot Example from  (64.6MB)

If you find this useful, please add a comment and let me know.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s