End to End Data Analytics Project | Power BI Project | Hospitality Domain

How Data Analysts Build Dashboard in Real Time?
You will understand how data analysts build dashboard in real time in this video featuring an industry expert Abhishek Anand (revenue manager in OYO) & Hemanand who is a data analytics expert.
This is also a solution to the Resume Project Challenge #1 conducted by Codebasics. You can download all the resources and create your own dashboard for building knowledge and adding it to resume.
Link to All resources: codebasics.io/resources/end-t...
00:00:00 Introduction
00:05:44 Mockup review and business requirement discussion
00:23:17 Data transformation using power query
00:33:09 Building metrics using DAX
01:10:02 Stakeholder review
01:35:27 Closing
Abhishek's LinkedIn Profile: / abhishekanand-nm
Dhaval's Linkedin Profile: / dhavalsays
Hemanand's LinkedIn Profile: / hemvad
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...

[@codebasics]

If you want to learn data analytics using projects like this then check our data analyst BootCamp: codebasics.io/bootcamps/data-analytics-bootcamp-with-practical-job-assistance

[@Iqbalsharib4]

I have enrolled in this course but it was told that i will get 2 projects in python one is hospitality domain data analysis and another is Medical data extraction but in bootcamp it only shows one project i.e hospitality domain data analysis only.

[@1hpdell]

Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!

[@shujashakir9952]

This video is a gem for those who want to understand data analysis. The information gathering part is invaluable as this sort of experience is usually not shared on KZbin vidoes. Although I do not work in hospitality industry, the vidoe taught me how to interact with clients and get the appropriate information about the domain as well as the client's requirements. Thanks Dhaval for this wonderful experience.

[@anivesh2225]

one of the top level content with bussiness perspective , we need more like this with anand, vedivel

[@perfectionist6624]

Wow... this kind of amazing content no one is providing............... even other paid courses dont have such superb content like this.. Please bring more videos on different domains... Thanks a lot!

[@yashkanojiya1146]

This video is top-notch for data analysts, covering all the important stuff they need to know.

[@amanpandey5673]

What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣

[@atithembram9768]

This was very insightful......non of your competitors are doing this .....i strongly recommend you that bring guest like this from different domain to share their insights like this so that we can get benefit .Who ever agree, do like the comment so that daval can cosider this idea

[@AsifDawood]

Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys

[@didyouknowthat.channel]

This is why I look very highly at Indians. They are extremely intelligent people and are very professional. You can see how they approached this problem systematically and I'm happy that they detailed every step of the way. I am extremely impressed at Mr. Hemanand Vadivel. Thank you for sharing this!

[@Canadianvixen]

I think the data set isn't available now can anyone help me out.

[@PavanKumar-uw7si]

​@@Canadianvixengo to the link in the description

[@Batira583]

when i wanna learn a technical skill i always always check for indians they are very smart

[@muhammadazam8422]

Excellent video as always, very informative and insightful.

[@vijayabhaskarreddyrajupale7945]

Awesome! Great content with detailed steps of an end to end power bi project

[@jyotirautela8633]

Very informative and well explained by Abhishek 👏👏

[@Mohpra]

Thanks for this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics

[@sureshbabus1790]

Amazing video and team has really put lot of effort.. kudos to the team and wish them best of luck and would like to get more videos like this....

[@mohammadzeeshan992]

Sir your effort are amazing.... Thank you so much for this project words are less to appreciate your work.

[@mytalents260]

its simply great. I like the way the conversation went. Hemanandh shoot the right questions to get better insights. Wonderfull. I fell in love with these videos. Thank you

[@himanshutripathi6114]

Dhaval Patel sir ,,, is the best teacher ... He understands the problems of students ..

[@asamadawais]

Highly impressive vedio. Hats off to your expertise guys❤

[@filmytrendz4990]

Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.

[@chinunayak6494]

The level of teaching and discussion with the stakeholders to be super amazing. Initially, I felt lazy when starting the project, but after seeing the discussion led by Abhisek Sir and Hemant Sir, it was just wow! Really, that was impressive.

[@desmond7182]

Just appreciate your work guys so informative and helpful.

[@nithyapalanisamy4904]

great work. we expect more such projects in the future........

[@rudrenshahiwala]

Very informative video. Thanks team

