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 🙏🏻✨
@learnwidgiggs
6 ай бұрын
Thank you so much for appreciating.
@parthasarathimandal9437
11 ай бұрын
Is it possible to clear the interview by going through the tutorials and no real-time hands on?
@learnwidgiggs
11 ай бұрын
You should definitely work on a real time dataset atleast once
@rajatsehgal4249
8 ай бұрын
If we connect Customer and Transaction table directly by opting Many to Many cardinality, will it show inaccurate result ?
@learnwidgiggs
8 ай бұрын
It may generate inaccurate results
@rajatsehgal4249
8 ай бұрын
@@learnwidgiggs thank you.
@AnnoyedBigWaterfall-zc8vd
2 ай бұрын
BRO how to create model for 25 different excel files in Powerbi and create relationships
@VINAYKUMAR-gv1sw
11 ай бұрын
Instead of dublicate the table you can also create summrize table also.Any way good job
@narendranbharathidasan7712
Ай бұрын
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?
@eRoyalMarathi
9 ай бұрын
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.
@learnwidgiggs
9 ай бұрын
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.
@Queen.himshi
8 ай бұрын
Hey hi, can you please make a video on how to resove circular dependency???
@learnwidgiggs
8 ай бұрын
Sure, noted.
@AnalyticswithProfessor
11 ай бұрын
WHY HAVE YOU NOT USE APPEND QUERY TO MERGE 2 TABLES AND THEN REMOVE ALL OTHER COLUMN?
@aakashmohan9827
7 ай бұрын
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.
@guppi1
7 ай бұрын
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
@crazykidanshita31
8 ай бұрын
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
8 ай бұрын
If it is connected to a database then yes it will refresh on scheduled refresh.
@crazykidanshita31
8 ай бұрын
@@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
@crazykidanshita31
8 ай бұрын
@@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
@sagarsharma12_
11 ай бұрын
Fixed question in every Power BI interview. Also I knew this approach already but after your video now I can use this more confidently.
@learnwidgiggs
11 ай бұрын
Excellent!
@shubhamchaudhari1212
6 ай бұрын
What does a bridge table act as....A fact table or a dimension table and what shall the flow be ?
@LaxmiChinta-q1z
5 ай бұрын
Hi sir, how to share excel file to others?
@rajatsehgal4249
7 ай бұрын
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.
@learnwidgiggs
7 ай бұрын
In less data as well as with less no of tables..this can give same result
@souravkajuri
4 ай бұрын
Another approach woud be create the bridge table using DAX function VALUES(customer). This will provide us unique values of customers.
@vigneshmca7
Ай бұрын
Can you explain it in DAX and which one is advisable DAX or creating bridge
@EMRANKhan-q8x
26 күн бұрын
Great explanation
@ashaarun527
24 күн бұрын
Thanks a lot … 🥰
@nidhisingh4973
11 ай бұрын
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?
@rajuj2548
7 ай бұрын
Please answer this question Shashank
@meghalohar2367
Ай бұрын
very helpful
@chithambargoud2110
6 ай бұрын
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
@learnwidgiggs
6 ай бұрын
It's my pleasure
@suhasvlogs7490
11 ай бұрын
I think here using of duplicate is not works when the source table is updating it is not giving updation in duplicate table
@learnwidgiggs
11 ай бұрын
Because you are using local excel file..if you will use database..it would update automatically
@shatirdimag1011
17 күн бұрын
Best
@hairavyadav6579
29 күн бұрын
Thanks today I now live this thing.... Before that I know only theory Thanks for video ❤
@swapnilpatil4238
2 ай бұрын
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.
@ZuhaibAli-b9r
Ай бұрын
Hi LearnWidGiggs, can you please tell what are the issues we have to face if start working on many to many relationship model.
@assassinfps
11 ай бұрын
I had an interview today, and it included a question about many-to-many relationships. Nice work 👍
@learnwidgiggs
11 ай бұрын
Glad to hear this!
@prince5724
11 ай бұрын
Hey brother can you tell me from where did you get the interviewing opportunity? I am not getting any interview calls.
@chaithradubsmash7615
11 ай бұрын
even me.. am not getting any interview calls. please help me
@awesomearnav7854
11 ай бұрын
I am also not getting any call? What did u do for this opportunity kindly share
@tweetmemes5015
Ай бұрын
@@prince5724 @chaithradubsmash7615 @awesomearnav7854 Did you guys get calls now? If yes please guide me as well on how to get interview calls.
@kenit925
11 ай бұрын
Can we create a reference table instead of duplicating the fact table to have up to date values?
@nidhisingh4973
11 ай бұрын
Yes
@samuna8950
11 ай бұрын
Reference Is always better
@pleasantways
5 ай бұрын
Hi , is there anything essential thing need to noyice here like fact table or dimension table? Which table we want to duplicate?
@anupamjha827
5 ай бұрын
Here he if want user and transaction with only latest date how it will be achieved
@swarajhegde9059
5 ай бұрын
Bro what is the solution if the there are two different persons with same name in this scenario
@ruthvikanomula9829
8 ай бұрын
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?
@learnwidgiggs
8 ай бұрын
Yes it should work
@raghuanamala1125
7 ай бұрын
Yes, it's not working if we try to pull columns from both A and B tables.
@deepdeep-yy2pt
11 ай бұрын
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
@BouchraMokhtari-kt6ek
3 ай бұрын
Finally a useful video. Thanks a lot 👏
@prakashlucky8975
11 ай бұрын
Hi brother wer do u stay in Bangalore?
@alamkondabhaskarreddy1460
11 ай бұрын
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.
@Meashlesha
11 ай бұрын
Hello Sir please make a one video on SSIS SSRS SSAS thanks and regards
@abhishekdeshpande6659
10 ай бұрын
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.
@Aditya61515
11 ай бұрын
Hide all foreign Key on Fact table is it a good practise
@NaveenKumar-fq4sb
11 ай бұрын
plz uplode dataset for practice purposes
@SumitPorchattiwar
3 ай бұрын
thanks a lot brother......
@rajasnabar5564
5 ай бұрын
What if I want to pull ID from customer table along with any column from Transaction table into Bridge Table? It gives an error.
@divyab534
3 күн бұрын
@learnwid What's the solution for the above question? Thank you
@venubabutanneeru5960
11 ай бұрын
Could you please explain, how to integrate Power BI to third-party applications?
@Mohancrazy0804
7 ай бұрын
Yes..we can use embedded option in powerbi service
@sandeepchauhan7742
11 ай бұрын
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.
@learnwidgiggs
11 ай бұрын
Yes we can
@rahulmishra1523
11 ай бұрын
Very helpful video sir ❤ keep uploading such content it's helping very much🎉❤
@learnwidgiggs
11 ай бұрын
Thank you, I will
@jjohn108
11 ай бұрын
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.
@learnwidgiggs
11 ай бұрын
Yeah..we can use customer table also and that would be better
@aishwaryapattnaik3082
11 ай бұрын
So wonderful explained 👏🏼... please keep posting such videos
@learnwidgiggs
11 ай бұрын
Sure, I will
@sharanyav528
11 ай бұрын
Hi, Can you please make a video on steps to share report with others from power bi service?
@learnwidgiggs
11 ай бұрын
Noted
@bns1567
11 ай бұрын
Last week, in Kpmg interview they asked the same question
@learnwidgiggs
11 ай бұрын
Thanks for sharing the info!
@aditjain6580
11 ай бұрын
Very usefull and helpful interview question.
@learnwidgiggs
11 ай бұрын
Glad it was helpful!
@SandipanSarkar-c8v
5 ай бұрын
Finished watching
@dineshrddy
11 ай бұрын
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?
@learnwidgiggs
11 ай бұрын
Yes ..we should not directly connect many to many
@dineshrddy
11 ай бұрын
@@learnwidgiggs Perfect!! Thanks for the reply!! It helps a lot in my ongoing real time project.
@ShrutikaUgalmugale
5 ай бұрын
Helpful content🙏👌
@learnwidgiggs
5 ай бұрын
Glad it was helpful!
@Sirigineedi_Navann
11 ай бұрын
wonderful bhai
@learnwidgiggs
11 ай бұрын
Thank you 😊
@shikharsaxena8984
11 ай бұрын
Very helpful video 👏
@learnwidgiggs
11 ай бұрын
Glad it was helpful!
@prakashlucky8975
11 ай бұрын
Hi brother r u in Bangalore right now?
@learnwidgiggs
11 ай бұрын
Currently..not there
@prakashlucky8975
11 ай бұрын
@@learnwidgiggs okay
@alessiocerboni3026
9 ай бұрын
thank you, really helpful
@learnwidgiggs
9 ай бұрын
Glad it helped!
@Tech_ash
11 ай бұрын
Thanks a lot , Really very helpful
@learnwidgiggs
11 ай бұрын
Glad it was helpful!
@IAMCSbyRahulSharma
6 ай бұрын
@@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
@IAMCSbyRahulSharma
6 ай бұрын
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 ?
@IAMCSbyRahulSharma
6 ай бұрын
Pls reply @learnwidgiggs
@rahulchona6869
11 ай бұрын
Thanks Shashank!! You explained the scenario in a very simple way!! You are the best!!
Пікірлер: 107