Deloitte: Scenario based Question | Ques Collected from a friend | Power BI Interview

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

[@SaiSameerKulkarni]

Interviwer asked me this question recently in 1st round itself. I answered correctly. Thanks for the video

[@learnwidgiggs]

Glad to know this 😊

[@abhishekvrm2777]

Are you selected?

[@anjaligondse]

I enjoy watching this short videos! Thanks for creating super useful stuff, Shashank!

[@learnwidgiggs]

Thank you Anjali 😊

[@kneetotheface]

this is a great example! i knew how to do the merge query technique, however the DAX function i had forgotten. thank you!

[@learnwidgiggs]

You're welcome!

[@bidhanry9740]

I cannot tell you how helpful this is, thanks for the video

[@learnwidgiggs]

Welcome 😊

[@rajatdixit11]

Awesome content again as always! 😊

[@learnwidgiggs]

Thanks again!

[@VivekBiradar-rx8jz]

Thank you so much for your videos which helping many who are looking into Data analytics field. Just a small request, whenever you post scenario based videos please post the files which you have used it will be great help and easy and time saving for us during practice time.

[@learnwidgiggs]

Noted.

[@rajkumarpalle8217]

Thank you.

[@aquibx]

please bring more topics, and thanks for the video..!!!

[@learnwidgiggs]

Plz check out the channel, a lot of videos already published and More to come!

[@swapnakonda9195]

thanks for video

[@JayeshTatipamul]

Very well explained. Thank You

[@learnwidgiggs]

Welcome 🙂

[@sarihaddu]

Thanks a lot. I had no idea we could use Dax for this solution. New thing learned.

[@learnwidgiggs]

Glad to hear that!

[@rajukir-ge9yo]

Thanks for your very knowledgeable video.

[@learnwidgiggs]

Welcome 😊

[@52maheshkumar]

Simple and clear explanation...

[@learnwidgiggs]

Glad you think so!

[@karanmalkhede6689]

thanks

[@devijeslin2114]

Simple and clear explanation 👌

[@learnwidgiggs]

Glad you liked it

[@saiakshay6906]

With calculatecolumn dax or filter can we give those two names two get filtered

[@44.7b.kaharaditya6]

Great Video, Please Share More Videos like this

[@learnwidgiggs]

Thank you, I will

[@thisisphani1644]

Hi sir, I am having a transcation table (Customer name, date ) and date table. I want to see how many new customers came in a month when compared to previuos month in Column chart (y axis- count of new customers vs month) and who are those customers (customer names ) in table . can you please help me ?

[@sangeethdudhagundi6023]

Nice

[@foodstuffstuff2695]

Nice video.kindly post more scenario based questions for those preparing would be helpfull .looking for more scenario based questions. Thanks .

[@learnwidgiggs]

I have already uploaded few more scenario based questions, plz check out the cannel.

[@foodstuffstuff2695]

Sure

[@ganeshsalunkhe3529]

This was awesome video sir ...pls make more video on such scenario based video pls sir

[@learnwidgiggs]

Thanks and sure

[@devijeslin2114]

👍

[@haribabu6363]

Thanks u for explanation

[@learnwidgiggs]

It's my pleasure

[@monishpilla4137]

Good one

[@learnwidgiggs]

Thanks!

[@nagarjuns1062]

👌..please make a video that completely explains data modelling and warehousing techniques #request

[@learnwidgiggs]

Noted, will do a video soon.

[@nagarjuns1062]

@@learnwidgiggs thank you so much for your efforts 💯, eagerly waiting ♥️

[@badaribadari1731]

Good Explanation.

[@learnwidgiggs]

Glad it was helpful!

[@manishsathe8371]

Nice and simple 👍

[@learnwidgiggs]

Thank you 🙂

[@sakshinaik05]

Plz bring more videos on dax optimization

[@learnwidgiggs]

I will do...soon

[@shubhambondre2461]

sir dataset bhi provide kiya kRO

[@rajatbadade20]

Some interviewers want us to calculate orally with notepad and screen sharing

[@lakkudawargave]

Sir where is data set for download

[@heetshah1881]

Hi Shashank, I got below list scenario base question for Power BI Interview In same company. 1)There is a Product table there is certain products with order date. I want to retrive product name with specific order. Panel suggested to use Related function when all the column is in same table. Can you make on video on that? 2)Concatenate list of Product name with category apply the filter want the product for electronics in Product table. ( Is there any alternative of Concatenate function. 3)Sales table I want to filter the sales for North Region what would be the DAX Expression? My answer was =Filter(Sales, Sales[Region] = " North") If you can make on the videos or any suggestion will help

[@indergaming3053]

