Deloitte: Scenario based question | Power BI Interview | Part-4
Vložit
- čas přidán 5. 11. 2023
- 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
Avg Price Final = IF(HASONEVALUE(Products [Name]),[Avg Price],SUM(Products[Price])) ..............Well Done 👍
Bhai tum to bhagwaan ho
U r helping us lyk an angel...
Itna to power bi offline classes m b koi hlp ni krta...
❤😊
Dhanyawad appreciate krne ke liye 🙏
We can achieve this by writing below dax
Average= sumx(table name, calculate ( average (table[price],all(table name)))
Thanks a lot for sharing this.
Welcome!
Thanks for this type of videos sir
Welcome 🙂
finished watching
Shashank your Content is Too good
I am also learning Some Scenarios from your channel
Keep it up
Great 👍
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 ?
nice
Thanks a lot sir
Welcome!
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.
ok..noted
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])
Great 👍
Thanks for this video, i have tried this as a practice also we can use isinscope function
Great 👍
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.
Amazing news, Many congratulations ❤️
@@learnwidgiggs I switched from non tech domain to this. Your videos helped me at lot.
congratulations
Can you please let us know in which company did you get an offer
@@panisairaghava3836 I'm not comfortable with mentioning the company name. It's an Indian Private Bank.
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
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]
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.
Can you please send me the question properly through mail
Calculate(sum(sales),stationery items=“Pencil”&& ‘color =“Red”
Avg Price =
IF(
HASONEVALUE('Sample Product'[Name]),
AVERAGEX(
ALL('Sample Product'[Name]),
[Price sum]
),
SUM('Sample Product'[Price])
)
AvgpriceTotal =
Var TotalPrice = SUM(Product[Price])
Var ColumnCount = Count(Product[Name])
RETURN
DIVIDE(TotalPrice,ColumnCount,0)
Please try dis code working well simple logic only used
How can i connect with you, i have some doubts
You can ping me on LinkedIn
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..?
I will post a video on these questions..soon
difference bw pie chart and donut chart.. --did you get appropriate answer?
@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]))
If it is giving the same result then yes its absolutely fine.
@@learnwidgiggs yes it is giving the same result. Thank you for the reply😊
Looks easy but it's Very complicated 🥲🥲
I hope you understood it.
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.