Excel Cube Formula Reporting with Microsoft Analysis Services (2nd Edition)

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 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

Dynamic Dashboard

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.

Pricing and Money-Back Guarantee  

© 2011-17 Excelcraft.com

Home            Terms of Use            Privacy            Cookies            Contact