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:
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 http://sdrv.ms/13Z5b3f (64.6MB)
If you find this useful, please add a comment and let me know.