<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Introduction to MDX

Learn MDX for SSAS in our virtual training course. Master multidimensional expressions for cube calculations, querying, and retrieving data. Elevate your enterprise analytics.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

During this MDX virtual training course, you will learn how to use MDX for use with SSAS in your enterprise. This class starts 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 the class continues by explaining how to write MDX queries to retrieve data from an Analysis Services cube. This class also covers 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 member, addition of calculations and named sets to a cube for re-usability, script assignments for complex calculations, MDX and cube security, and optimization techniques for queries.

Course Outline ( Free Preview)

Introduction to MDX - What you need to get started

Module 00 - Getting Started

Module 01 - Getting Started with MDX

Module 02A - Building MDX Queries (MDX Query Editor) 23 min.

Module 02B - Building MDX Queries (Basic Queries and Syntax) 18 min.

Module 03A - Defining Sets (Basics) 32 min.

Module 03B - Defining Sets (Manipulating Sets) 33 min.

Module 03C - Defining Sets (Working with Hierarchies) 21 min.

Module 04A - Adding Calculations to a Query (Basics) 33 min.

Module 04B - Adding Calculations to a Query (Time Intelligence) 31 min.

Module 05A - Creating Calculations in a Cube (Calculated Measures and Custom Members) 40 min.

Module 05B - Creating Calculations in a Cube (Creating Sets) 12 min.

Module 05C - Creating Calculations in a Cube (Creating KPIs) 21 min.

Module 06A - MDX Scripting (Basics) 46 min.

Module 06B - MDX Scripting (Allocations) 32 min.

Module 07 - Optimizing MDX Queries 31 min.

This course includes:

  • 6+ hours of training
  • 16 Modules
  • * Access on mobile and browser
  • Certificate of Completion