Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

MDX Fundamentals

via Pluralsight

Overview

This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.

This course explains how to use MDX to query an Analysis Services multidimensional database. It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets. The course then focuses on how to structure queries and how to create sets to use on a query axis. The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data. Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets. This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.

Syllabus

  • Introduction to MDX 35mins
  • Basic MDX Queries 37mins
  • Sets 70mins
  • Hierarchies in MDX 26mins
  • Calculations 47mins

Taught by

Stacia Misner Varga

Reviews

4.6 rating at Pluralsight based on 450 ratings

Start your review of MDX Fundamentals

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.