Deloitte: Must know Scenario based question | Power BI Interview 😲
Вставка
- Опубліковано 10 вер 2024
- 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
Dataset Link-
docs.google.com/spreadsheets/d/1PTxbDLJGUwgSAWziNyYejtZulx_77Zru/edit?usp=sharing&ouid=102679157628567582944&rtpof=true&sd=true
Super 💯
Great work thankq sir ❤
👏i was waiting for last 5 sec i:e dataset
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])
We can Append two tables and remove transactions column & duplicates
@@Naresh70335 yes but i guess here the approach asked more for a programmatic DAX one instead of Power Query transformations
UNI =
DISTINCT(
UNION(
SELECTCOLUMNS(Table1,Table1[Country],Table1[City]),
SELECTCOLUMNS(Table2,Table2[Country],Table2[City])
)
)
Yes union will hit first to my mind .
Hai sir are you working in data analyst fields
It was very useful to learn it. Thank you for bringing up this in your channel & shared with us👍🙏
Thank you for these type of quesions. It wil really help to beggiers to build concepts
My approach of solving this problem :
Final_table =
UNION(GROUPBY(Sheet1,Sheet1[Country],Sheet1[City]),GROUPBY(Sheet2,Sheet2[Country],Sheet2[City]))
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)
Can anyone guide me how i learn dax any source or other way to learn dax deeply.
I can’t image these simple questions asked in Big firms
It might look easy to you now but on the spot when asked many people will take a lot of time.
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
Rightly said@@learnwidgiggs
Yaaa super useful,and kindly post real time scenarios in the channel I follow u bks u explain well.
😅
Sure I will
Could you please do the Data Analysis on Real Estate Project.
my way :-
NewTable =
VAR T1 =
SUMMARIZE(
Table1,
Table1[Country],
Table1[City]
)
VAR T2 =
SUMMARIZE(
Table2,
Table2[Country],
Table2[City]
)
RETURN
UNION(T1,T2)
Your code and Shashank's code both are same only. But he created another variable for result and used in the Return.
@@jaldaamol46 i did not watch the video earlier I solved first then posted
he build question itself they say in video like Deloitte question ,
very clever
@@code_with_logic449 how will I build the question on my own 😀
I received the question in my LinkedIn chat.
Another Way to do :-
UNION(
ALLNOBLANKROW('Page 1' [Country], 'Page 1' [City]),
ALLNOBLANKROW(Page 2'[Country], 'Page 2'[City])
)
Thanks for sharing
var a= SUMMARIZE('Table1','Table1'[Country],'Table1'[City])
var b = SUMMARIZE('Table2','Table2'[Country],'Table2'[City])
return UNION(a,b)
Sir video is very nice. Sir I want to learn dax deeply to like this video..pls give feedback how can I do that.
Why calls are not coming for interview . Are we in recession?
Bro do you have power pdf interview question answers theoretical other than real time scenario?if you have can you please send the link
Hello sir, i need a mentor to guide me . I want to learn advanced power bi and Dax functions. Please help me sir.
why didn't we use distinct before union in dax and how it didn't added duplicated without using distinct
Union removes duplicate values. Union all keep duplicate values
sir,keep doing this type vedio these are very helpfull
Thank you, I will
Why u not speak in hindi sometime by which we can understand easily
how to talk you in person sir if possible
Hi bro, how to talk to you?
Comment