DW Concept: Slowly Changing Dimensions(SCD) |Power BI Interview
HTML-код
- Опубликовано: 18 окт 2024
- 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 : / shashank_nikumbh26
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
#powerbiinterview
#learnwidgiggs
Wonderfully explained.
Slowly Changing Dimensions - The Value of certain Dimensions (column values) that change over time.
1 type : Columns that were relevant earlier are not relevant now and not makes value.
The values of those columns are not updated.
2 type : the values of that column both historical and current are all entirely replaced
3 type: we use an index id , for the products historical values, and have all the start date, date updated, and flagged of which value is current one.
4 type : only the current and the previous value is stored
this is what I have understood from your explanation and planning to answer in the interview. Is it right ?
correct
Such an awesome explanation bhai.. thanks a lot for your genuine efforts to help the community
Glad you liked the explanation.
Very informative!
Glad it was helpful!
Thank you so much. I was looking for it.
Welcome 🙂
Hi,one question from the interviewer "why you use the SSIS package model for the relationship rather than using direct query mode in power bi"
Tell the disadvantages of using direct query connection mode
Bcz we can't see the tables in direct querry mode and it's hard to make the relationship between the tables that's why
Do we have to describe SCD with example by showing in excel?
No. Its just for yr understanding.
Is it possible to get a job in a powerbi developer career gap(M Tech 2017 pass out ) with a fresher?
Yes if you have proper skills in PowerBI and SQL then you will get a job
I have graduated in Bachelor of arts (Economics) If I learn power bi sql azure power app and apply for job do i have a chance or because of my degree they reject me please reply sir
Yes, you can get the job.
Many of the companies are allowing graduation in any degree.