Introduction to MDX


What Will You Learn?

  • How to write MDX queries to retrieve data from an Analysis Services cube
  • Common functions for creating sets and performing set-based operations
  • MDX and Cube security
  • Optimization techniques for queries


By taking this course, you’ll learn how to use MDX for use with SSAS in your enterprise. This class begins with explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations, as well as to query cubes to retrieve data for reports.



BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS, and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.


What to Know Before the Class

Some experience with Analysis Services.

Curriculum For This Course

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance
  • AdventureWorks Cube installed on the Analysis Services instance

You may also like…