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.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:

    Date Published:


    File Size:

    9.7 MB

    5.3 MB

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

Popular Downloads

Loading your results, please wait...

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers