STARTUP - 2 Power BI Interview Questions you must know😲

[@learnwidgiggs]

Dataset Link- docs.google.com/spreadsheets/d/1IalLi_53RTGUc6wCWcT-zUwbKj1I-TH9/edit?usp=sharing&ouid=102679157628567582944&rtpof=true&sd=true

[@9dotvideos229]

Even the chart you selected is stacked column chart . As per the question it should be bar chart not column chart . And thanks for the question.

[@sammyd4042]

You should make more of this videos ❤❤

[@virajdudhat3664]

Thankss buddyy, please make more videos on such topics and advanced concepts (normal wale har jagah pe haii)

[@vikassinghjayara510]

Nice questions and a very good explanation

[@learnwidgiggs]

Glad you found it helpful.

[@manikantaneralla6446]

I liked your way of explanation, bro..

[@learnwidgiggs]

Glad you liked it!

[@datadecoder_sai]

Could you please help me solving the below query: I have pharma dataset with these fields: Company, Drugs, Medicine, Year, Sales. I have just 2 visuals: 1. Bar Chart: Displays medicines vs sales. 2. Table: Displays all the column/rows from the pharma table. Functionality: When a user clicks on a medicine in the bar chart, the table should automatically update to show all alternate medicines that belong to the same drug but exclude the selected medicine.

[@shelby1999]

maybe ALLEXCEPT should work here ? which would keep filter on for column medicine

[@vishalnasre1251]

Did you found any solution ? if not can u share the dataset link.

[@sahasransupanda8169]

If(table[medicine]!=selectedvalue(table [medicine]),[total sales],blank())…pull this measure instead of total sales in table

[@AkankshaSingh-m6c]

Thanks for sharing 🙌🏻

[@nakuldeep7336]

this function not working on sales data please advice

[@Sandeepsingh_unique]

Wow bhaiya 😇

[@ThumballaGurumurthy]

in first question divide function first used inbuilt dax and in dinominator used measure please expalin it sir

[@ashutoshdas7534]

how to arrange month axis in right order ? why it showing wrong order ?

[@DataTuner]

Months are in text and by default power bi doesn't recognize text and sort it chronologically. To resolve this create a column with month number and then sort it using month number.

[@nandana_v613]

You have to go to the table view and sort the month column by Product ID

[@Datazone12]

there is a sort by option, just select it and choose sort by product id or which ever column you created to represent the month names.

[@ashutoshdas7534]

@@DataTuner Thnk u

[@ashutoshdas7534]

@@nandana_v613 Thnk u

[@zuberkhan9582]

Sir can share with us all interview questions answers in data analytics??

[@komalkapoor9446]

You used python for the measure?

[@ashishdhoundiyal1066]

Question to your answer for first one, just use Rankx function in your dax and use dense or skip as per requirement. It seems I am seeing your old vedio.😂

[@padmajarao4907]

You have calculated cost top 5 sum based on revenue top 5 .. can you check that and change

[@sunnygawande5283]

Where to practice DAX questions? Is there any website that is dedicated to challenging Dax questions just like stratascratch or data lemur ?

[@saurabhmaurya6885]

Use chatgpt

[@RaviTeja-s9v]

how to apply for startups

[@shinestarenglish6952]

Hi, I have one of my connection who is working in PWC and I also want to join PWC, I have better knowledge of advanced Excel and power BI but I didn't work on SQL but I know basic SQL query. Can I get job in PWC this 2 skills.

[@mindofmagnet3373]

Practice interview problems on SQL so that you can learn SQL quickly

[@jyotiSingh-vr3zb]

is this for 1 year of exp?

[@basavarajarun5520]

Hi Shashank, I have six months of experience as data analyst internship and I m getting referral from employees also but they are asking 1.6 year of experience How to get a job as fresher

[@mamtaskitchenhealthyfood]

Hey..how I get job in power bi domain..I am searching in Bangalore

[@ThumballaGurumurthy]

Same please tell us

[@88shivakumar]

Why 18.37%? it should be 59.38%. Can you clarify?

[@Chinmayimanvi]

It should be 46.88%. It is said that we need to generate top products based on the highest sales and then find the contribution percentage of profit from those top products. var top5 = TOPN(5,Sales_Fact_Table,Sales_Fact_Table[Total Qty Sold]) var total_cost = CALCULATE(SUM(Sales_Fact_Table[Total Cost]),top5) var total_revenue = CALCULATE(SUM(Sales_Fact_Table[Total Revenue]),top5) RETURN DIVIDE(total_revenue-total_cost,SUM(Sales_Fact_Table[Total Revenue])-SUM(Sales_Fact_Table[Total Cost]),0)

[@tripatisahu8579]

@@Chinmayimanvi where it is asked the contribution?

[@ankitdhoot5408]

But TopN can also use in filters

[@jaitiwari241]

But profit % is total profit/total revenue hota hai ..yaha denominator me ..total cost kyu hai..can anybody explain

[@tripatisahu8579]

Subtract Total Cost from Total Revenue to get Profit: Profit = Profit=Total Revenue−Total Cost Divide the Profit by the Total Cost: Multiply by 100 to convert it into a percentage:

[@9dotvideos229]

Why are you calling column chart a bar chart

[@govind_dataanalyst]

Column chart is a type of bar chart , as we have vertical bars in column chart that's why we say it columns

[@9dotvideos229]

@TheAnalyticsEngine ok

[@9dotvideos229]

@TheAnalyticsEngine but the chart selected over here already have name so we can not say it bar chart .you can check it in BI

[@gudurisowjanya-mm4xl]

What happens of 2 values from top 5 have a same value? Please tell.

[@Pappu_bhau_0]

Made vedio after long time 😡