Enterprise Business Intelligence with Excel Cube Functions
If you build Excel reports or dashboards that source data from your Microsoft Analysis Services cubes or Tabular Data Models then this Multi-media Training Kit, now in its Second Edition, is for you.
Excel Cube Formula Reporting with Microsoft Analysis Services (2nd Edition)
focuses on the cube functions that are easy to use and give you the biggest bang for the buck. No knowledge of MDX, DAX or VBA is required.
Revised and updated in 2017, the Training Kit includes a Learning Guide (PDF over 110 pages) with links to:
40 short, digestible, explanatory videos
7 annotated workbook examples that you can re-use
Sample database in 4 local cube files
Topics specific to Microsoft Analysis Services include:
Retrieving data from cube member properties
Syntax of CUBEMEMBER functions specific to Analysis Services cubes
How Tabular models differ from Multidimensional cubes from the viewpoint of building Cube Formula Reports
Isolating cube and model data source connections for easy switching, for example, from Test to Production environments
Don't waste time building reports the hard way with copy/paste, rekeying, or GETPIVOTDATA. Order your copy of Excel Cube Formula Reporting with Microsoft Analysis Services (2nd Edition) today and learn how to leverage your models or cubes the easy way.
Add Excel Cube Formula Reporting with the Data Model (2nd Edition)
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, local cube files, and video files into a new folder on your hard drive.