MDX Fundamentals

This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.
Course info
Rating
(443)
Level
Intermediate
Updated
Sep 19, 2013
Duration
3h 37m
Table of contents
Introduction to MDX
Basic MDX Queries
Sets
Hierarchies in MDX
Calculations
Description
Course info
Rating
(443)
Level
Intermediate
Updated
Sep 19, 2013
Duration
3h 37m
Description

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.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Designing SSIS Integration Solutions
Beginner
2h 41m
Jun 18, 2020
Securing SSAS Models
Advanced
1h 40m
Apr 10, 2020
Tuning SSAS Models
Advanced
3h 3m
Mar 10, 2020
More courses by Stacia Misner Varga