the third one have a twist brother just tell if they told to create calc column or a measure ? if they told to create a column then its ok but for measure you can use calculate(sum['sales'],Filter(Sales, Sales[Region] = " North") then it will work fine

[@pavan393]

Could you kindly let me this is one of the interview questions I was asked by the interviewer. What is the max limit of columns in Power BI

[@learnwidgiggs]

It is around 16000 columns

[@shrirams3442]

Can you share this excel data? For Practice purpose

[@pradeeppadeliya]

it's Good ..... but can you also provide ( Data Set ) for these questions for all playlist questions. it would be very helpful please ....

[@aishkumar1655]

First Name Last Name Age City State Region A P 1 AB MUM NORTH B Q 2 CD DEL NORTH C R 3 EF GUJ NORTH D S 4 GH MUMA NORTH E T 5 IJ DEL SOUTH F U 6 KL GUJ SOUTH

[@aishkumar1655]

First Name Last Name Age City State Region A P 1 AB MUM NORTH B Q 2 CD DEL NORTH C R 3 EF GUJ NORTH F U 6 KL GUJ SOUTH

[@aishkumar1655]

I have created the sample dataset for this

[@chandrashekhara1]

Where we will get the complete working vedio for all the power query calculation. It would be helpful me to understand from the beginning.

[@learnwidgiggs]

Plz check out this video: kzbin.info/www/bejne/sKeZg4p_hZ6lpsk

[@rahulwagh2414]

Tnx sir for giving more information ,I don't know about " except" DAX fiction its topic helpful for me how to join those records, I also shared this vedio for my friends circle.

[@learnwidgiggs]

Thank you 🙂

[@navyathasnest3687]

I know the answer in Query but not in dax thanks for the video

[@learnwidgiggs]

Welcome!

[@navyathasnest3687]

@@learnwidgiggs If Possible can you please tell me (Rs5500,$200,3000$) if salary column is like this how to extract only numbers

[@learnwidgiggs]

Use 'Column from examples' option in Power Query

[@navyathasnest3687]

@@learnwidgiggs Many thanks 😊

[@krupateja9523]

@@learnwidgiggs can we divide using delimiter by spl charector too?

[@sasidhardadi2335]

Wonderful video, could you please share me the data used in this scenario so that we can practice it

[@learnwidgiggs]

Its a very simple dataset with only 5 records, you can create it on our own, 5 min work that's it.

[@ashwinikhobragade7583]

Hi, can we use intersect in place of Except?

[@learnwidgiggs]

No

[@sumitkadam3679]

I want to give one small suggestion, please record HD Video & upload HD video, it will make a good impact for View.

[@learnwidgiggs]

Yes, I make sure that now. Thanks for the feedback.

[@lakkudawargave]

Sir please provide the data set

[@sathishkumarpati]

We can use NOT CONTAIN also

[@learnwidgiggs]

I am not sure about it

[@KiranKumar-rd1is]

In the interview they are asking what methodology you are using. Could you please explain what is this methodology in Power BI

[@learnwidgiggs]

I am not sure clear your question, it seems question might be different there then what you are asking here.

[@sampathk1861]

As far as I know Methodology means agile or Waterfall or any other...!!

[@waqarmehdi4394]

EXCEPT is one of the three set operation DAX functions in Power BI. The other two are UNION and INTERSECT. Thanks for the knowledge you have shared.

[@learnwidgiggs]

Thanks for the info!

[@socialmedia4587]

Today i attended interview this question asked me on my 1st round ...i have told the same

[@learnwidgiggs]

Great.

[@rahulghule7508]

plz upload possible question on scnario based for experience one

[@learnwidgiggs]

Sure, I will..stay tuned.

[@memesmacha61]

Hi bro I want lo learn power bi could you suggest me best courses to learn power bi please

[@learnwidgiggs]

plz watch this video: kzbin.info/www/bejne/nmqzlY1vgtt4Z8k

[@rallabandasatish6415]

Nice . And I have one doubt if it right anti then what is dax function

[@learnwidgiggs]

Then interchange the tables under except ()

[@monishpilla4137]

what is Z order in power bi it is an interview question

[@learnwidgiggs]

Z order or we can say Layer order, is basically the alignment/layer of visuals in a report sending it front to back or vice versa.

[@himanshubasra4451]

Can we do this by append the queries first and then remove duplicates?

[@nveen5949]

No

[@vikrantgarale7451]

Bro if a person has a 6 years gap after graduation..can he get power bi job if he do it...

[@learnwidgiggs]

I have seen 2-3 yrs gap people getting the job, but I am doubtful about 6 yrs gap. But I hope you will also be considered.

[@vikrantgarale7451]

@@learnwidgiggs thankyou brother for ur rply..I ll work hard to get into it..