[@akhilmaurya9189]

Awesome , well explained videos i have found Thanks @Abhishek for provinding wonderfull the hotel business insights and matrix

[@sografarheen1722]

Hi Dhaval sir your teaching skills are to the next level excellent your a boon for new folks

[@kalyanirayudu6885]

every time iam very eagrly waiting for u video sir you r giving premium content for free ex;giving real time and giving project documents and kt also which is very excellent

[@syedasherahmed949]

Hats off man to you Sir for providing such an amazing experience of self learning and execution of the project at the same time. Would love to see more of the content in the coming videos and by far I have not seen such an explanation where we are actually get acquainted with the business terms and in the same time communicating with the stake holders and providing decisions based on this.

[@codebasics]

Glad you liked it. I would encourage you to participate in our resume projects on codebasics.io

[@syedasherahmed949]

@@codebasics yes definitely

[@youtubeuser996]

Hi @codebasics team, Prathamesh here! I think to measure present booking id's in following data you had used count instead of CountA to count number of booking ID's present in the data, because count will only add up the Numeric data type, Please check with that, Beginners might get confused.

[@perfectionist6624]

Hey Dhaval, Please bring such more dashboards..... Thanks a ton... ❤

[@narpathify]

That was a great insight and an interactive session.

[@alkaarora5722]

please continue to make these type of video on real type data for BI very very Useful Thanks

[@MotivationByHeart007]

In between Doing this project with video i feel like I'm a data analyst in this company and building a report and forgot that I'm learner 😅. Really fantastic project which give us real feel.

[@arpitagarwal8485]

Amazing way to learn Data Analysis. I really like the way requirement gathering happen in this video. We need more such content. Thank you for this awesome video.

[@Canadianvixen]

Heyi i think the dataset isn't available now can anyone help me out.

[@fahmidapinky9311]

This video is so helpful. Want more this kind of explanation video.

[@nishagenani6408]

Hello Dhaval and Hemanand Vadivel sir, I am very grateful for such amazing lectures and videos you provide, I have explored various sources for learning but the way you explain things is really commendable. Step-by-step explanations and then challenges to work on further steps make us learn by doing hands-on projects. Involving subject matter experts in the case study helps to understand the industry terms and industry expert insights. I really appreciate all the efforts by you and the Codebasics Team. Thank you so much for giving such amazing lessons.

[@prasenjit_hazra]

Hi, Codebasic teams, A big thanks for making such of information enriching videos, which is really helpful for new-commers. But I would like to pass-on a comments regarding the chapter "Building metrics using DAX" - instead of applying formula to extract "weekend / weekdays", it would be easier to go edit on raw files of "dim_date" & loading on Power BI directly.

[@justinnacu]

This is great! it's like being part of the team. I learned a lot thankyou!

[@omharne1386]

really very very good thing i learn about the power BI

[@AkshayKumar-iz2kd]

Last stakeholders review is gold ......

[@codebasics]

👍👍

[@Chaithrika6363]

Thank you for your amazing work!

[@umarhayatkhanlodhi3358]

Nice Project, thanks to share and teaching

[@vaijayantigulve4883]

This platform is a goldmine...!! Whether I land a job or not , I have been learning so so much from your videos. Can't thank you enough... 🙏🙏 May your businesses flourish and you become a billionaire very soon...!! God bless...!!

[@alishakumari3663]

Wowwww this is gem video for any Data analyst enthusiast. This is not normal video where u r doing the same repeatable thing of creating a dashboard. For all those things they have provided the resources with the help of them they can create ur dashboard. They have utilised most of the time in this video for understanding the business like how and what should a data analyst should do, and what should be there approach after landing into the job. Just love it❤❤

[@codebasics]

I'm really glad you found the video valuable and insightful! Thanks for your kind words. 🌟

[@otizby4217]

Thanks for this awesome info. live from nairobi Kenyan

[@tayyabanaz1421]

In my data analytics journey, I found this video to be truly exceptional, and I was able to create a dashboard thanks to it. I want to express my gratitude to Sir Dhaval for sharing this valuable resource.

[@codebasics]

Glad it helped!

[@ayushurmaliya5217]

Kudos to you guys amazing work… you guys very we’ll understand what needs to be taught.. I work as a data analyst and I can understand how important these skills are…

