Overview
Explore the intricacies of many-to-many relationships in Power BI through this comprehensive conference talk from PASS Data Community Summit. Delve into the new composite models and their unique relationship cardinality, distinguishing between different types of many-to-many connections. Learn practical applications through various examples, covering classical many-to-many, simple many-to-many, filter propagation, and cardinality. Understand the necessity of relationships, high-level relationships, snowflake relationships, brand relationships, and union relationships. Examine important concepts such as implicit propagation, bidirectional filters, and single direction filters. Compare different approaches and gain insights into the ideal implementation of many-to-many relationships in Power BI for more effective data modeling and analysis.
Syllabus
Intro
Classical ManytoMany
Simple ManytoMany
Filter Propagation
ManytoMany Cardinality
Why do I need a relationship
Highlevel relationships
Snowflake relationships
Brand relationships
Union relationships
One big issue
Ideal world
Implicit propagation
Bidirectional filter
Single direction filter
Comparison
Taught by
PASS Data Community Summit