Course Code: mdxintro
Duration: 7 hours
Prerequisites:

It is recommended to have an understanding of database structures

Overview:

This instructor-led, live training (online or onsite) is aimed at anyone who wishes to gain an undertstanding and use of MDX (Multi-Dimensional eXpressions) queries.

Format of the Course

  • Interactive presentation and discussion.
  • Lots of exercises and practice.

Course Customization Options

  • To request a customized version of this training course, please contact us to arrange.
Course Outline:
  • Introduction to multidimensional databases
  • Terminology
    • Dimensions, Levels & Members
    • Tupples & Sets
  • Simple MDX Queries (Axis specifications)
  • MDX set functions (.members, .children, etc.)
  • The WITH clause (calculated members & named set)
  • Time Intelligence with DAX (YTD, SPLY, etc.)
  • Hands-on MDX query labs for all sections