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

  Рет қаралды 90,472

Data Tutorials

Data Tutorials

Күн бұрын

Пікірлер: 123
@alexrosen8762
@alexrosen8762 Жыл бұрын
Your tutorials are at another level. Really useful and practical because I can always follow along because of the downloadable files.
@datatutorials1
@datatutorials1 Жыл бұрын
Glad you liked it ✨
@relaxationinsider795
@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
@datatutorials1 Жыл бұрын
Sure
@satyabobby6248
@satyabobby6248 Жыл бұрын
Very useful, clean explanation. This comes only by exp.
@pankajjangir7928
@pankajjangir7928 Жыл бұрын
Such a great video, very crisp and to the point with proper explanation...Great Work
@Sirigineedi_Navann
@Sirigineedi_Navann Жыл бұрын
Superb video very useful for all the BI aspirants please try to make videos like this.
@jafetcalderon9505
@jafetcalderon9505 6 ай бұрын
Maaaaan this is just what I need. Great video!
@Satishkumar-gv5ss
@Satishkumar-gv5ss Жыл бұрын
superb sir thank you for making interview series
@ArunPatil-jb1yt
@ArunPatil-jb1yt 18 күн бұрын
thanku sir i learned a lot of things here😍😍
@HappyLandTravel
@HappyLandTravel Жыл бұрын
Your channel is so useful! Thank you
@as8401
@as8401 Жыл бұрын
I am very Happy for this tyoe of videos just you are making for us thank you so much... Love you sir
@shaikfarhana768
@shaikfarhana768 Жыл бұрын
super explanation it helps me alot thanks😊
@datatutorials1
@datatutorials1 Жыл бұрын
Glad to hear that
@rakesh9298
@rakesh9298 6 ай бұрын
Perfect explanation sir.. thank you
@jyotisingh1671
@jyotisingh1671 7 ай бұрын
Such an informative vdo, full of knowledge and new learning for a power bi beginner like me. Great work guys, keep it up.
@datatutorials1
@datatutorials1 7 ай бұрын
Glad it was helpful!
@shaiksabdar6
@shaiksabdar6 4 ай бұрын
Awesome Video for Practical Power BI Questions
@nature.lover_27
@nature.lover_27 Жыл бұрын
I learnt a lot from this video and clear explanation.. Thanks for the video
@datatutorials1
@datatutorials1 Жыл бұрын
Glad you liked 🙂
@swatisingh-yw1fw
@swatisingh-yw1fw Жыл бұрын
Thankyou sir... it is very helpful, do make more videos in interview series.
@datatutorials1
@datatutorials1 Жыл бұрын
Sure
@pavanigoud155
@pavanigoud155 Жыл бұрын
Wow very helpful one .Please create more interview questions 🎉🎉🎉 lots of love
@nissypradeep4552
@nissypradeep4552 10 ай бұрын
Very good Explanation. and Thanks for the data provided in drive.
@Omi12987
@Omi12987 Жыл бұрын
One word for this mindblowing
@Letty-dx3tk
@Letty-dx3tk 4 ай бұрын
Amazing video, very helpful!! Thank you sooo much.
@pradeeppadeliya
@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
@datatutorials1 Жыл бұрын
Thanks bro
@neelammishra5622
@neelammishra5622 Жыл бұрын
You are superb. Thanks a lot. Can you please create more of these kind of videos.
@rukesh.m9799
@rukesh.m9799 Жыл бұрын
Very usefull video.Thanks for giving dataset also. keep upload more videos like this. Great work👏👏
@dokkin9549
@dokkin9549 Жыл бұрын
I appreciated your tutorial video. It is very useful.
@datatutorials1
@datatutorials1 Жыл бұрын
Glad it was helpful!
@abrahamvincent6272
@abrahamvincent6272 8 ай бұрын
useful information, Great for ur efforts
@datatutorials1
@datatutorials1 8 ай бұрын
Thanks a lot
@amanmulla9997
@amanmulla9997 8 ай бұрын
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
@datatutorials1 8 ай бұрын
Client requested to have under 25 then you have to do with this approach. Else your way would be better
@gunnusmiles7620
@gunnusmiles7620 Жыл бұрын
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
@bitterstories418
@bitterstories418 Жыл бұрын
Man, that was awesome. Great job.
@datatutorials1
@datatutorials1 Жыл бұрын
Thanks a ton!
@yagersew437
@yagersew437 Жыл бұрын
GREATE JOB BUDDY. PLEASE KEEP THESE AWESOME VIDEOS COMING.
@mrmojes1896
@mrmojes1896 Жыл бұрын
Sir Thank you for this, upload as soon as next part
@datatutorials1
@datatutorials1 Жыл бұрын
Sure
@aishwaryapattnaik3082
@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
@benhurthandu6821
@benhurthandu6821 2 ай бұрын
Thank you!
@Sirigineedi_Navann
@Sirigineedi_Navann Жыл бұрын
Wonderful brother 🎉🎉🎉 Kudos to your great efforts 😊
@datatutorials1
@datatutorials1 Жыл бұрын
Thank you so much 😀
@MasterMinds-pk7vp
@MasterMinds-pk7vp 6 ай бұрын
Very gr8 info bro.
@insidehead
@insidehead 10 ай бұрын
EXCELLENT.. THESE ARE FOR THE EXPERIENCE OR FRESHER LEVEL ?
@datatutorials1
@datatutorials1 10 ай бұрын
Both
@NehaSingh-um8ds
@NehaSingh-um8ds Жыл бұрын
Superb ...Very Helpful
@engineersfarming8249
@engineersfarming8249 Жыл бұрын
Hello Can u please make a detail video on how the managerial round conducted, Which type of scenario based questions ask
@datatutorials1
@datatutorials1 Жыл бұрын
Definitely
@beneficial4u572
@beneficial4u572 Жыл бұрын
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
@datatutorials1 Жыл бұрын
I will try my best
@rajashrin5221
@rajashrin5221 Жыл бұрын
Second scenario no need calculate function only totalytd is enough
@datatutorials1
@datatutorials1 Жыл бұрын
Agreed
@priyankanadar1142
@priyankanadar1142 7 ай бұрын
Hi, for scenario 4, what if the years are multi-selected? How do we display the values then?
@ramshataqdees5570
@ramshataqdees5570 Жыл бұрын
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?
@gospelmoto2833
@gospelmoto2833 Жыл бұрын
Wonderful and very useful.
@ankurprasad865
@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
@madhusudhanreddyt2838
@madhusudhanreddyt2838 4 ай бұрын
in the calendar table, we need to have the weekofyear column to perform week over week sales analysis for customers...
@prashantkale3559
@prashantkale3559 Жыл бұрын
Nice we want more vidoes bro🙏
@datatutorials1
@datatutorials1 Жыл бұрын
I will try my best
@howruharsha
@howruharsha 11 ай бұрын
love u and tq soo much broo😍
@Ajaykumar-bx1dq
@Ajaykumar-bx1dq Жыл бұрын
Great session
@nishantpurohit100
@nishantpurohit100 Жыл бұрын
thanks for your efforts..!!
@nuredinomer690
@nuredinomer690 Жыл бұрын
Thanks a lot, it's a helpful scenario,is there any possibility to proved the table file so try it myself,Thank again
@datatutorials1
@datatutorials1 Жыл бұрын
Its available in description of the video
@arkaghosh8344
@arkaghosh8344 Ай бұрын
While creating conditional column for the age group it showing null in many cells in power query. Can you explain why this happening??
@VimalRaj-uu6bt
@VimalRaj-uu6bt 11 ай бұрын
Great video Sir.
@mayur_146
@mayur_146 Жыл бұрын
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
@datatutorials1 Жыл бұрын
Glad it was helpful!
@charusinghal4196
@charusinghal4196 Жыл бұрын
Very Helpful videos...
@kmansa5760
@kmansa5760 9 ай бұрын
Great 👍 video
@sanjanasatavilli381
@sanjanasatavilli381 8 ай бұрын
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 ?
@koteswaribapatla8075
@koteswaribapatla8075 Жыл бұрын
Can you make one video how to create table shows current and previous month sales based on slicer selection with direct query connection,thanks
@sandipansarkar9211
@sandipansarkar9211 Жыл бұрын
finished watching
@rajendrakumarsethi3161
@rajendrakumarsethi3161 Жыл бұрын
Thanks sir
@datatutorials1
@datatutorials1 Жыл бұрын
Welcome
@nehaprasad6665
@nehaprasad6665 Жыл бұрын
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
@datatutorials1 Жыл бұрын
That comes with lot of practice and creating multiple dashboards
@AhteshamArshad-h1e
@AhteshamArshad-h1e Жыл бұрын
For scenario 5 : instead of color measure can we do it by conditional formatting as well?
@datatutorials1
@datatutorials1 Жыл бұрын
Yes
@rajashekar2931
@rajashekar2931 11 ай бұрын
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
@gospelmoto2833
@gospelmoto2833 Жыл бұрын
In dynamic title, what if a user selects multiple years? or perhaps toggle the 'SELECT ALL'. How will the selected years be displayed?
@madhusudhanreddyt2838
@madhusudhanreddyt2838 4 ай бұрын
Dynamic Title Multiple Years = IF(ISFILTERED('Calendar'[Year]), "SALES INFORMATION FOR " & CONCATENATEX(VALUES('Calendar'[Year]), 'Calendar'[Year], ", ", "PLEASE SELECT YEAR FOR SALES DETAILS"))
@gospelmoto2833
@gospelmoto2833 4 ай бұрын
@@madhusudhanreddyt2838 Wonderful! BIG thanks.
@nitinkumar-xw1vg
@nitinkumar-xw1vg Жыл бұрын
Can you please provide any good source to learn DAX queries ?
@pal531
@pal531 Жыл бұрын
Same question i got in my interview
@datatutorials1
@datatutorials1 Жыл бұрын
Glad it helped and you answered all correctly
@purushottammitra1258
@purushottammitra1258 4 ай бұрын
Ther's a confusion on SENARIO 2, when you put totalytd on the visual why this was only showing for 2023, not for 2021,2022, also you haven't put any filter on 2023? can you please clarify , Actually I'm having an interview soon
@brainalive8963
@brainalive8963 6 ай бұрын
awesome video
@learnwitharsh43
@learnwitharsh43 9 ай бұрын
Tq❤
@vishalachary6814
@vishalachary6814 Жыл бұрын
awesome
@ajsendingozi4763
@ajsendingozi4763 Жыл бұрын
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
@lkwintertv Жыл бұрын
you need to give min and max dates
@subbaraoballipale890
@subbaraoballipale890 10 ай бұрын
i got this question in interview
@sravaniram-zb2pd
@sravaniram-zb2pd Жыл бұрын
Sir did interviewer provide data according to scenario????
@datatutorials1
@datatutorials1 Жыл бұрын
Yes
@rishavgupta9988
@rishavgupta9988 5 ай бұрын
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??
@Kratikajain511
@Kratikajain511 Жыл бұрын
great
@poojasingh3393
@poojasingh3393 9 ай бұрын
Scenerio 2- I am creating this in 2024, why its still giving me the output of 2023. It should be Blank for 2024
@HarshadChavan1830
@HarshadChavan1830 Жыл бұрын
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
@datatutorials1 Жыл бұрын
The dates are fixed here, make sure whatever dax u use is dynamic and do not need changes again and again
@hrushikeesh2
@hrushikeesh2 Жыл бұрын
Sir I need Excel data on College Infrastructure UTTILIZATION can Please Provide Me
@deepaklondhe3308
@deepaklondhe3308 Жыл бұрын
after creating the conditon column the age sort column is showing as null
@datatutorials1
@datatutorials1 Жыл бұрын
Did you write condition properly, its case sensitive
@avyaktakishor1635
@avyaktakishor1635 11 ай бұрын
usefull
@revellenandakishore8729
@revellenandakishore8729 Жыл бұрын
while calculating sort age value showing null
@_Anshuman-zo1lj
@_Anshuman-zo1lj 6 ай бұрын
the meaning of ytd is beginning of current calender year to todays date then why r u specifying it should be less than today
@g.janardhanreddyjanardhan4478
@g.janardhanreddyjanardhan4478 11 ай бұрын
Make more
@SravaniRajesh-k6c
@SravaniRajesh-k6c Жыл бұрын
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]
@sandeshpadigela0
@sandeshpadigela0 4 ай бұрын
where is the data to downlaod
@ishalagdev
@ishalagdev 7 ай бұрын
Can you share the excel sheets
@datatutorials1
@datatutorials1 7 ай бұрын
In description of video
@benitinmagnate4937
@benitinmagnate4937 8 ай бұрын
Employee Age Group? LOL! Not in America, maybe that's how it's in India. I have to stop right here.
@abhishekvrm2777
@abhishekvrm2777 8 ай бұрын
Goodbye Gramps 👋🏻
@swatilparikh
@swatilparikh 9 ай бұрын
Cant we use filter and measure for second scenario?
@i_love_you-m9n
@i_love_you-m9n 12 күн бұрын
videow was infomative but i have some doubts on second senario based ques where we have creaeted a dim date for the whole but when we make measeure how its is extracting for only 2023 ...is there anyone who can guide me for the same
@swatilparikh
@swatilparikh 9 ай бұрын
If its of today in second scenario how they are showing sales in later date?
Top 25 Power BI Interview Questions & Answers
29:44
KSR Datavizon
Рет қаралды 250 М.
كم بصير عمركم عام ٢٠٢٥😍 #shorts #hasanandnour
00:27
hasan and nour shorts
Рет қаралды 12 МЛН
Twin Telepathy Challenge!
00:23
Stokes Twins
Рет қаралды 140 МЛН
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 115 МЛН
Masterclass: Front-End Power BI Techniques for Formatting and Design
1:05:56
Devon and Cornwall User Group | Sue Bayes
Рет қаралды 2,9 М.
Visualization based Interview Question | Power BI | Must Watch
14:19