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

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

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

50% 1

Power BI Scenario based interview questions with solution | Power BI interview | Power BI
📱Book a 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
Download Data - drive.google.com/drive/folder...
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
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - profile.php?...
⭐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.

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

23 май 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@pankajjangir7928 10 месяцев назад

Such a great video, very crisp and to the point with proper explanation...Great Work

@HappyLandTravel 10 месяцев назад

Your channel is so useful! Thank you

@satyabobby6248 10 месяцев назад

Very useful, clean explanation. This comes only by exp.

@Satishkumar-gv5ss Год назад

superb sir thank you for making interview series

@nissypradeep4552 4 месяца назад

Very good Explanation. and Thanks for the data provided in drive.

@Sirigineedi_Navann Год назад

Superb video very useful for all the BI aspirants please try to make videos like this.

@rukesh.m9799 8 месяцев назад

Very usefull video.Thanks for giving dataset also. keep upload more videos like this. Great work👏👏

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

Perfect explanation sir.. thank you

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

Wow very helpful one .Please create more interview questions 🎉🎉🎉 lots of love

@alexrosen8762 Год назад

Your tutorials are at another level. Really useful and practical because I can always follow along because of the downloadable files.

@datatutorials1 Год назад

Glad you liked it ✨

@yagersew437 Год назад

GREATE JOB BUDDY. PLEASE KEEP THESE AWESOME VIDEOS COMING.

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

Maaaaan this is just what I need. Great video!

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

I am very Happy for this tyoe of videos just you are making for us thank you so much... Love you sir

@aishwaryapattnaik3082 Год назад

It's really great... understood each and every part in video.. can you add more videos like this and a video on more complex dax queries asked for experienced

@Omi12987 10 месяцев назад

One word for this mindblowing

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

You are superb. Thanks a lot. Can you please create more of these kind of videos.

@NehaSingh-um8ds 8 месяцев назад

Superb ...Very Helpful

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

Wonderful and very useful.

@gunnusmiles7620 11 месяцев назад

Very very wonderful video with clear clarity bro,can you also make video on when we have to use which type of charts and what values can we take in x axis and y axis i mean what type of data should be taken on x axis and y axis

@nishantpurohit100 10 месяцев назад

thanks for your efforts..!!

@charusinghal4196 Год назад

Very Helpful videos...

@Ajaykumar-bx1dq Год назад

Great session

@VimalRaj-uu6bt 6 месяцев назад

Great video Sir.

@relaxationinsider795 Год назад

Please more scenario based power bi questions like this.please do one video on how to increase the performance of the report step by step.That would be helpful.

@datatutorials1 Год назад

Sure

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

finished watching

@kmansa5760 4 месяца назад

Great 👍 video

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

love u and tq soo much broo😍

@MasterMinds-pk7vp Месяц назад

Very gr8 info bro.

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

awesome video

@vishalachary6814 11 месяцев назад

awesome

@learnwitharsh43 4 месяца назад

Tq❤

@swatisingh-yw1fw Год назад

Thankyou sir... it is very helpful, do make more videos in interview series.

@datatutorials1 Год назад

Sure

@dokkin9549 11 месяцев назад

I appreciated your tutorial video. It is very useful.

@datatutorials1 11 месяцев назад

Glad it was helpful!

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

great

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

Such an informative vdo, full of knowledge and new learning for a power bi beginner like me. Great work guys, keep it up.

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

Glad it was helpful!

@Sirigineedi_Navann Год назад

Wonderful brother 🎉🎉🎉 Kudos to your great efforts 😊

@datatutorials1 Год назад

Thank you so much 😀

@bitterstories418 11 месяцев назад

Man, that was awesome. Great job.

@datatutorials1 11 месяцев назад

Thanks a ton!

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

super explanation it helps me alot thanks😊

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

Glad to hear that

@mrmojes1896 Год назад

Sir Thank you for this, upload as soon as next part

@datatutorials1 Год назад

Sure

@nature.lover_27 10 месяцев назад

I learnt a lot from this video and clear explanation.. Thanks for the video

@datatutorials1 10 месяцев назад

Glad you liked 🙂

@ankurprasad865 Год назад

Thanks for sharing. Sir, if we have two tables. one is customer and second is sales and we wish to pull date week wise. Could you please suggest. couple of times interviewers asked me. pls suggest. Many Thanks

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

usefull

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

For the last scenario can we give the dynamic colour using the rules options instead of field.y is field preferred here is this a good practice?

@abrahamvincent6272 3 месяца назад

useful information, Great for ur efforts

@datatutorials1 3 месяца назад

Thanks a lot

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

Very Helpful, I'm the new subscriber . Can you please make video on all the Dax function, which is helpfull for fresher and intermediate level person, as per the interviewer perspective

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

