How to manage Many-To-Many relationships in a Data Model? |Data Modeling Tutorial |BI Consulting Pro

Join this channel to get access to perks:

How to manage Many-To-Many relationships in a Data Model? |Data Modeling Tutorial |BI Consulting Pro

In this video, you'll learn to manage Many-To-Many relationships in a data model with the help of a Demo.

**********************Important Links ************************

******************************************************************

************************************************************************
☎️ LET'S CONNECT!
************************************************************************

#datamodeling #manytomany #PowerBI #BIConsultingPro

-~-~~-~~~-~~-~-
Please watch: "Microsoft Azure Synapse Analytics Tutorial | Azure Synapse Studio |BI Consulting Pro |Azure Tutorial"
-~-~~-~~~-~~-~-

[Android.]

Very good step by step and an excellent case scenario . Your video and analytics solved my many-to-many problem

[ShreyasSinha]

Help for Viewers. to UNDERSTAND the example in the VIDEO.

Student Table has ID Column ---> this ID is actually Student ID.

He does not mention this in the video !!!

Same way the ID in Class Table is not Index it is actually CLass ID.

Index is different and ID is different.

ID is CLDB1123 it is identification for simplicity he has taken 1 2 3 which looks like Index.

Both tables have Student ID and Class ID that's how he is able to make a connection.

[ThansiRoopa]

Sorry to say may be this is wrong, ID column is not having repeated Id's to avoid m-m relationship. instead using bridge you can use directly 1-1 relationship right?, correct me if i am wrong

[kalyanreddy]

Hello sir
Sir each class must have it own id right, here i see multiple id for the same class. For eg when we use clss id in a table visual and count the number of student for that class id. In that case how we determine correct class id . Id 4 may be english class and id 8 will be english class.

[kamranumudov]

I have question. But there are ID column each table. We can not use it for making 1 to 1 relationship?

[usman_oz]

Will the filter flow work in this case ? The filter directions are from normal tables to Bridge table. Eg:- If I have a table visual with student details from student table and a filter visual from the class table on the canvas to see all students from students table who are enrolled for a particular class. As per the flow, I understand that bridge table would get filtered but the filter context would not traverse further into students table. Hope I'm able to explain and pls correct me if I didn't understand or am wrong. Thx

[asifmohammed]

Please answer below questions

1) I believe wrong data is used in example. In the class table - Math, German, English, computer each have 2 different class ID. I understand each class can be taken by multiple students, but each class cannot have 2 different class ID.

2) You said using direct many to many relationship is not going to workout, but did not explain what will be the issue if we use it. Because when i used it i did not find any issue when using data from tables and filters. can you explain why not to use it?

3) Why did you use both "Student ID" and "Class ID" in enrollment table. When just using "Student ID" in enrollment table will be sufficient in this case. When i used just "Student ID" enrollment table i am getting same results. Am i missing something here?

[abhilashjoseofficial]

Just a silly doubt.What is the need for creating the bridge table, the many to many relationship is working right

[dilipkumar-cknc]

Hi
I have 3 tables containing many to many relationship so I drag one date column to slicer and I start filtering the data it was showing properly

[pramodprem]

How to modelling if there is no common columns from two tables?

[anindadatta]

Is it possible to have two new single column dimension tables " student table" and " Class table" having only unique student id and class id, and connecting those dim tables separately to fact tables

[jlcw]

hi, I followed your instruction but after making Cartesian product, power bi does not allow one to many relationship as making Cartesian product will duplicate the keys (in your example, the student ID)

[PankajKumarpankaj_lp]

can we use distinct union to create the table

[tajlala]

HI,
nice demo.
if i have two tables with one ID column whose ID is repeating in both tables,
then i make link table with column by appending tables and remove duplicates. is this approach is good or not? because some cases it is not giving me accurate result, Please guide

[biswadeepchettri]

Sir.. In class 10th IT book..chapter rdbms... In the explanation of Many to many relationship..it says that.. "in this relationship, no table has the Primary key column" till now i m unable to understand this.. How could it be possible? In openoffice,
I tried to.make a table without PK column but.i could not.. This book is wrong or..i could not understand? Plzz reply sir

[renukapremkumar]

What do I do if this problem occurs when I'm using a star schema? When I use a bridge table like this, it becomes a Snowflake schema, which is not good from performance perspective?

[akshaypatil]

primary key and foreign key, both indicates same set of information and one to many cardianlity is done. Here you are using two different columns which does not obey primary key-foreign key relationships....please explain do we also form cardinality between two differenet columns in power BI in real world????

[cosquncg]

Hi, if in 1th table have 500 rows but in 2nd table have 650 rows will it be work?

[aniketgode]

I have joined silver plan . still perks not being executed. please acknowledge

[MurugansfSelvaraj]

Hi bro, please show the demo for how to check final value in many to many relationship in the visual "Report view"