One way to build your Power Pivot Data Model for easy comparison of current year results to the same period in the prior year. Also explains a method to track year-to-year %age change of same-store sales.
How to handle imported cumulative monthly accounting balances
This multi-part section describes how you can add assumptions and modeling capabilities to you Power Pivot Data Model.
Excel, Power Pivot, and cube formula reporting can be enormously powerful tools in the hands of accountants and finance managers, Click here to learn more.
This video will help you learn:
- if your version of Excel 2013 has it
- some advantages the Data Model offers
From time to time you may want to retrieve text (as opposed to numeric) values into a PivotTable to slice-dice-pivot the text. Or you want to get properties/attributes of a dimension member in a PowerPivot model using Excel cube functions. Here is one solution.
In addition to providing self-service, personal BI in larger organizations Power Pivot for Excel is an inexpensive BI tool for finance professionals who manage the accounting and reporting for small businesses using QuickBooks. The section on Small Business Intelligence will includes a growing collection of articles on leveraging QuickBooks data using Power Pivot for Excel
The frequent requirement to compare actual performance to budget can be difficult to achieve with a Pivot Table because Actual and Budget data often come from two different sources. With PowerPivot or the Excel 2013 Data Model you can leverage cube functions to obtain the layout you need. Part 2 explains how you can add sparkline charts and KPI status and trend icons. You can download the Excel workbook and data model used in the videos here in either Excel 2010 format or Excel 2013/2016 format.
Excelcraft's multi-media training kits focus on building cube formula reports and dashboards with data sourced either from PowerPivot/Power BI data models or from Analysis Services Multidimensional cubes/Tabular models. Learn more...