Power BI Scenario Based Questions with Solution

Power BI Scenario Based Questions with Solution | Top Interview Questions |

Рет қаралды 21,775

Жыл бұрын

Power BI Scenario based interview questions with solution | Power BI interview | Power BI
Part 1 - • Power BI Scenario base...
Download Data - drive.google.com/drive/folder...
📱 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.
#powerbi
#powerbitutorial
#powerbitutorialforbeginners
#powerbideveloper
#interview
Content
Intro 00:00
Scenario 1
Scenario 2
Scenario 3
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
⭐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- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
⭐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-
⭐Tableau Dashboard-
Road Accident Dashboard - • Tableau Dashboard from...
Sales Overview Dashboard - • Tableau Dashboard from...
HR Dashboard - • Tableau Dashboard from...
Ecommerce Sales Dashboard - • Build Tableau Dashboar...
IPL Dashboard - • Tableau Dashboard | IP...
Customer Complaint Dashboard - • Tableau Dashboard | Cu...
⭐Power BI Dashboard
Road Accident Dashboard - • Power BI Project End t...
HR Dashboard - • Power BI Dashboard fro...
⭐Excel Dashboard
Road Accident - • Full Project in Excel ...
HR Dashboard - • Excel Dashboard from s...
IPL Dashboard - • Excel Dashboard (Hindi...
Ecommerce Sales Analysis - • Dynamic Excel Dashboar...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
WhatsApp on - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Keywords -
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.

Пікірлер: 46

@MasterMinds-pk7vp Ай бұрын

Great teaching highly appreciated.

@venkateswarareddy4744 11 ай бұрын

Very useful, thanks for great video. Made same for power bi service scenario based is much appreciated. Thanks

@amolmane8747 11 ай бұрын

Great video, Linked and subscribed 👍

@ramyasubramanian1218 8 ай бұрын

Hi,I have recently started learning powerBI.But always had a confusion as where and how to start preparing dashboards to add in my portfolio. ur video was so interesting and loaded with lot of info.I prepared my first dasboard.Thank you.

@emilyamalkin4367 9 ай бұрын

Thank you so much, please make more similar videos.

@arunprasath2148 10 ай бұрын

Great work

@user-sn8xy1iw8c 11 ай бұрын

Thank you so much for this insightful video! Your explanations were clear, and I loved the practical examples you shared. It really helped me reduce my learning curve . Keep up the excellent work. Can’t wait to see more of your informative videos in the future. 😊

@datatutorials1 11 ай бұрын

Glad it was helpful!

@vikalp_28 Жыл бұрын

Thank you sir 😄

@pedro-ik1mr 11 ай бұрын

Thanks alot bro those tricks are really useful 🙏

@Satishkumar-gv5ss Жыл бұрын

thank you soooo much sir

@shielamuzdaliffa Жыл бұрын

Thank you so much! You've helped me a lot in learning SQL and Power BI these past few months. I hope you can make another scenarioes using both SQL and Power BI. Thank you

@datatutorials1 Жыл бұрын

Thanks, will do!

@nasbanu8401 11 ай бұрын

Hey @shielamuzdaliffa is SQL, pow bi enuff to get a job in power bi ?

@mbc-ql2fe Жыл бұрын

Thank You, it is very useful to every one

@datatutorials1 Жыл бұрын

You are welcome

@cinemadulaprabhakar Жыл бұрын

Thanks sir

@MegaVeeran 10 ай бұрын

Thanks... this is helpful...is there a way to make first scenario more dynamic using parameters

@jagdeeshs4618 Жыл бұрын

Nice video bro clearly explained...so helpfulll

@datatutorials1 Жыл бұрын

Glad you liked it

@mayankgupta4427 10 ай бұрын

Very nice video 🎉 thank you

@datatutorials1 9 ай бұрын

Welcome 😊

@venkatc1323 Жыл бұрын

Grt- way of handing session but pls take few more sessions for real time use cases like through parameter selection for Rolling N Months , Top N , compare This this year sales wrt previous year sales etc..............

@datatutorials1 Жыл бұрын

Sure

@sandipansarkar9211 9 ай бұрын

finished watching

@anuragshrivastava7855 Жыл бұрын

amazing video

@datatutorials1 Жыл бұрын

Glad you think so!

@brianmegilligan6778 10 ай бұрын

I noticed your months in scenario two are out of order chronologically. They are sorted alphabetically. You need to add a month number column on the calendar table and sort the month column by the month number column.

@madeshwaran5448 11 ай бұрын

please do some videos on etl too.

@datatutorials1 11 ай бұрын

Definitely

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

Thanks for nice videos, Really it is helpful while attending interview , i got an few same questions my last interivew , luckly I watched your videos, (Rolling fashion one year sales Question), Just want to know , for the last six month sales questions, we are able to achieve it LASTDATE instead of Max as well right?.

@animesh7296 6 ай бұрын

FYI, If anyone having issue with Scenario 2, when dropping Max Point measure in the Line Chart, All the markers are getting highlighted. Use the below mentioned measure Max Point 1 = IF(MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]) = [Total Sales], MAXX(ALLSELECTED('Calendar Table'[Month],'Calendar Table'[Month Number]),[Total Sales]),BLANK()) in ALLSELECTED(), i'm giving month number as well.

@KetakiGadgil_15 4 ай бұрын

Thank you for this .But why month number is needed?

@mamathab9883 10 ай бұрын

Hi, I am facing an error while createing line graph in the 2nd question. The error says "Can't convert value "jan" of text to type date while processing column - calender[month]-> sales data[order date] what can I do ?

@vishalsonawane.8905 6 ай бұрын

Don't know TOPN function is not working in my laptop , could you please suggest what should i do?

@pranavvenkata475 10 ай бұрын

Why is the following measure fetching incorrect results for the last six month sales? last six sales = CALCULATE([temp_sales],AND('Calendar'[Date] MAX('Calendar'[Date])-180)). Here temp sales is a measure indicating the total Sales

@rehanorkut Ай бұрын

Excellent Video Thanks a lot for your hard works such video really helps us !!!! I have subscribe to your channel!!!

@happyhotify 6 ай бұрын

For Sale in last 6 month it s calculating for entire Dec month not till last date. Is there any correction?

@syedabadhrunnisa 5 ай бұрын

Hi I am not getting the Max & Min highlight in line chart...y please help me / same method is applied

@subbaraoballipale890 4 ай бұрын

am also not egtting same i followed

@gospelmoto2833 8 ай бұрын

Why not simply use the hierarchial Order Date? instead of creating a new table for Calendar. is there any difference? Thank you for your answer.

@datatutorials1 8 ай бұрын

When you deal with time based calculations it is always recommended to use calendar or date table. It helps you to change the fiscal years, missing dates, time intelligence functions, etc

@gospelmoto2833 8 ай бұрын

Thanks so much!@@datatutorials1

@sakshinaik05 9 ай бұрын

there are 5 columns in a student table and more than 100 students are in the database for different subject marks like physics, chemistry, maths, English and Hindi. If a student login in a dashboard then he would only see his marks not other students marks. How will you achieve this using dax(not to use dynamic rls )