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

YouTube

Beginners Guide to MDX

PASS Data Community Summit via YouTube

Overview

Explore the fundamentals of MDX (Multidimensional Expressions) in this comprehensive 58-minute conference talk from the PASS Data Community Summit. Dive into key concepts such as T-SQL queries, star schemas, cube visualization, and naming conventions. Learn about sets, tuples, round brackets, and sub cubes through practical demonstrations. Master query structure, default measures, and techniques for adding multiple members and new product categories. Discover how to implement extra levels, point naming conventions, and work with multiple years. Gain insights into filtering, destination currency, measures, and the NonEmpty function. Compare MDX with DAX and explore windowing functions. Perfect for beginners looking to enhance their data analysis skills in multidimensional environments.

Syllabus

Introduction
What is MDX
T sequel query
Star schema
Cube visualization
Naming conventions
Sets
Tuple
Round Brackets
Sub Cubes
Demos
Query Structure
Default Measure
Add Multiple Members
Add New Product Category
Add Extra Level
Point Naming Convention
Multiple Years
Filter
Destination Currency
Measures
NonEmpty
Summary
Resources
Questions
Windowing functions
MDX vs Dax

Taught by

PASS Data Community Summit

Reviews

Start your review of Beginners Guide to MDX

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.