Deloitte: Scenario based question | Power BI Interview

Deloitte: Scenario based question | Power BI Interview | Part-4

Рет қаралды 11,598

8 ай бұрын

Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
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

Пікірлер: 46

@manishsathe8371 6 ай бұрын

Avg Price Final = IF(HASONEVALUE(Products [Name]),[Avg Price],SUM(Products[Price])) ..............Well Done 👍

@sumitporchattiwar5268 5 ай бұрын

Bhai tum to bhagwaan ho U r helping us lyk an angel... Itna to power bi offline classes m b koi hlp ni krta... ❤😊

@learnwidgiggs 5 ай бұрын

Dhanyawad appreciate krne ke liye 🙏

@VarshaPawar-mx8sn Ай бұрын

We can achieve this by writing below dax Average= sumx(table name, calculate ( average (table[price],all(table name)))

@sandipansarkar9211 7 ай бұрын

finished watching

@AnalyticsPro1 6 ай бұрын

Shashank your Content is Too good I am also learning Some Scenarios from your channel Keep it up

@learnwidgiggs 6 ай бұрын

Great 👍

@shwaripawar8222 4 ай бұрын

Hi Sir , attended interview 2nd round of Capgemini on 1st Feb. These are the questions asked. could u please help us with the ans. 1)can we use Username and userprinciple name in static RLS 2) Does Power bi maintain/store historical data and how? 3)is it possible to create drill down and drill up on 3 fact tables 4)if there are constraint applied on table, does Primary key and Foreign key will affect in power bi? 5)if we are taking data from DB, table has 6k rows and table got truncated has only 1 k rows. Does Power bi will have all the 6 K rows from the table? 6)how will u identify type of license looking at workspace? what is the size of workspace? What is the unit testing in power bi? do u do the report validation, how do u do that? how will you cross verify the data which is coming from data source to report? did u done any automation? what is dual mode ?

@rahulmishra1523 7 ай бұрын

nice

@ASHWATHAMAGAMING1 7 ай бұрын

Thanks for this type of videos sir

@learnwidgiggs 7 ай бұрын

Welcome 🙂

@dineshrddy 7 ай бұрын

Thanks a lot for sharing this.

@learnwidgiggs 7 ай бұрын

Welcome!

@priyankasarkar6600 6 ай бұрын

Hello Shashank Sir, I hope you are doing well. Recently, I collected a few questions from my friend, she had an interview with Accenture. The questions are easy to answer. but can you please explain with a proper example? 1: Data type changed in semantic model name 2: Can you please explain a few key types that are very new in power-BI services? 3: For the top 5 customers, which chart is good to show? waterfall or bar chart, and why? 4: IF function example 5: In transforming data, what are the things you can do for data cleaning? 6: If the data loading source is any share point location, can you connect the gateway to it? 7: What is cross-filtering? 8: snowflake and star schema differences with examples 9: Fact tables and dimension tables differ with examples.

@learnwidgiggs 6 ай бұрын

ok..noted

@user-zp6go2tz2r 7 ай бұрын

Thanks a lot sir

@learnwidgiggs 7 ай бұрын

Welcome!

@user-ux5sp1uc7o 7 ай бұрын

Thanks a lot for your videos, I was able to acquire a role in the Banking sector as an Analyst in the Data Analytics domain.

@learnwidgiggs 7 ай бұрын

Amazing news, Many congratulations ❤️

@user-ux5sp1uc7o 7 ай бұрын

@@learnwidgiggs I switched from non tech domain to this. Your videos helped me at lot.

@biswadeepsahoo 7 ай бұрын

congratulations

@panisairaghava3836 7 ай бұрын

Can you please let us know in which company did you get an offer

@user-ux5sp1uc7o 6 ай бұрын

@@panisairaghava3836 I'm not comfortable with mentioning the company name. It's an Indian Private Bank.

@sagarchaurasia3342 7 ай бұрын

