YoVDO

Beginners Guide to MDX

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses DAX (Data Analysis Expressions) Courses Tuples Courses Star Schema Courses MDX Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Data Modeling, Transformation, and Serving
DeepLearning.AI via Coursera
Data Warehouse Fundamentals
IBM via Coursera
Data Warehousing: Schema, ETL, Optimal Performance
Coursera Instructor Network via Coursera
Modeling Data in Power BI
Microsoft via Coursera
Data Modeling in Power BI
Microsoft via Coursera