Introduction to MDX

Sala D

This course designed for BI professionals with some experience of SQL Server Analysis Services Multidimensional cubes, but little or no experience of MDX, will teach the fundamentals of the MDX query language and show how to implement common queries and calculations.

What you will learn

  • What is MDX and why should I use it?
  • Understanding the structure of a cube: recognizing cubes, measure groups, dimensions and hierarchies
  • Understanding the concepts of members, tuples and sets
  • Writing simple queries: using SQL Management studio to write SELECT statements
  • Creating simple calculated members: when to use query, session and cube-scoped calculations, using simple MDX expressions and functions

Standard Calculations: looking at the best ways to implement common calculations, such as time series, market shares and rankings

EN Workshop