I will try my best

@koteswaribapatla8075 11 месяцев назад

Can you make one video how to create table shows current and previous month sales based on slicer selection with direct query connection,thanks

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

Very nice video brother. Covered most of the challenging scenarios with their relevant solutions. Very well explained as well. Keep up the good work 👍

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

Glad it was helpful!

@pradeeppadeliya Год назад

Type this videos are very informative......please use more dax.....Your all video is different from others video... Please make full interview mock to scenario based question full process of hire combine all question...

@datatutorials1 Год назад

Thanks bro

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

In dynamic title, what if a user selects multiple years? or perhaps toggle the 'SELECT ALL'. How will the selected years be displayed?

@rajendrakumarsethi3161 11 месяцев назад

Thanks sir

@datatutorials1 11 месяцев назад

Welcome

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

EXCELLENT.. THESE ARE FOR THE EXPERIENCE OR FRESHER LEVEL ?

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

Both

@prashantkale3559 Год назад

Nice we want more vidoes bro🙏

@datatutorials1 Год назад

I will try my best

@nitinkumar-xw1vg Год назад

Can you please provide any good source to learn DAX queries ?

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

Hi, for scenario 4, what if the years are multi-selected? How do we display the values then?

@engineersfarming8249 Год назад

Hello Can u please make a detail video on how the managerial round conducted, Which type of scenario based questions ask

@datatutorials1 Год назад

Definitely

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

Second scenario no need calculate function only totalytd is enough

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

Agreed

@subbaraoballipale890 4 месяца назад

i got this question in interview

@amanmulla9997 3 месяца назад

For 1st question, insted of tagging number, can just change the name or replace "Under 25" to "0-25", it will come at 1st position

@datatutorials1 3 месяца назад

Client requested to have under 25 then you have to do with this approach. Else your way would be better

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

Same question i got in my interview

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

Glad it helped and you answered all correctly

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

Thanks a lot, it's a helpful scenario,is there any possibility to proved the table file so try it myself,Thank again

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

Its available in description of the video

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

For scenario 5 : instead of color measure can we do it by conditional formatting as well?

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

Yes

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

Hi, For scenario 2 YTD sales, I think YTD means everyday it should sum up the total sales and show the result until last day right, for ex MTD means from month day 1 to day 31st it should keep summing up previous day sales and show the result, but above YTD is just showing same result as sum of sales. it started from 1 jan 2023, so 2nd Jan YTD should be 3500.. and 3rd Jan should be 5000.... isn't it. Could you please confirm if my understanding is wrong ?

@g.janardhanreddyjanardhan4478 5 месяцев назад

Make more

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

Hi sir I am Rajashekar and I am practing your scenero sir but I am not getting wrong output sir I did practice two times but I am getting wrong output but I didn't understand why it is coming like that because of I practiced your data only but I didn't get proper result sir

@nehaprasad6665 11 месяцев назад

How we will know which expression or formula we have to use to do certain calculations? Can you please give me any tip or trick for this...

@datatutorials1 11 месяцев назад

That comes with lot of practice and creating multiple dashboards

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

Dear, when I try to create Data Table in the second question I get the notification "Too few arguments were passed to the CALENDAR function. The minimum argument count for the function is 2." What should I do? :)

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

you need to give min and max dates

@rishavgupta9988 3 дня назад

aint the representation of fiscal year is wrong , in visualisation basically it took whole calender year and sorted in the order computed rather to represent oct 2020-sept 2021??

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

while calculating sort age value showing null

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

Sir I need Excel data on College Infrastructure UTTILIZATION can Please Provide Me

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

after creating the conditon column the age sort column is showing as null

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

Did you write condition properly, its case sensitive

@poojasingh3393 3 месяца назад

Scenerio 2- I am creating this in 2024, why its still giving me the output of 2023. It should be Blank for 2024

@HarshadChavan1830 11 месяцев назад

Sales till today = CALCULATE(SUM(Sales[Sales]),DATESBETWEEN('Master date'[Date],DATE(2023,1,1),DATE(2023,5,23))) can i also use this?

@datatutorials1 11 месяцев назад

The dates are fixed here, make sure whatever dax u use is dynamic and do not need changes again and again

@_Anshuman-zo1lj 27 дней назад

the meaning of ytd is beginning of current calender year to todays date then why r u specifying it should be less than today

@sravaniram-zb2pd 11 месяцев назад

Sir did interviewer provide data according to scenario????

@datatutorials1 11 месяцев назад

Yes

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

I didn't created any date table. YTD_Mes = CALCULATE( TOTALYTD( SUM('Sheet1 (2)'[Sales]), 'Sheet1 (2)'[Order Date].[Date] ), FILTER( 'Sheet1 (2)', 'Sheet1 (2)'[Order Date]