Thanks for this video, i have tried this as a practice also we can use isinscope function

@learnwidgiggs 7 ай бұрын

Great 👍

@biswadeepsahoo 7 ай бұрын

I have used this and found the answer. Avg Price = CALCULATE(AVERAGE('Product'[Price]),ALL('Product'[Product Name])) Then Avg 2 = IF(ISFILTERED('Product'[Product Name]),[Avg Price],[Total Price])

@learnwidgiggs 7 ай бұрын

Great 👍

@syedabadhrunnisa 5 ай бұрын

Hi Please can you help me in this this is dynamic TopN measure while it is selected it shows the value of selected according to product id ,{TOPN 1 = IF([RankX Products]

@RiddheshTarri-td8io 7 ай бұрын

Bro can you create a video on how to make ATS friendly resume for data analyst (as fresher).. Coz hiring process is far away...they are not even sending mails man😂😂😂is there apart from that am doing wrong? Please... it will be great help

@rahulmehla2014 14 күн бұрын

Avg Price = IF( HASONEVALUE('Sample Product'[Name]), AVERAGEX( ALL('Sample Product'[Name]), [Price sum] ), SUM('Sample Product'[Price]) )

@pravalib408 7 ай бұрын

Hi Today I faced one power BI Scenario in Deloitte Interview Scenario: stationary pen, pencil, eraser name sales color Write a DAX query to calculate the sales of the Pencil with red color. Could you please make video on this scenario.

@learnwidgiggs 7 ай бұрын

Can you please send me the question properly through mail

@AnalyticsPro1 6 ай бұрын

Calculate(sum(sales),stationery items=“Pencil”&& ‘color =“Red”

@shivanandbirajdar8320 7 ай бұрын

How can i connect with you, i have some doubts

@learnwidgiggs 7 ай бұрын

You can ping me on LinkedIn

@krishbala9822 Ай бұрын

AvgpriceTotal = Var TotalPrice = SUM(Product[Price]) Var ColumnCount = Count(Product[Name]) RETURN DIVIDE(TotalPrice,ColumnCount,0)

@krishbala9822 Ай бұрын

Please try dis code working well simple logic only used

@dileep2563 7 ай бұрын

Here are the few questions which are asked for me in today's power bi interview (tech mahindra) 1.How power bi will identify country as a different data type...? 2.How will power bi will compress more than 1gb file to less than 1gb while loading..? 3.What is power bi architecture...? 4.What is data flow..? 5.Power bi works on what engine..? 6.How to create Multiple line chart..? 7.diffrence bw pie chart and donut chart..? 8.what is RLS...? 9.what is index column in power bi..? CAN ANY ONE HELP ME WITH Answers for first 2 questions..?

@learnwidgiggs 7 ай бұрын

I will post a video on these questions..soon

@shraddhadhakad1154 7 ай бұрын

difference bw pie chart and donut chart.. --did you get appropriate answer?

@shubhamgophane5414 5 ай бұрын

@learnwidgiggs If we consider the performance, is it okay to use DAX as below. For the performance I just try to avoid Iterator function here Avg total_1 = if(HASONEVALUE(Sheet1[Products]),[Avg price],sum(Sheet1[Price]))

@learnwidgiggs 5 ай бұрын

If it is giving the same result then yes its absolutely fine.

@shubhamgophane5414 5 ай бұрын

@@learnwidgiggs yes it is giving the same result. Thank you for the reply😊

@princesrivastava4475 7 ай бұрын

Looks easy but it's Very complicated 🥲🥲

@learnwidgiggs 7 ай бұрын

I hope you understood it.

@abutalha2929 7 ай бұрын

It's simple brother, first the dax formula looks the total no of values in the product name column, if it's a single value then it goes for [Avg Price] but that's not the case here because the product column has total 6 values so the HASONEVALUE formula returns false and it goes for sumx. Now re-watch the video again.