Power BI Interview: Join Disconnected tables?? | Must Watch
HTML-код
- Опубликовано: 28 янв 2024
- Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
-------------------------------------
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / learnwidgiggs
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
Even if RUclips would have asked me to pay inorder to watch your videos, i would have paid with Honour!
Everyone of us could see the efforts you bring in everytime! We appreciate you 🎉 ... We do know that you are already working in some organisation but still you have yhis heart of making the unemployeds like me get into the corporate again. Thank you ❤
Thank you 🙏
Means a lot ❤️
Watched entire playlist.... Too worth❤❤
Thank you 🙏
Hiii....could u plz make a video on DAX formulas, how to prepare those all 256 syntaxes easily
Thank you for a such informative video
Glad to hear this 🙂
Nice ...when you started the video my explanation was same
Great 🤝
Thank you
Please 🙏 make one video on time intelligence functions (ALL) with differences & scenarios
I have already uploaded a video on this..plz check out the channel
but it is create 1 to 1 relationship, what if we want to create 1 to may relationship ?
Please upload more Important questions videos asked on power BI interview this video is really very helpful for us.
Sure.
Lets say the addresses are not aligned with the customer table? like 1 != 1 how to address that senario?
I thought its working as clustered index, learned new term which is surrogate key, thanks bro
Welcome
Very well explained but if i have been ask to create a relationship between these two tables then how would do that ?
It will be 1:1 relationship..with index column
Thank you sir
Thank You for sharing sir
Welcome
very nice and useful video.
Glad to hear this 🙂
How to combine 3 or more tables without common columns.
How to get source files to practice from my end.
How anyone be sure the row 1 record from both table is for the same customer???
we have merged it with index key which we have provided but how will it make sure the each record of one table has same values(actual values) since we have provided index in same order?
It has to be there otherwise there is no sense of combining the tables.
Great Work. How to proceed if we have duplicate records in those tables. Please
Duplicate records have to be removed.
i think its a many to many relationship on that scenarios we can create bridge table if i am wrong please correct it
Nice one Bhai 😊
Thank you 🙏
This solution won't work all the time.
How can we make relation ship between this 2 Tables???
How can we confirm whether that 1st customer belongs to 1st address ???
I thought you are creating bridge table and connect both tables using cross filtering.
You have merged another table columns and didn't shown, How to connect both tables on which key
If you try to connect both tables even after merging by adding index column, It will result in many - to - many relationship.
Kindly clarify
for example how we are sure shanshank belongs to lucknow why not nagpur?
The data has to be there in that order to combine it properly
@@learnwidgiggs Thank you so much for your explanation 🙌
What if ? it is not in proper order @@learnwidgiggs
What will be the approach if there is any duplicate records
Duplicate needs to be removed
Its good method, but in real world how do we know shashank has abc address of his ID is 1
When the both table have different dimensions we can cant arrive at any conclusion.
We should go to database and find something common or else we can't justify
Hi...what if we have the duplicate records in both the table???
it means in a table1,table2 if coloumn consists of repeated data that type of data is called duplicate records in both table
Hi Shashank, what if the tables are at different level of granularity, it is similar to a false join , we might lose some data right ?
Rightly said
What will be the experience level of this question sir?
We can use append right
No
We can go with append also right?
No
Hi Shashank, practically combined table will not make any sense.
Bro... Cybersecurity wala koi banda lao
Sir please reply can a fresher pass pl300 exam? How many months of preperation will be needed for a fresher? Please reply🙏🏻
i have just passed the pl300 exam and according to me only one or two weeks of preparation and practice is required if u have better study materials and proper dumps
2 weeks of proper study.. considering you already have good knowledge in Power BI
how you are so sure that shashank belongs to Lucknow why not nagpur?
The data has to be there in that order to combine it properly
@@learnwidgiggs this is a sample example that you have taken and now for example i have table student and table student marks but without any relationship in between both the table so how could we get the information student A get this much marks as we don’t have any relation in between those tables
@@fitnesswithbhavi powerbi desktop provides default relationship if you want to create relationship in powerbi desktop click on manage relationship then create on n your own if i am wrong please correct it
thank you sir
Welcome 🙂
What if n.os of rows are not matching with other table? Are we still have to same procedure or its not possible or its a error on the data?
Its the error on the data