Power BI Scenario based interview questions with solution | Power BI interview | Power BI |

#powerbi #interview #powerbitutorial
Power BI Scenario based interview questions with solution | Power BI interview | Power BI
Part 1 - • Power BI Scenario base...
Part 2 - • Power BI Scenario Base...
Download Data - drive.google.com/drive/folder...
⭐Power BI Material (Notes, Interview Questions, 2 Projects, etc.) - topmate.io/data_tutorials/536295
Data Modeling in Power BI - • Data Modeling in Power...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - profile.php?...
⭐Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
⭐For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
This video covers Power BI scenario based interview questions and their solution in detail.
The vide will be helpful for the people who are looking for a job change in Power BI Domain or for freshers who have done a Power BI course and trying to get a job as a Power BI developer or Data Analytics.
⭐Content
Intro 00:00
Scenario 1 01:09
Scenario 2 19:35
Scenario 3 25:33
Outro 32:01
➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - • Data Analyst Roadmap 2...
Details mentioned below-
email- [e-mail]
WhatsApp - [phone]
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hashtags -
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, PowerBI Data Visualization, Power BI Data Analytics, Power BI Analysis, PowerBI Report and Dashboard Design, Power BI End to End Tutorial, PowerBI End to End Project, PowerBI Data Modeling, What is PowerBI, How to use PowerBI, Power BI Tutorial for Beginners - Basics and Beyond, Power BI Tutorial for Beginners - Getting Started, Analyze & Visualize Data with Power BI, Mastering Microsoft Power BI - Introduction to Power BI, Power BI Tutorial For Beginners | Introduction to Power BI
Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.

[@AshishTiwari-ug2lg]

Hey Man, I have been working as a power BI developer for more than 1.5 years and the way of your teaching is something extraordinary. I have seen many videos of Dax, but people who are teaching are expressing themselves like they are full of knowledge and even they are showing that DAX is rocket science and unable to break down this easily. Kudos to you brother that you made it simple. I subscribed to you and wish you all the best in your future. Love You, Brother.

[@Irfankhan_56]

Refer us also bro. That will help any one of us in this community. Finding a powerbi job's now a days very tough.

[@TwoMinutesisEnough]

You are champion and I have subscribed as part of that 80%

[@datatutorials1]

Thanks you bro

[@ashish90702]

Thanks a lot for this video 👍👍 Please provide more such interview related Power BI videos

[@user-pi8fe6nr3i]

You are simply superb, thanks a ton for helping the unknown like me unconditionally. Grateful.🙏

[@emilyamalkin4367]

Thank you! I love your videos you your presentation style 👍🏻👍🏻👍🏻👍🏻👍🏻❤

[@biswadeepsahoo]

Your explanation skill is excellent

[@shambavivusirikala1355]

Thanku for ur informative videos...lot of knowledge to gain

[@yamin800]

Please add more videos like this, loved it

[@ramshataqdees5570]

thanks alot.... please make more vdos on powerbi scenario based interview questions

[@riasingh11]

what great learning i've had! 🌟

[@user-ne1ey8sz9v]

Very Useful content,Thank You Sir.

[@datatutorials1]

Keep watching

[@beneficial4u572]

Subscribed, Please keep on posting

[@datatutorials1]

Thanks

[@amalayadav7406]

Nice explanation Sir. Please post Power BI course videos on all the topics.

[@vishwassharma3312]

Kindly Upload more such type videos?

[@aishwaryapattnaik3082]

Your videos consistently offer excellent content and valuable insights. This one cleared up a long-standing confusion I had between rolling sums and running sums, and I'm genuinely thankful for that.😇 If possible, could you please offer a solution for scenario 1, where dealing with inconsistent dates or months when calculating rolling sums becomes a challenge? Your content is highly appreciated, and I'm looking forward to more of it in the future.

[@emilyamalkin4367]

You need to link your “inconsistent date” to the date in the date table (which is always consistent) , and then use the date from the date table to calculate your totals.

[@shivang18]

For third scenario, we could have used YEARTD function

[@vishalsonawane.8905]

Thanks for sharing data and please make video on Dynamic Slicers on Different Date because In TCS interview they ask me the Question.

[@nidhisingh4973]

Can you please elaborate the question?

[@vishwassharma3312]

Sir . Is your play list enough to give an interview on power bi with 2 years of experience?

[@abrahamvincent6272]

Hi Sir, In scenario 1, we can take 'Today' function instead of 'Max(calender(date))' function right? in Datesinperiod function.

[@datatutorials1]

Yes if you are working with real time data

[@swatiparekh]

Second Scenario is not working for me, still it is showing rank 1 to all Rank = RANKX(All(Sales_Data), CALCULATE(SUM(Sales_Data[Sales])))

[@ShaikJaheer-yh3bs]

Sir provide all tableau scanarios as well

[@abhishekchaturvedi6981]

Can't we use direct functions for running total like YTD, MTD type ?

[@datatutorials1]

How will you use these functions here. ytd is based on financial year and mtd is for current or latest month in dataset

[@kapur.betzy2023]

Absolutely loving the content! Subscribed today and already binged most of the videos. 😄 Could you create more full-scale projects like the ones on Maven and Onyx? Your teaching style is unique, and your voice is quite soothing. Thanks for the awesome content!"

[@itsall5180]

In scenario 2 rankx is not working. Too few arguments were passed to the rankx function. The minimum argument count for the function is 2.

[@ashokpandey5010]

I guess there's some conflicts in Rolling Month Sales Addition, It's not giving rolling sales accurately. I would like to request you to please check if this is correct or not.

[@datatutorials1]

It is correct

[@poojagrpoojagr7236]

I had buyed material of interview questions but it is not opening

[@datatutorials1]

Download it first

[@swatiparekh]

Rolling12MonthsSales = CALCULATE( SUM('orders'[sales]), DATESINPERIOD('orders'[order_date], LASTDATE('orders'[order_date]), -12, MONTH) )

[@rishavshikary5034]

Subscribe karna jaruri hai ?

[@datatutorials1]

You will het notified with latest video and it will help me reach more peoples.

[@santoshkumbar8780]

How to contact u bro

[@datatutorials1]

Book a call, find link in description