DW Concept: Slowly Changing Dimensions(SCD) |Power BI Interview

Подписаться 60 тыс.

Просмотров 6 тыс.

50% 1

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

Опубликовано:

6 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 17

@sivaranjanisundaram725 Год назад

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 ?

@learnwidgiggs Год назад

correct

@akshay8191 Год назад

Such an awesome explanation bhai.. thanks a lot for your genuine efforts to help the community

@learnwidgiggs Год назад

Glad you liked the explanation.

@shabnamattar5632 Год назад

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"

@learnwidgiggs Год назад

Tell the disadvantages of using direct query connection mode

@Rudra_Gaming10. Год назад

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

@ashu60071 Год назад

Thank you so much. I was looking for it.

@learnwidgiggs Год назад

Welcome 🙂

@rajatdixit11 Год назад

Very informative!

@learnwidgiggs Год назад

Glad it was helpful!

@beingrishi6450 6 месяцев назад

Do we have to describe SCD with example by showing in excel?

@learnwidgiggs 6 месяцев назад

No. Its just for yr understanding.

@pulukuriaparna7020 Год назад

Is it possible to get a job in a powerbi developer career gap(M Tech 2017 pass out ) with a fresher?

@saurabhpal6210 Год назад

Yes if you have proper skills in PowerBI and SQL then you will get a job

@vishnudatt6000 Год назад

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

@learnwidgiggs Год назад

Yes, you can get the job. Many of the companies are allowing graduation in any degree.