Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel
Downloads on this page include the Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel article and the ContosoPnL sample Excel workbook.
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
1
Date Published:
09/05/2013
File Name:
ContosoPnL_Excel2010.zip
ContosoPnL_Excel2013.zip
ContosoPnLData.zip
File Size:
5.3 MB
6.3 MB
9.7 MB
The article, along with the ContosoPnL.xlsx sample Excel workbook, can provide business, accounting, and finance professionals help with creating PowerPivot data models to analyze budget, forecasting, and other profit and loss account metrics, such as:
- Aggregate, or value measures such as sums and averages for currency and headcount.
- Comparison measures such as year-over-year, year-to-date, and variance for currency and headcount.
- Performance, or ratio measures such as percentage, cost per head, and rate and volume variances. All of which calculate on different combinations of value and comparison measures.
There are two versions of the ContosoPnL workbook, one for Excel 2010, and one for Excel 2013. While both versions include the PowerPivot data model and a number of PivotTables, the Excel 2013 version also includes several example Power View sheets to show even more ways to explore the data.
You can also download the ContosoPnL Data Access database. The database is not necessary to use the ContosoPnL workbook. All of the data in the ContosoPnL Access database has already been imported into the ContosoPnL workbook’s PowerPivot data model. The database is provided as a separate download in case you want to create your own test data model and use it as a data source.Supported Operating Systems
Windows 7, Windows 8, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012
Further system requirements located in the downloadable article.- Further instructions located in the downloadable article.