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