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

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

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

50% 1

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

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

5 ноя 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@manishsathe8371 8 месяцев назад

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

@sumitporchattiwar5268 6 месяцев назад

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 6 месяцев назад

Dhanyawad appreciate krne ke liye 🙏

@VarshaPawar-mx8sn 2 месяца назад

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

@shwaripawar8222 5 месяцев назад

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 ?

@AnalyticsPro1 7 месяцев назад

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

@learnwidgiggs 7 месяцев назад

Great 👍

@dineshrddy 9 месяцев назад

Thanks a lot for sharing this.

@learnwidgiggs 9 месяцев назад

Welcome!

@ASHWATHAMAGAMING1 8 месяцев назад

Thanks for this type of videos sir

@learnwidgiggs 8 месяцев назад

Welcome 🙂

@priyankasarkar6600 7 месяцев назад

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 7 месяцев назад

ok..noted

@sandipansarkar9211 9 месяцев назад

finished watching

@user-zp6go2tz2r 9 месяцев назад

Thanks a lot sir

@learnwidgiggs 9 месяцев назад

Welcome!

@biswadeepsahoo 8 месяцев назад

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 8 месяцев назад

Great 👍

@sagarchaurasia3342 8 месяцев назад

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

@learnwidgiggs 8 месяцев назад

Great 👍

@prithiskarmakar2638 22 дня назад

🙏🏻

@rahulmishra1523 9 месяцев назад

nice

@user-ux5sp1uc7o 8 месяцев назад

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 8 месяцев назад

Amazing news, Many congratulations ❤️

@user-ux5sp1uc7o 8 месяцев назад

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

@biswadeepsahoo 8 месяцев назад

congratulations

@panisairaghava3836 8 месяцев назад

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

@user-ux5sp1uc7o 7 месяцев назад

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

@RiddheshTarri-td8io 8 месяцев назад

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

@syedabadhrunnisa 6 месяцев назад

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]

@pravalib408 8 месяцев назад

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 8 месяцев назад

Can you please send me the question properly through mail

@AnalyticsPro1 7 месяцев назад

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

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

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

@dileep2563 9 месяцев назад

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 8 месяцев назад

I will post a video on these questions..soon

@shraddhadhakad1154 8 месяцев назад

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

@krishbala9822 2 месяца назад

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

@krishbala9822 2 месяца назад

Please try dis code working well simple logic only used

@shivanandbirajdar8320 9 месяцев назад

How can i connect with you, i have some doubts

@learnwidgiggs 9 месяцев назад

You can ping me on LinkedIn

@princesrivastava4475 9 месяцев назад

Looks easy but it's Very complicated 🥲🥲

@learnwidgiggs 9 месяцев назад

I hope you understood it.

@abutalha2929 8 месяцев назад

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.

@shubhamgophane5414 6 месяцев назад

@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 6 месяцев назад

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

@shubhamgophane5414 6 месяцев назад

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