Главная
Study mode:
on
1
Introduction
2
What is MDX
3
T sequel query
4
Star schema
5
Cube visualization
6
Naming conventions
7
Sets
8
Tuple
9
Round Brackets
10
Sub Cubes
11
Demos
12
Query Structure
13
Default Measure
14
Add Multiple Members
15
Add New Product Category
16
Add Extra Level
17
Point Naming Convention
18
Multiple Years
19
Filter
20
Destination Currency
21
Measures
22
NonEmpty
23
Summary
24
Resources
25
Questions
26
Windowing functions
27
MDX vs Dax
Description:
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.

Beginners Guide to MDX

PASS Data Community Summit
Add to list
0:00 / 0:00