Deloitte: Must know Scenario based question | Power BI Interview 😲

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

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

50% 1

Codebasics Data Analyst Bootcamp Link:
codebasics.io/...
-------------------------------------
Stuck? Book 1:1 call here - topmate.io/lea...
-------------------------------------
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
data analyst interview questions and answers
data analyst jobs for freshers
power bi scenario based interview questions
power bi interview questions learnwidgiggs
power query interview questions
how to get interview calls in power bi
data analyst jobs for freshers 2024

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

30 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@learnwidgiggs Месяц назад

Dataset Link- docs.google.com/spreadsheets/d/1PTxbDLJGUwgSAWziNyYejtZulx_77Zru/edit?usp=sharing&ouid=102679157628567582944&rtpof=true&sd=true

@VinayBhagat-kr6ku Месяц назад

Super 💯

@tianime1202 Месяц назад

Great work thankq sir ❤

@adnanashraf615 Месяц назад

👏i was waiting for last 5 sec i:e dataset

@gopinathkamble3042 Месяц назад

UNI = DISTINCT( UNION( SELECTCOLUMNS(Table1,Table1[Country],Table1[City]), SELECTCOLUMNS(Table2,Table2[Country],Table2[City]) ) )

@gagansingh3481 Месяц назад

Yes union will hit first to my mind .

@jaganp5731 Месяц назад

Hai sir are you working in data analyst fields

@sahilummat8555 4 дня назад

Final = UNION( SUMMARIZE(data1,data1[Country],data1[City]), SUMMARIZE(data2,data2[Country],data2[City]) )

@hazard_2444 Месяц назад

An easy, one-liner approach would be summarizing the total appended table (using DAX). Given Table1, Table2 as the two tables and Table3 as the output table, we can write this: - Table3 = SUMMARIZE(UNION(Table1,Table2),Table1[Country],Table1[City])

@Naresh70335 Месяц назад

We can Append two tables and remove transactions column & duplicates

@hazard_2444 Месяц назад

@@Naresh70335 yes but i guess here the approach asked more for a programmatic DAX one instead of Power Query transformations

@passionpreneur9740 Месяц назад

Can this be done in the below mentioned way ? New table = VAR a = ALLNOBLANKROW(Sheet1[Country],Sheet1[City]) VAR b= ALLNOBLANKROW(Sheet2[Country],Sheet2[City]) RETURN UNION(a,b)

@Mahakal-ka_ladla Месяц назад

Why u not speak in hindi sometime by which we can understand easily

@spoorthiu9169 Месяц назад

It was very useful to learn it. Thank you for bringing up this in your channel & shared with us👍🙏

@amitkumarkumarsinghpiyush323 5 дней назад

how you are getting next line while creating dax

@rahulmehla2014 Месяц назад

my way :- NewTable = VAR T1 = SUMMARIZE( Table1, Table1[Country], Table1[City] ) VAR T2 = SUMMARIZE( Table2, Table2[Country], Table2[City] ) RETURN UNION(T1,T2)

@jaldaamol46 Месяц назад

Your code and Shashank's code both are same only. But he created another variable for result and used in the Return.

@rahulmehla2014 Месяц назад

@@jaldaamol46 i did not watch the video earlier I solved first then posted

@bhajanmarg35 Месяц назад

Can anyone guide me how i learn dax any source or other way to learn dax deeply.

@sonalijain9024 Месяц назад

My approach of solving this problem : Final_table = UNION(GROUPBY(Sheet1,Sheet1[Country],Sheet1[City]),GROUPBY(Sheet2,Sheet2[Country],Sheet2[City]))

@smitpatel8782 Месяц назад

var a= SUMMARIZE('Table1','Table1'[Country],'Table1'[City]) var b = SUMMARIZE('Table2','Table2'[Country],'Table2'[City]) return UNION(a,b)

@farhanraza42744 Месяц назад

Another Way to do :- UNION( ALLNOBLANKROW('Page 1' [Country], 'Page 1' [City]), ALLNOBLANKROW(Page 2'[Country], 'Page 2'[City]) )

@pavanikutala8657 Месяц назад

Comment

@fearlessoutingvlogs7898 Месяц назад

Bro do you have power pdf interview question answers theoretical other than real time scenario?if you have can you please send the link

@nurunnahar8550 Месяц назад

Hello sir, i need a mentor to guide me . I want to learn advanced power bi and Dax functions. Please help me sir.

@atulshinde5343 Месяц назад

Sir video is very nice. Sir I want to learn dax deeply to like this video..pls give feedback how can I do that.

@vemulasaikrishna3838 Месяц назад

Thank you for these type of quesions. It wil really help to beggiers to build concepts

@rameshkunda6775 Месяц назад

Could you please do the Data Analysis on Real Estate Project.

@irshad9341 Месяц назад

Why calls are not coming for interview . Are we in recession?

@gagansingh3481 Месяц назад

I can’t image these simple questions asked in Big firms

@learnwidgiggs Месяц назад

It might look easy to you now but on the spot when asked many people will take a lot of time.

@LawkhwinderSingh Месяц назад

Bro please help i am working as associate campaign analyst in one of a firm it is mobile marketing domain .where my work is to analyse the data and optimize campaign generally we use excel and little bit power bi .can you please tell how to switch to data engineer field . I am myself a engineer have knowledge of power bi excel sqp python pandas please tell@@learnwidgiggs