Power BI Modelling - Part 3 | Relationship | Many to Many | Power BI Tutorial (45/50)
Вставка
- Опубліковано 4 жов 2024
- 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 ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
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
Thank You so much sir, your explanations always give me clarity and develop interest to work hard in power BI.
You are most welcome
Very useful vedio. I will need to watch it again to fully understand.
Thanks keep learning share this channel with friends and colleagues
hii very understanding and easy approach to concepts please check about the audio its too low plz consider for other video uploads.
Sure we will fix it
Thanks, Nags :)
Should we always create a bridge table in many-to-many relationship?
Yes
A humble request sir, please make a playlist for Power BI + Python.
Will plan in future
Hi i am facing the below error please help
Connected two tables with date column - many to many, bidirectional filtering
need to compare data with both tables, problem is if a particular date is not present in one table even though its present in other table , the data presented in one table is not visible in visual since its not present in another table..
Can you please help how to overcome this
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.
Watch Dax end to end video and also watch the videos in the Dax playlist
Thanks .....I can't understand the Fact (Many to many ) logic explain with other examples...
Great
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
Check first few videos in power bi complete Playlist
Nice explanation sir
Thanks keep learning
Please explain more
Watch part 4 of modelling which is scheduled tomorrow
Hi Nags, could you please explain it in a more simplified way..!!
Watch again
wht is the benefit of creating a bridge table if there is still ambiguity in the data?
Not sure what ambiguity you meant
@@AnalyticswithNags sir i meant we still have to use the bidirectional filter which will finally create ambiguity.
Good
Thanks
thx!
thank you , keep learning
Is this table used here in Snoflake Schema???
The spelling is snow flake. This model is not snow flake.
Watch the what is snowflake schema video.
Sir where is dataset to practice
This is for understanding the concepts, create on your own or use adventure works DB
Can i get the dataset of it
Check description if not there kindly work on your own dataset. These videos for your understanding only
Hi sir,,i want to have training from you..can I get.. please confirm..if yes how will I connect
Sorry I don’t have time to conduct trainings.
Kindly watch Power BI complete playlist that covers 95% of the power bi
Hi How to resolve conflict in many to many relationship?
Not sure what conflict you are receiving
Pls Telugu videos sir
Sure will try to complete soon
how to build the bridge table?
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
@@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?
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.
thanks for your feedback, will try to improve
Sorry lost it could not understand
Watch again
Please explain more
Sure will do soon.
Follow the Part 4 modelling which is scheduled for tomorrow