Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Different Types of Many-to-Many Relationships in Power BI

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Different Types of Many-to-Many Relationships in Power BI

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.