MDX: Multidimensional Expressions (Course)

Multidimensional Expressions (MDX), the original language of Microsoft SQL Server Analysis Services cubes, is the standard for OLAP (Online Analytical Processing) calculation design, cube querying, and reporting. It is not difficult to learn, once you understand the basics. Let Chris Webb, world’s undisputed authority on MDX explain this subject to you. Start by watching the free! modules, and become a Full Access Members to watch the rest. We have over 6 hours 30 minutes of learning for you, with nearly a hundred demos in this course alone, but you should also consider the related, SSAS Cube Design course, with additional, relevant content.

Course Modules

  1. MDX Basic Concepts 30-min Free!
  2. MDX Queries 25-min Free!
  3. Calculated Members 50-min
  4. Member and Set Functions 30-min
  5. What is the MDX Current Member Function? 5-min Free!
  6. MDX Numeric Functions and CURRENTMEMBER 35-min
  7. MDX: Previous Period Growths, Shares & Moving Averages 35-min
  8. More MDX Member & Set Functions 1-hour 35-min
  9. What is a Subselect in MDX? 4-min Free!
  10. Exists, MDX Solve Order, and Subselects 50-min
  11. MDX Performance Diagnosis with Profiler 30-min

Related Content

Consider subscribing for the entire year to take advantage of the new, upcoming content, at a discount. Make sure you have selected to receive our New Content Announcements newsletter, to be notified when subsequent course modules have been added.

Watching any of the free videos (like MDX Basic Concepts) is the best way to make sure that our adaptive-rate streaming technology works for you. Make sure to try out our Jump to a chapter feature—it is very responsive, allowing you to instantly browse any part of a video, subject to your connectivity.


Suresh · 27 June 2014

Excellent series! Chris makes learning MDX so easy by starting with basics and then go deep into complex queries. I would be nice if AdventureWorks SSAS project is made available for paid subscribers to run/test queries against. Of course, one needs AdventureWorksDW2012 database (available from Microsoft) installed as well.

Chris Webb · 29 June 2014

Hi Suresh,

You can download the Adventure Works SSAS project here: - it’s one of Microsoft’s own samples, not something I have created.


Suresh · 7 July 2014

Perfect! Thank you very much.