This instructor-led course is designed to take a person from the very beginning of MDX queries to journeyman. The first chapters (1-4) get you well-grounded, then from there we expand out. You won’t know how to do every MDX query. You won’t look at every function. But you will understand the patterns, and from them you can examine examples and build on them to code your own sophisticated queries.
Module 1: The Microsoft Business Intelligence Stack
Module 2: Getting Started with MDX. We walk then run. Learn this and you won’t trip.
Module 3: The all-important Dimensions. The bearers of truth
Module 4: Navigation and the secrets of relatives!
Module 5: MDX Calculations.
Module 6: Working with Time. Multiple calendars, divergent horizons
Module 7: Business Insights. Now let’s put it to work and get some situational answers
Module 8: Where else will MDX work? SQL Reports
Module 9: KPIs and MDX in the Business Intelligence Development Studio Editor