#tcs 📊TOP 10 Scenario Based #powerbi Interview Q And A🔥[ For Freshers/Experienced Candidate ]

#powerbi #powerbi_training #powerbi_interview_Question
#scenario_based_PowerBI_Interview_Q&A #deloitte #milestonecreator

Hey, Everyone Welcome back to our Channel "Milestone Creator". In this video, I will share with you the Top 10 Most Important Scenario-based Power BI interview questions that were asked by the TCS interviewer during the interview process for the Power bi dveloper job role. ok and let me tell you This question was provided to me by one of my friends who is currently working at #capgemini and recently given the interview for power BI developer at #tcs That's why, I thought of creating a video on this so that everyone can be aware of these scenario-based questions so that it will be more helpful for all of you.

And let me tell you another thing this video is the combination of all the above 10 scenario-based Power BI interview questions that I have uploaded before in this playlist. So, previously if you have watched those then you can ignore this video.

So, let's discuss those top 10 questions Along with Ans one by one. But before that, if you're new to the channel then do subscribe and hit the Bell icon to stay updated with all the coming useful videos.

✅Related Tags:-

Real-time Power Bi Interview Questions and Answers
Power Bi interview questions
Power Bi interview questions and answers
Power Bi interview
Power Bii 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
Power Bi scenario-based questions
#sql and Power Bi interview questions
#capgemini Power Bi interview questions
#accenture Power Bi interview questions
#tcs Power Bi interview questions
#techmahindrajobs Power Bi interview questions
#hcl Power Bi interview questions
power bi-managerial round interview questions
how to explain a project in Power Bi interview
Power Bi roadmap
Power BI jobs for freshers
Power BI resume for freshers
Power Bi fresher jobs
Power Bi resume
Power BI developer resume
Tips and Tricks Before POWER BI Interview

------------------------------------------------------------------------------
✅ Additional resources
------------------------------------------------------------------------------
#deloitte 📊TOP 10 Scenario Based POWER BI Interview Q And A🔥:-

#tcs 📊TOP 10 Scenario Based #powerbi Interview Q And A🔥[ For Freshers/Experienced Candidate ]:-

📊 Complete Power Bi interview Q & A For Freshers - [ Latest 2023 ]:-

DAX Interview Questions and Answers - POWER BI [ Part - 1 ]🔥:-

DAX Interview Questions and Answers - POWER BI [ Part - 2 ]🔥:-

Super 30 DAX Interview Question & Answer - POWER BI🔥:-

Introduction To DAX:-

What Is DAX - Power Bi ? 📊Complete Introduction🔥:-

🔔 Subscribe to my YouTube channel:-

Social Media Link
--------------------------------

[Resh_Aadil_AllaboutExperience]

Hi bro.... try explain scenarios based on standard datasets like sample superstore, coffee chain data etc. for all your vedios...so that we can practice it immediately.

[krishnakantapanda]

In the last question i.e., to find running total sales,
Instead of using sumx iterator function, the best practice would be to use the below dax for getting the same desired output -

Running total =
Calculate (
Sum ( SalesDetail[sales]),
Filter ( All(SalesDetail),
SalesDetail[Order Date] <= max( SalesDetail[Order Date]
)
)


The above formula would optimize the dax as we are not using any iterator functions to obtain the goal.

[krishnakantapanda]

In the 3rd question,
Instead of creating a new table (which would increase the size of the model),
The more efficient way would be to simply create a new calculated column [Sort] on the same sales_ table and then we can perform the same sorting process.

I.e.,

Sort =
switch ( 'Sales_table'[Product_Name],
"Refrigerator", 1,
"TV", 2,
"Mobile", 3,
"AC", 4,
"Cooler", 5
)
Then we can sort the x axis of the column chart using this calculated column (Sort)

[himasrikavuri]

Hello bro, I installed PowerPoint by watching ur video but my ppt files are not opening and it's showing ''this copy of Ms office is not activated''. Plz help me bro what to do next

[wiwzbfc]

In question 3, If we have 50 product then what we do

[krishnakantapanda]

In the 2nd question -> We can simply use except function to get the desired output i.e., only the records from table A (excluding the matching records from table B)

The except function would give the same output as that of implementing a left-anti join of the required tables.