The Excel BI VC offers training and support to individuals who use Excel.
Next Meeting

Wed, Sep 10 2014 10:00 (GMT-12:00) International Date Line West

MDX for Excel PowerPivot


MDX for Excel PowerPivot

Although Data Analysis Expressions (DAX) is the first language of PowerPivot and Excel PivotTables, cube formulas still use MDX to query PowerPivot data. So, it is important to understand the basics of MDX if you're going to get the most out of PowerPivot. In this session, you will learn how to use MDX with Excel features such as sets and query tables, as well as how MDX is used in Excel cube formulas. There will be a strong practical focus, showing you examples of how you can use MDX to solve real-world problems when building Excel dashboards and reports.

Chris Webb is an independent consultant specializing in Analysis Services, Power Pivot, Power BI, DAX and MDX. He is a co-author of three books: "Expert Cube Development with SQL Server 2008 Analysis Services," "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase," and "SQL Server Analysis Services 2012: The BISM Tabular Model." He blogs about Microsoft BI at