Online Course: Introduction to MDX

Eight Sessions Start on January 29th, 2013 and End After February 28th, 2013

Course Overview

In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to use MDX with SQL Server Analysis Services in your enterprise.

Stacia Misner, course instructor and SQL Server MVP, will start by 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. Then, she will continue by explaining how to write MDX queries to retrieve data from an Analysis Services cube.

Stacia will also cover the following topics:

  • Common functions for creating sets and performing set-based operations
  • Development of calculations that can be used as measures or as dimension members
  • Addition of calculations and named sets to a cube for reusability
  • Script assignments for complex calculations
  • MDX and cube security
  • Optimization techniques for queries

The target audiences for this class are developers, architects or IT professionals who have some experience with Analysis Services and have a basic understanding of relational database technology. No prior programming or SQL query development experience is required.


Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Build MDX queries
  • Create sets with functions and use functions for set operations
  • Work with hierarchical sets
  • Build calculated members and add calculations to a query
  • Debug a MDX script
  • Implement dynamic security and configure cell-level security
  • Use SQL Server Profiler to analyze queries
  • Optimize queries for the Formula Engine and the Storage Engine

Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (Download link via e-mail).

Pragmatic Works is also offering a live, four-day version of the Introduction To MDX class for $795. For more information about this option, visit Pragmatic Works’ site.


Group Registration

  • Does your company have more than 1 person interested in this class? Take advantage of immediate savings by completing the group registration process. To start the group registration process downoad our form here.



    Stacia Misner

    Stacia Misner is a Business Intelligence consultant, trainer, author and SQL Server MVP. She has authored or co-authored 10 books on business intel...