MDX (MultiDimensional Expressions) in 148 minutes

,

If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful. I came to the conclusion that the best way of learning are video tutorials. 143 minutes of watching and 5 minutes of reading. Let's get started.

Some information about MDX

MDX (MultiDimensional Expressions) is a query language for OLAP databases and it's designed to provide a effective way of querying multidimensional data. MDX is used to interact with data in Microsoft SQL Server Analysis Services (SSAS) cubes. Business’s data analysis provide valuable insight into its operations and new opportunities can be identified.

MDX commands are designed specifically to retrieve data as multidimensional data structures and can process one, two, three, or more dimensions in queries. MDX expressions are composed of values, statements, functions, identifiers and operators that SSAS can evaluate to retrieve scalar value (number, string) or an object (member, set).

Level 1: Creating database and OLAP cube

To work with MDX queries, we need to create a SQL Server database and an OLAP cube in SQL Server Analysis Services. You can watch this step here:

or if you prefer the short version:

Level 2: MDX Introduction

We already have an OLAP cube, so let's start creating the first queries in the MDX language.

Level 3: Working with Sets

MDX is created to work with data sets. Below are some practical examples:

Level 4: Expressions

Let's dive into some expressions:

Level 5: Functions

A bit of knowledge about functions will also be useful:

Level 6: Aggregations

Working with aggregations, hierarchies and time is essential when it comes to MDX and OLAP analysis:

Level 7: Hierarchies

If you survived the aggregation lesson, it's time for the hierarchies

Level 8: Time

The last step of this course is a few minutes about time.

Rate

Share

Share

Rate