One thing thats not just observed by me but must have been my many :- Selfless efforts from your content sir ✨ you are already into corporate and still choose to make such content that's helpful for Data Analyst Aspirants like me, glad 🙏🏻✨
Now a days many people are asking money and doing paid services for even share some information on IT related, your selfless efforts are priceless 🙏 the content is very usefull for many people who are interested on data analyst, pls dont stop making videos as possible as Thank you shashank
Do you have to create the bridge table from transaction table? Can I just reference the bridge table from customer table and remove the duplicates? Since it also has unique customers name
Because here we taking customer as a main column, so Customer table itself has all the unique elements. so there is no need of merging two tables and eliminating duplicates.
You created duplicate of transactions table and removed duplicate, but if added new name in customer table then how it will appear in bridge table? I think we need to append both table and then need to remove duplicate.
Mostly if we are adding new names then it has to be updated in both the tables. But yeah if that's not the case then we have to do what you have mentioned.
Hello, My name is Swapnil. A few months ago, I commented on your LinkedIn post suggesting you create an informative video about database schemas, such as star schemas and snowflake schemas. I understand you have more responsibilities now since you were promoted to Manager, but we would still greatly appreciate it if you could make this video for us. Thank you.
What about if the customer table customer name is not in transaction table and customer name in transaction table that dnt have in customer table. Then how will create bridge table?
Hi Shashank, I have attended interview last week and i got a question like this: We have sales table with order date. But date is of different time zones and asked to calculate last N months total sales.
When I connected both the tables directly by opting Many to Many cardinality it is showing me the same result when I connected via Bridge table. So what's the difference between both.
But your bridge table data never get refreshed as you taken the copy of table. In future the table data get increased is your bridge table will update?? No right.
@@learnwidgiggs Again there is a gap. Whenever we take duplicate of table , and if you change the data in base table it never get to duplicate table, here you have taken duplicate right, how you will do data refresh. Also one of your video you mentioned same point
@@learnwidgiggs one qq, can we give link to value. Let say employee count is 10, if i click on value 10, i want to see all 10 employees names and other details…….like another report link. But i need value interaction on 10 is it possible
I had to ask about RLS implementation where when we have a lot of tables and RLS with a bridge table becomes impossible to work with. Can you share any solution for that
Hi, Can you plz carify my below doubt. Is it advisable to use bridge table if the column we are trying to make a bridge table on includes one table that has 10 unique values and another table that only has 2 or 3 unique values?
I'm unable to fetch both tables columns in a table visual at a time, it's accepting either A table or B table. But, we have bridge between them by C table, it should work right? Could you please clarify this?
Hey Shashank . A small question over here it is similar to a problem I faced in one of my test. Lets say I was the transactions based on ID rather then customer. We can create bridge based on Id as there is no Id column in the transaction table.
@@learnwidgiggsshould it be better to create a refrence table as any changes in source table will imply in refrence table instead of creating dublicate table
And choosing any table to create duplicate / refrence would do the job, but would it much better to create refrence table of customer table as it more primary compared with transaction table . Bcz for every transaction there has to be a customer but vice versa not true ?
Thank you for uploading these type of videos. I think we can use ALL or DISTINCT or VALUES to create a new table which will have unique values. Pls correct me if I am wrong.
Thanks for this video!! I have question here. If we have more number of fact tables falling under many to many relationships, every time do we need to create bridge tables to connect in the model?
One thing thats not just observed by me but must have been my many :- Selfless efforts from your content sir ✨ you are already into corporate and still choose to make such content that's helpful for Data Analyst Aspirants like me, glad 🙏🏻✨
Thank you so much for appreciating.
Fixed question in every Power BI interview.
Also I knew this approach already but after your video now I can use this more confidently.
Excellent!
Instead of dublicate the table you can also create summrize table also.Any way good job
Another approach woud be create the bridge table using DAX function VALUES(customer). This will provide us unique values of customers.
Can you explain it in DAX and which one is advisable DAX or creating bridge
very helpful
Now a days many people are asking money and doing paid services for even share some information on IT related, your selfless efforts are priceless 🙏 the content is very usefull for many people who are interested on data analyst, pls dont stop making videos as possible as Thank you shashank
It's my pleasure
Hey hi, can you please make a video on how to resove circular dependency???
Sure, noted.
I had an interview today, and it included a question about many-to-many relationships. Nice work 👍
Glad to hear this!
Hey brother can you tell me from where did you get the interviewing opportunity? I am not getting any interview calls.
even me.. am not getting any interview calls. please help me
I am also not getting any call? What did u do for this opportunity kindly share
@@prince5724 @chaithradubsmash7615 @awesomearnav7854 Did you guys get calls now? If yes please guide me as well on how to get interview calls.
What does a bridge table act as....A fact table or a dimension table and what shall the flow be ?
Finally a useful video. Thanks a lot 👏
Do you have to create the bridge table from transaction table? Can I just reference the bridge table from customer table and remove the duplicates? Since it also has unique customers name
Hi LearnWidGiggs, can you please tell what are the issues we have to face if start working on many to many relationship model.
So wonderful explained 👏🏼... please keep posting such videos
Sure, I will
WHY HAVE YOU NOT USE APPEND QUERY TO MERGE 2 TABLES AND THEN REMOVE ALL OTHER COLUMN?
Because here we taking customer as a main column, so Customer table itself has all the unique elements. so there is no need of merging two tables and eliminating duplicates.
You created duplicate of transactions table and removed duplicate, but if added new name in customer table then how it will appear in bridge table? I think we need to append both table and then need to remove duplicate.
Mostly if we are adding new names then it has to be updated in both the tables. But yeah if that's not the case then we have to do what you have mentioned.
Hello,
My name is Swapnil. A few months ago, I commented on your LinkedIn post suggesting you create an informative video about database schemas, such as star schemas and snowflake schemas. I understand you have more responsibilities now since you were promoted to Manager, but we would still greatly appreciate it if you could make this video for us.
Thank you.
Finished watching
BRO how to create model for 25 different excel files in Powerbi and create relationships
Thanks for this.
But a better way would be to keep unique from the customer table since it is a dimension table. It contains only names and Id.
Yeah..we can use customer table also and that would be better
Very usefull and helpful interview question.
Glad it was helpful!
What about if the customer table customer name is not in transaction table and customer name in transaction table that dnt have in customer table. Then how will create bridge table?
Very helpful video sir ❤ keep uploading such content it's helping very much🎉❤
Thank you, I will
Hi Shashank, I have attended interview last week and i got a question like this:
We have sales table with order date. But date is of different time zones and asked to calculate last N months total sales.
What if I want to pull ID from customer table along with any column from Transaction table into Bridge Table? It gives an error.
I think here using of duplicate is not works when the source table is updating it is not giving updation in duplicate table
Because you are using local excel file..if you will use database..it would update automatically
When I connected both the tables directly by opting Many to Many cardinality it is showing me the same result when I connected via Bridge table. So what's the difference between both.
In less data as well as with less no of tables..this can give same result
thanks a lot brother......
If we connect Customer and Transaction table directly by opting Many to Many cardinality, will it show inaccurate result ?
It may generate inaccurate results
@@learnwidgiggs thank you.
Can we create a reference table instead of duplicating the fact table to have up to date values?
Yes
Reference Is always better
Hello Sir please make a one video on SSIS SSRS SSAS
thanks and regards
thank you, really helpful
Glad it helped!
Last week, in Kpmg interview they asked the same question
Thanks for sharing the info!
Here he if want user and transaction with only latest date how it will be achieved
Hi , is there anything essential thing need to noyice here like fact table or dimension table? Which table we want to duplicate?
Hi, Can you please make a video on steps to share report with others from power bi service?
Noted
But your bridge table data never get refreshed as you taken the copy of table. In future the table data get increased is your bridge table will update?? No right.
If it is connected to a database then yes it will refresh on scheduled refresh.
@@learnwidgiggs Again there is a gap. Whenever we take duplicate of table , and if you change the data in base table it never get to duplicate table, here you have taken duplicate right, how you will do data refresh. Also one of your video you mentioned same point
@@learnwidgiggs one qq, can we give link to value. Let say employee count is 10, if i click on value 10, i want to see all 10 employees names and other details…….like another report link.
But i need value interaction on 10 is it possible
Helpful content🙏👌
Glad it was helpful!
Is it possible to clear the interview by going through the tutorials and no real-time hands on?
You should definitely work on a real time dataset atleast once
Very helpful video 👏
Glad it was helpful!
I had to ask about RLS implementation where when we have a lot of tables and RLS with a bridge table becomes impossible to work with. Can you share any solution for that
Hi,
Can you plz carify my below doubt.
Is it advisable to use bridge table if the column we are trying to make a bridge table on includes one table that has 10 unique values and another table that only has 2 or 3 unique values?
Please answer this question Shashank
plz uplode dataset for practice purposes
I'm unable to fetch both tables columns in a table visual at a time, it's accepting either A table or B table. But, we have bridge between them by C table, it should work right? Could you please clarify this?
Yes it should work
Yes, it's not working if we try to pull columns from both A and B tables.
Hi sir, how to share excel file to others?
Thanks Shashank!!
You explained the scenario in a very simple way!!
You are the best!!
Glad you liked it 😊
Could you please explain, how to integrate Power BI to third-party applications?
Yes..we can use embedded option in powerbi service
Hide all foreign Key on Fact table is it a good practise
Bro what is the solution if the there are two different persons with same name in this scenario
Hey Shashank . A small question over here it is similar to a problem I faced in one of my test. Lets say I was the transactions based on ID rather then customer. We can create bridge based on Id as there is no Id column in the transaction table.
wonderful bhai
Thank you 😊
Thanks a lot , Really very helpful
Glad it was helpful!
@@learnwidgiggsshould it be better to create a refrence table as any changes in source table will imply in refrence table instead of creating dublicate table
And choosing any table to create duplicate / refrence would do the job, but would it much better to create refrence table of customer table as it more primary compared with transaction table . Bcz for every transaction there has to be a customer but vice versa not true ?
Pls reply @learnwidgiggs
Thank you for uploading these type of videos.
I think we can use ALL or DISTINCT or VALUES to create a new table which will have unique values.
Pls correct me if I am wrong.
Yes we can
Thanks for this video!! I have question here. If we have more number of fact tables falling under many to many relationships, every time do we need to create bridge tables to connect in the model?
Yes ..we should not directly connect many to many
@@learnwidgiggs Perfect!! Thanks for the reply!! It helps a lot in my ongoing real time project.
Hi brother wer do u stay in Bangalore?
Hi brother r u in Bangalore right now?
Currently..not there
@@learnwidgiggs okay