Power BI Modelling - Part 3 | Relationship | Many to Many | Power BI Tutorial (45/50)

What is Many-to-Many relationship
What different types of Many-to-Many Fact Tables
Dimension type Many-to-Many
Fact type Many-to-Many
When to use Many-to-Many Relationship
How to analyze the data with Many-to-Many Relationship
#PowerBI #PowerBIDesktop #PowerBITutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@madhavanthakur908]

Thank You so much sir, your explanations always give me clarity and develop interest to work hard in power BI.

[@AnalyticswithNags]

You are most welcome

[@shafa7668]

Very useful vedio. I will need to watch it again to fully understand.

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@saiteja8844]

Nice explanation sir

[@AnalyticswithNags]

Thanks keep learning

[@jelemich]

thx!

[@AnalyticswithNags]

thank you , keep learning

[@bchandra912]

Good

[@AnalyticswithNags]

Thanks

[@madhavanthakur908]

A humble request sir, please make a playlist for Power BI + Python.

[@AnalyticswithNags]

Will plan in future

[@gowthamigg8976]

hii very understanding and easy approach to concepts please check about the audio its too low plz consider for other video uploads.

[@AnalyticswithNags]

Sure we will fix it

[@rahulgautam511]

Thanks, Nags :)
Should we always create a bridge table in many-to-many relationship?

[@AnalyticswithNags]

Yes

[@pradnyajadhav189]

Please explain more

[@AnalyticswithNags]

Watch part 4 of modelling which is scheduled tomorrow

[@usharani7125]

Thanks a lot bro..
Your explanation with examples are awesome..clarifies many doubts 👌👌
How to connect to the adventure works db ??
Could you please suggest bro

[@AnalyticswithNags]

Check first few videos in power bi complete Playlist

[@perfectionist6624]

Hi sir,
Can u plz make full video on where to use Calculated columns in & when to use Measures in real projects.
Like give examples where we need mandatorily required to create Calc column in model and measures examples which can replace creating Calclated columns.
Plz make this with one example for each to clear understanding.
Thanks in advance.

[@AnalyticswithNags]

Watch Dax end to end video and also watch the videos in the Dax playlist

[@ragulkannan1479]

Thanks .....I can't understand the Fact (Many to many ) logic explain with other examples...

[@AnalyticswithNags]

Great

[@nishantpurohit100]

Hi Nags, could you please explain it in a more simplified way..!!

[@AnalyticswithNags]

Watch again

[@sass520]

wht is the benefit of creating a bridge table if there is still ambiguity in the data?

[@AnalyticswithNags]

Not sure what ambiguity you meant

[@sass520]

@@AnalyticswithNags sir i meant we still have to use the bidirectional filter which will finally create ambiguity.

[@KumarNishant181286]

Is this table used here in Snoflake Schema???

[@AnalyticswithNags]

The spelling is snow flake. This model is not snow flake.
Watch the what is snowflake schema video.

[@ramanjulureddy8722]

Hi How to resolve conflict in many to many relationship?

[@AnalyticswithNags]

Not sure what conflict you are receiving

[@subhankar648]

Can i get the dataset of it

[@AnalyticswithNags]

Check description if not there kindly work on your own dataset. These videos for your understanding only

[@jaitiwari241]

Sir where is dataset to practice

[@AnalyticswithNags]

This is for understanding the concepts, create on your own or use adventure works DB

[@TDR_RUTVIK_OFFICIAL]

Hi sir,,i want to have training from you..can I get.. please confirm..if yes how will I connect

[@AnalyticswithNags]

Sorry I don’t have time to conduct trainings.
Kindly watch Power BI complete playlist that covers 95% of the power bi

[@kavetibalaram4208]

Pls Telugu videos sir

[@AnalyticswithNags]

Sure will try to complete soon

[@silpasree6302]

how to build the bridge table?

[@AnalyticswithNags]

If it is database source build in database itself. For non database source there should be link table which has both entity data. Get distinct of two columns and then create a new bridge table

[@saddambasha2379]

@@AnalyticswithNags Hi Sir.If the data is having few records then we can do manually.If its data(whatever source like Excel) is dynamic,can we use distinct function or any other process?

[@sandeshpadigela2079]

Sorry lost it could not understand

[@ecooled93]

Lots of words, just doesn't explain how he actually made the bridge table. Nothing new here that is not found on MSFT website, just a waste of time.

[@AnalyticswithNags]

thanks for your feedback, will try to improve

[@tkraju2008]

Please explain more

[@AnalyticswithNags]

Sure will do soon.
Follow the Part 4 modelling which is scheduled for tomorrow