Главная
Study mode:
on
1
Who's Speaking?
2
Agenda
3
Prerequisites
4
Current Accounts Data Model M2M
5
The M2M DAX Pattern
6
The DAX Formula of M2M Pattern
7
What the formula should perform
8
How the formula works
9
The Karma of CALCULATE
10
Wrong formula in action CustomerName
11
Many-to-many in action
12
Cascading Alternative
13
Survey Data Model
14
Survey Scenario
15
Survey Analytical Data Model
16
Survey: The Final Result
17
Survey: The DAX Formula
18
Survey - Conclusions
19
Basket Analysis: The Scenario
20
Basket Analysis in SQL
21
Look the query plan...
22
Basket Analysis: The Data Model
Description:
Explore advanced techniques for handling many-to-many relationships in DAX with this comprehensive conference talk from PASS Data Community Summit. Dive deep into the Vertipaq engine and DAX programming language to understand how to leverage many-to-many relationships effectively. Learn about various scenarios where these relationships can be managed using DAX, including current accounts, survey data, and basket analysis. Discover the differences in implementation compared to SSAS, both in terms of data modeling and programming. Gain valuable insights into mastering many-to-many relationships, opening up new modeling scenarios with promising applications in SSAS. Follow along as the speaker demonstrates practical examples, explains DAX formulas, and discusses the intricacies of CALCULATE and query plans.

Many-to-Many Relationships in DAX

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