[@jaitiwari241]

bhai file kaha h

[@ahmedatharmohiuddin1388]

@@jaitiwari241 Follow the "Link to resources" link available in the description

[@Canadianvixen]

hey I think the dataset isn't available now, can anyone help me out.

[@gaykesavita2303]

Thanks a lot Mr Dhaval sir ,so more learning point in DAX function,how to visualization of data in properly format

[@parikshitrajpara5706]

I have a question: You were able to identify that there was just one entry of "week 32" (47:00), and decided to remove it. I suppose you were already aware of this outlier and therefore able to identify it. But if the data is absolutely new to us and we are unaware of these outliers, then how can we find and deal with them? Using Python to perform visualizations or by some other methods? Can you please tell us more about it? Thank you for your help; you are doing an excellent job!

[@TrEndYWOrldviDeos]

Thanks for this video. Really helpful.😇

[@nikhilsk2026]

Waw❤ this is really a wonderful Video which leads to crack any interview ,the level of asking questions and interactions with client is really awesome 👏 thank you ❤

[@mayphos3589]

Thank you for this. I have been looking for a hospitality dataset or project for my Portfolio. I'm currently enrolled in your Code Basics class online, and I love it too!!!, but this is a lifesaver because it aligns with my previous career and can help me cross to the analytics.

[@poojapradhan39]

Could you please send the data set , actually i can't download it from his blog

[@udeshrajput2594]

Hey! Can you please guide me. I will also buy this course. Howz it going? Can we connect on LinkedIn for the same?

[@rohil3072]

Thanks for making such an informative video. You guys are doing such a good work. This video has increased my motivation to pace up my learning into this interesting field and become a data analyst.

[@Canadianvixen]

Heyi I think the dataset isn't available now can anyone help me out.

[@techtalkwithaswar]

you guys done a great job..

[@sarihaddu]

Just vow. I have been trying to switch career at 40 and have been learning PowerBi for 1 year, when feasible, but never came across this channel. I was just byhearting concepts but never knew how I would be useful . This video clearly insights into how valuable a data analyst can be in decision making. Thank you so much. I am confident I will definitely land a job this year. All the best to people who are planning to start data analytics career.

[@trending_video999]

Can you help me ??

[@vaibhavsrivastava7945]

Very nice Very valuable video and project

[@houssnachana5709]

Grat work! Thanks for the effort. Im wondering why do we substrut 1 in the WoW hange measures when we return divide(revcw,revpw)-1

[@Siddharth_Matada]

learnt a lot from this video...like how will be stakeholders requirements and metrics they look for which we could not figure out on our own...thanks a lot

[@poojapradhan39]

could you please share data set of this video?

[@mohandattabayya5584]

Very Insightful video sir !!

[@user-wf5fq3rw6p]

Thanks a lot Mr Dhoval ! Your way of teaching was amazing and your channel was like goldmine for beginners like me

[@codebasics]

Most welcome!

[@soumyamanjunath3855]

how much time should an expert typically take to finish this type of dashboard?

[@girlnextdoor5991]

Sir the date column in these files shows '#' multiple times and not the actual date value

[@Simeon-iz8rz]

Can we consider this video as a virtual internship? The content is top notch. Thank you!!!

[@roses292]

Hi Dhaval Sir, May I know the difference between revenue generated and revenue realized in facts booking table. Please correct me if I am wrong, I think the total revenue should be the summation of revenue generated. Also, one more thing to add on , that is if we want to show up the Room Revenue by doing the summation of Revenue Realized Is this Possible Sir.. Need to clarify and correct me pleaseeee

[@bharathau8085]

Really informative!

[@santoshkumar-wq4qd]

This is GOLD

[@antarabanerjee1314]

only the mockup dashboard snap is available in the downloaded file, other snaps and recording zip files which you are referring is missing in the zip folder sir

[@dhackmt]

Hey thankyou so much i learnt alot

[@Goodman838]

Really informative. It was an amazing session!

[@codebasics]

Glad you enjoyed it!

[@priyanshuverma3716]

thanx for the project sir....its very helpful for us.. plz tell how to mention this project in resume

[@ananthlytics]

Hyderabad is all time favorite for everyone

[@poojamali9506]

This is very useful video, who want to do projects. I have one suggestion, Can you plz do all videos on all projects that you have posted. As any one who are preparing that will be more useful.

