PowerPivot Formula Reporting Made Easy

Self-Service Business Intelligence with PowerPivot or Power BI and Excel Cube Functions

If you build reports or dashboards that source data from your PowerPivot or Power BI data models then this Multi-media Training Kit is for you.

PowerPivot Formula Reporting Made Easy focuses on the cube functions that are easy to use and give you the biggest bang for the buck. No knowledge of DAX, MDX or VBA is required.

PowerPivot Formula Reporting Made Easy is a new, multi-media training kit that will put you on the fast-track to learning cube formula reporting while leveraging your Excel skills.

The Training Kit includes a Learning Guide (PDF over 120 pages) with links to:

  • 29 short, digestible, explanatory videos
  • 9 annotated workbook examples that you can re-use
  • Sample PowerPivot models (now with versions for Excel 2010 and for Excel 2013 / 2016 Office Pro Plus) and a local cube file


Topics specific to PowerPivot include:

  • Using PowerPivot KPIs and Excel's built-in graphic capabilities to create dynamic dashboards that convey at a glance the values and status of your KPIs pulled from your data model
  • Using PowerPivot in simple modeling and planning applications, even though it doesn't natively support write-back
  • Mixing data at different levels of granularity
  • Setting up your reports so they remain dynamic when published to the PowerPivot Gallery in SharePoint
  • Using DAX funtions by copying or re-using applied examples in the sample workbooks/models. Roughly 80 DAX functions mimic Excel functions with which you are probably already familiar.

For example, learn to create Actual-to-Budget comparisons in your reports and dashboards without resorting to scattered PivotTables and GETPIVOTDATA functions.

Dynamic Dashboard

But wait, there's more. PowerPivot Formula Reporting Made Easy explains all of the above in the context of Personal, Self-Service Business Intelligence. It shows you examples of DAX functions that you can apply to your own models without prior DAX knowledge.

And since Cube Formula Reports are ideal for reporting that requires specific placement like financial statements there is a Bonus Chapter and PowerPivot Models for accounting/finance managers and professionals on Financial Reporting.

Don't waste time building reports the hard way with copy/paste, rekeying, or GETPIVOTDATA. Order your copy of PowerPivot Formula Reporting Made Easy today and learn how to leverage your PowerPivot models or cubes the easy way.

Add Excel Cube Formula Reporting with Microsoft Analysis Services to your basket and receive a 25% discount off both products (over $30 savings - automatically applied to your shopping basket).

A single license allows the purchaser to install the files on up to two computers, for his or her own use. Installation unzips an Adobe PDF file, Excel .xlsx files and video files (.mp4) files into a new folder on your hard drive.

Pricing and Money-Back Guarantee  

© 2011-17 Excelcraft.com

Home            Terms of Use            Privacy            Cookies            Contact