Beginners Guide to MDX
summary
Explains MDX by showing live queries against the Adventure Works Cube using SQL Server Analysis Services and SQL Server Management Studio and tools like Excel and MDX Studio, demonstrating that MDX selects two axes (columns and rows), that a tuple = intersection of members from different dimensions, and that sets and members behave differently; runs demos that return a surprising value of 13399 million, shows currency conversion (USD to £26k) and warns default-measure traps while providing downloadable demo scripts.
AI-written summary · about
chapters (27)
- 0:00Introduction
- 2:48What is MDX
- 6:00T sequel query
- 10:38Star schema
- 13:15Cube visualization
- 15:47Naming conventions
- 19:26Sets
- 21:59Tuple
- 23:21Round Brackets
- 24:50Sub Cubes
- 28:30Demos
- 28:44Query Structure
- 31:05Default Measure
- 33:13Add Multiple Members
- 33:51Add New Product Category
- 36:52Add Extra Level
- 37:44Point Naming Convention
- 38:15Multiple Years
- 38:58Filter
- 41:12Destination Currency
- 44:13Measures
- 47:03NonEmpty
- 49:03Summary
- 50:36Resources
- 51:38Questions
- 52:39Windowing functions
- 53:39MDX vs Dax
related talks
53mHailing Frequencies: Analysis Services Terms and Concepts
51mData modeling for experts with Power BI
01h 01mAdvanced Data Visualization with SQL Server Reporting Services
59mMastering Time-Based Analysis in DAX
47mPower to the Pivot - Practical Intro to PowerPivot 2012
59mPresent and Futures: Roadmap and Strategy
01h 02m60-Minute Demo: Microsoft BI Tools on SAP Data
35mScaling Interactive and Insightful Dashboards with Data Studio and BigQuery