Freigeben über

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

  • Artikel

Accounting and Finance Professionals have a new learning resource. The Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel article, Excel workbook samples, and sample Access database provide scenario based data modeling and analysis help for self-service BI with PowerPivot and Power View.

The scenario describes how Finance professionals at Contoso Ltd. create a PowerPivot data model, Excel PivotTables, and Power View reports 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 cash flow 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.

Extensive details of over 80 DAX formulas are provided, as well as tips for creating highly efficient and fast performing data models. The Excel 2013 version of the sample workbook also provides several dynamic Power View reports.

 

Click here to download the whitepaper: https://www.microsoft.com/en-us/download/details.aspx?id=38838

Comments

  • Anonymous
    June 04, 2013
    The comment has been removed
  • Anonymous
    November 20, 2013
    Arthur makes some great points. I have also read Collie, Russo, and Ferrari describe similar rules of thumb.Any guidance?
  • Anonymous
    November 03, 2015
    I have a busy P&L with financials for ASSUMPTIONS & RECOUPMENTS & DEAL NOTES, my issues is that i'm trying to capture the data onto a custom ingest template but the P&L is too busy with deals and notes, do you have any advise on how to capture the P&L data onto my custom template?