Office

    Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel

    Language:
    English
    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.
      Version:

      1

      File Name:

      ContosoPnLData.zip

      ContosoPnL_Excel2010.zip

      ContosoPnL_Excel2013.zip

      Date Published:

      5/9/2013

      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 System

      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

    Microsoft suggests

    Try Office 365 free for one month.
    The power of Office. Everywhere.
    Start your free month of Office 365 now.
    Learn more