Make robust Excel reports and dashboards quickly and easily using Cube Functions. An Excelcraft Training Kit will show you how.
Excel Cube Formula Reporting with the Data Model (2nd Edition)
Excel Cube Formula Reporting with Microsoft Analysis Services (2nd Edition)
If you use Excel to:
Work with Data Models using Power Pivot, Power BI or in plain Excel
Connect to Microsoft Analysis Services databases (Multidimensional or Tabular)
you can take advantage of one of Excel's best kept secrets!
"Excelcraft training kits exposed the most powerful and hidden abilities of Excel while delivering best practice strategies, real world examples, and step-by-step guidance. I would highly recommend them."
DS – Principal BI Consultant – Greenville, SC, USA
“I love the clear and concise way everything is laid out!” CJ – Principal BI Consultant – Cheshire, UK
You may be frustrated by the limitations on moving a part of you PivotTable somewhere else, or inserting rows or columns within it.
For some of your management or financial reporting projects you need to be able to layout your reports or dashboards, and sections within them, in a specific way. But you want to retain the dynamic link to your cubes or Data Models.
This is where Excel's Cube Formula Reports can help. Driven by Cube Functions that, like any Excel function, can be placed pretty much anywhere, they allow you to structure your reports and dashboards the way you want them. But they still retrieve data dynamically from your models or cubes (or both) according to the parameters that you supply to the functions (date, product, region, customer, business unit, department, metric and so on).
Excel makes it easy to get going with Cube Formula Reports, with the Convert to Formulas menu option. Use it to convert a PivotTable to cube formulas, usually easier than starting from scratch, and much less stressful than building GETPIVOTDATA functions off various PivotTables squirreled away in your workbook.
As easy as it is to Convert to Formulas you'll want to make your reports and dashboards more robust while easier to maintain and enhance. An Excelcraft Training Kitwill show you how to do just that and in addition, you will learn to:
Make your reports re-usable and save development time
Add drop-down lists, slicers, and timelines for smoother report filter selection and dashboard navigation
Add functionality to check key report numbers and display alerts if numbers don't tie
Automate report printing using a simple VBA macro
Quickly add new data rows and columns to existing reports
Convert legacy "copy/paste/re-key" reports to Cube Formula Reports
Set up your reports so they remain dynamic when published to SharePoint
Leverage Excel's functionality and your existing skills to enhance your reports and dashboards
Debug formulas, work with nested dimensions, member attributes, multiple data sources, and more