[@codebasics]

Yes that is the plan. Second video on supply chain project is coming up. My schedule is quite hectic so it is taking time but it is in my todo list for sure.

[@satishk1464]

very nice work

[@SanghmitraaSisodiya]

Could you make a video - explaining that WOW stuff? Week over-week metrics. I tried multiple times, but couldn't understand it. Loved the content, Knowledge, domain-specific details, Video Editing, and Everything. Thank you so much. Keep up the good work Dhaval and Hemanand.

[@marotipolkamwad254]

same issue

[@sandipjabade1]

Refer the pdf files in that they have explained wow metrics line by line

[@kastenivkimbo5347]

Can we use selectedvalue here instead of hasone filter

[@SantoshKumar-yr2md]

Can we consider all Dim Table act as Conformed Dimension as I can see all dim tables refer more than one subject area, please suggest

[@tanishqvaibhav5003]

very helpful

[@namangarg7875]

For Revenue wow change % measure, why we are using reccw= calculate fns and then applying a filter because once we select any weak letz say 23 then realisation measure inside it will show only data for weak 23 instead we need to open the filters for recpw that's logical because we need to calculate for the previous weak then the selection. Please can anyone explain this?

[@namangarg7875]

In revenue wow change % if suppose we select may-23 as a filter the weeks will be automatically be filtered and the highest weak no-23 and then revenue wow change % will be as per w-23 because it will fetch the maximum weak number as per dax that's fine. But let suppose if we select week number by ourself as week 23 then also the Revenue wow change % answer should be same but it is showing different please help

[@lavyasplanet2025]

which kind of datasets i practice as intermediate learner... n from which site to download other than kaggle

[@vinodpvenu8553]

Hi, what would you suggest for a senior management professional who has taken up business analytics as his next career option and what all he should be master of, or atleast what all he should be aware of for getting a job in analytics industry'... Please suggest.

[@saurabhkshirsagar4997]

I Just want to know is there is no voice in videos for further dashboard creation

[@NouYunho]

ty so much!!!!!!!!

[@AmanKumar-uq3zk]

hello sir,i wanted to make my career in data science field,but issue is that,,i am a B.A. graduatee .so,please help me out.... could i pursue data science as profession rather i am belonging from non-engineer background,,,pleease reply as soon,,its help me a lot...thanks and keep growing..

[@vilegaveakshay1108]

Do h have any project series for data scientist??...

[@zakirhussain4193]

Pls start making videos on Tableau also bro..

[@meenayv4902]

Please do same for retail industry if possible ..

[@classicemmaeasy2292]

As a person starting out from scratch can I begin with this tutorial

[@harshitsingh4246]

can we use this as a portfolio project

[@menghao4576]

Sir, is there no tableau? You said when you made the playlist of that one tableau project, you were considering doing it.

[@YG-jb2in]

I have an issue My values are same as the video except the % values which are shown below as week on week changes ...they are totally different from yours ...formulas i have used are also correct. Kindly help.

[@NagaRaju-lf4ke]

its very good

[@MrBING5221]

How much approx time(duration) would we get right after the req gathering from stake holder/client to complete this dash board in a real time company?

[@muhammadmustafa2023]

Thanks a lot.

[@onkarkulkarni7988]

Where is the link of the data set

[@rohit-qr6ft]

hey I see few mistakes with wow % the same revenue wow % was used for Revpar and adrn (I used the correct ones in mine)

[@reddaiahreddymallu]

Thank you for the amazing content. A quick question…How much time is an analyst given to complete this kind of a project in corporate setup? @codebasics

[@abhishekanand370]

Depends on the criticality of the ask... most critical asks are delivered in 24hours

[@musicwithbrothers3646]

hello codebasics team that is a vary good video for learning .. But can you tell me that BOOKING % BY PLATFORM AND the BOOKING % BY ROOM CLASS FORMULA is it right ? beacuse in the time of doing this the booking % by platform also counts the directly offline booking as well . same thing goes for the BOOIKING % BY Room class. Please reply me on this

[@haideralam5125]

Raw data set xls/csv is there in resource???

[@ananyamitra6645]

awesomeee!!!

[@SantoshKumar-yr2md]

how can we get these datasets and content so we can do practice please provide