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
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.
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!
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
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.
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 TH-cam 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.
This is the Actual Sceanrio Based Reports ,Qudos to Trainers and StakeHolder, This is slap for the people who are selling just their course and not showing the right industries need
This hospitality dashboard tutorial is amazing in both technical PowerBI skills and real-world business analytics! The most valuable insight was learning how a data analyst should think beyond just creating visualizations - it's about enabling business decisions. Love how you showed the importance of adding week-on-week trends, tooltips for deeper insights, and dynamic arrow indicators for performance changes. The stakeholder feedback session was gold 💯💯🔥 - learning about hotel pricing strategies (flat vs dynamic vs weekend pricing) and how they impact occupancy rates. It really demonstrates that great dashboards need to be a marriage between technical excellence and business understanding. Thank you for teaching not just the 'how' but also the crucial 'why' of dashboard creation! 🤝🤝
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.
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!
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.
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❤❤
Absolutely loved this video! The way you broke down how a data analyst should think and approach problems is incredibly insightful. It's clear, detailed, and really helps in understanding the mindset required for data analysis. This is exactly the kind of content that helps bridge the gap between theory and practical application. Thanks for such a valuable resource!
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.
I think that is the best power project video i have ever learned from and this video not only for just follow along, we also using skills of BI to create this project
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.
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…
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.
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.
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...!!
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
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
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
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.
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.
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 ❤
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.
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.
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.
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.
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.
Hi, I have watched the video halfway through and find it amazing, especially bringing in the SME, which is really super helpful. now I am trying to follow the video and have downloaded the files from the given link, however, I do not see any "input folder" or data files mentioned in the video, can you guide me please how to access those files. Many thanks 1. dim_date 2. dim_hotels 3. dim_rooms 4. fact_aggregated_bookings 5. fact_bookings
Hi , you will find all the csv files in the resume challenge page of Codebasics. Dhaval sir shown how to download them step by step in the initial Part itself (Timestamp: 1:47) . Could you please check them and please let us know if you have face further issues. Thank you!
@@KiranDeepMarala I am working alongside the video and I have come across this hurdle, I would appreciate it if you can help me out with this? when replicating the variables ( WoW% - all of them) they are not showing the result when checking the details this message is showing. Error Message: MdxScript(Model) (57, 63) Calculation error in measure 'Key Measures'[Revpar_WoW_Change%]: DAX comparison operations do not support comparing values of type Text with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.
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!
Hii Sir Thank You for the amazing Video Sir Having said that I have a few doubts, The tooltips and the Wow Terms seems to be changed than what is shown in the video, Can You please share what is done differently. Even for the revenue one, the tooltip is not same. Please help me with the same
As a data analyst, u should give insights to whoever the clients and how to increase revenue . here u are asking them what insight u are getting from that dashboard, i think
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
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
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..
One thing that I want to mention here is ALWAYS CHECK YOUR DATA TYPE WHILE TRANSFORMING THE DATA BEFORE MOVING THE DATA TO POWER BI OR EXCEL (SPECIALLY THE COLUMNS HAVING NUMBERS IN THEM).
Thanks buddy for mentioning this. Due to 'Text' datatype of 'wn', 'WoW' measure was not working for me. Finally figured it was data type issue and saw this comment as well.
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
![Data Analyst Projects for Interview | Guided and Unguided Projects [6 Solid Projects]](http://i.ytimg.com/vi/prPBBS6wbYA/mqdefault.jpg)
![Data Analyst Projects for Interview | Guided and Unguided Projects [6 Solid Projects]](/img/tr.png)
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
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.
Why is it showing the checkout date, where the booking status is "cancelled" and "no-show" ?
Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids
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!
I think the data set isn't available now can anyone help me out.
@@Priya-d3u8lgo to the link in the description
when i wanna learn a technical skill i always always check for indians they are very smart
@@Priya-d3u8l I'm facing same problem i downloaded the data set but its not in the format so that power bi can extract did u got that??
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
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.
Glad it helped!
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 TH-cam 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.
This video is top-notch for data analysts, covering all the important stuff they need to know.
This is the Actual Sceanrio Based Reports ,Qudos to Trainers and StakeHolder,
This is slap for the people who are selling just their course and not showing the right industries need
This hospitality dashboard tutorial is amazing in both technical PowerBI skills and real-world business analytics!
The most valuable insight was learning how a data analyst should think beyond just creating visualizations - it's about enabling business decisions. Love how you showed the importance of adding week-on-week trends, tooltips for deeper insights, and dynamic arrow indicators for performance changes.
The stakeholder feedback session was gold 💯💯🔥 - learning about hotel pricing strategies (flat vs dynamic vs weekend pricing) and how they impact occupancy rates. It really demonstrates that great dashboards need to be a marriage between technical excellence and business understanding.
Thank you for teaching not just the 'how' but also the crucial 'why' of dashboard creation! 🤝🤝
one of the top level content with bussiness perspective , we need more like this with anand, vedivel
Last stakeholders review is gold ......
👍👍
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.
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!
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.
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❤❤
I'm really glad you found the video valuable and insightful! Thanks for your kind words. 🌟
Absolutely loved this video! The way you broke down how a data analyst should think and approach problems is incredibly insightful. It's clear, detailed, and really helps in understanding the mindset required for data analysis. This is exactly the kind of content that helps bridge the gap between theory and practical application. Thanks for such a valuable resource!
Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!
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.
I think that is the best power project video i have ever learned from and this video not only for just follow along, we also using skills of BI to create this project
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.
Can you help me ??
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…
bhai file kaha h
@@jaitiwari241 Follow the "Link to resources" link available in the description
hey I think the dataset isn't available now, can anyone help me out.
Dhaval Patel sir ,,, is the best teacher ... He understands the problems of students ..
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.
Could you please send the data set , actually i can't download it from his blog
Hey! Can you please guide me. I will also buy this course. Howz it going? Can we connect on LinkedIn for the same?
Hi Dhaval sir your teaching skills are to the next level excellent your a boon for new folks
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.
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...!!
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
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
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
could you please share data set of this video?
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.
Glad you liked it. I would encourage you to participate in our resume projects on codebasics.io
@@codebasics yes definitely
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.
same issue
Refer the pdf files in that they have explained wow metrics line by line
Sir your effort are amazing....
Thank you so much for this project words are less to appreciate your work.
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 ❤
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.
Heyi i think the dataset isn't available now can anyone help me out.
What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣
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.
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.
Thanks for this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics
Thanks a lot Mr Dhoval !
Your way of teaching was amazing and your channel was like goldmine for beginners like me
Most welcome!
please continue to make these type of video on real type data for BI very very Useful Thanks
Can we consider this video as a virtual internship? The content is top notch. Thank you!!!
Very informative and well explained by Abhishek 👏👏
This video is so helpful. Want more this kind of explanation video.
Just appreciate your work guys so informative and helpful.
Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.
really very very good thing i learn about the power BI
Hyderabad is all time favorite for everyone
Awesome , well explained videos i have found Thanks @Abhishek for provinding wonderfull
the hotel business insights and matrix
Thanks for this awesome info. live from nairobi Kenyan
Highly impressive vedio. Hats off to your expertise guys❤
Such a great explanation!! Thanks codebasics team for amazing insights
Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys
Hey Dhaval, Please bring such more dashboards.....
Thanks a ton... ❤
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.
Very informative video. Thanks team
Thanks a lot Mr Dhaval sir ,so more learning point in DAX function,how to visualization of data in properly format
Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids
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.
Heyi I think the dataset isn't available now can anyone help me out.
Excellent video as always, very informative and insightful.
Hi, I have watched the video halfway through and find it amazing, especially bringing in the SME, which is really super helpful. now I am trying to follow the video and have downloaded the files from the given link, however, I do not see any "input folder" or data files mentioned in the video, can you guide me please how to access those files. Many thanks
1. dim_date
2. dim_hotels
3. dim_rooms
4. fact_aggregated_bookings
5. fact_bookings
Hi , you will find all the csv files in the resume challenge page of Codebasics. Dhaval sir shown how to download them step by step in the initial Part itself (Timestamp: 1:47) . Could you please check them and please let us know if you have face further issues. Thank you!
@@KiranDeepMarala Thank you for pointing me in the right direction, much appreciated.
@@KiranDeepMarala I am working alongside the video and I have come across this hurdle, I would appreciate it if you can help me out with this? when replicating the variables ( WoW% - all of them) they are not showing the result when checking the details this message is showing.
Error Message:
MdxScript(Model) (57, 63) Calculation error in measure 'Key Measures'[Revpar_WoW_Change%]: DAX comparison operations do not support comparing values of type Text with values of type Number. Consider using the VALUE or FORMAT function to convert one of the values.
@@israry5623 did you able to resolve
great work. we expect more such projects in the future........
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!
how much time should an expert typically take to finish this type of dashboard?
Untill whys stop occuring!
Very Insightful video sir !!
This is great! it's like being part of the team. I learned a lot thankyou!
That was a great insight and an interactive session.
Please do same for retail industry if possible ..
Awesome!
Great content with detailed steps of an end to end power bi project
Hii Sir Thank You for the amazing Video Sir
Having said that I have a few doubts, The tooltips and the Wow Terms seems to be changed than what is shown in the video, Can You please share what is done differently. Even for the revenue one, the tooltip is not same.
Please help me with the same
As a data analyst, u should give insights to whoever the clients and how to increase revenue .
here u are asking them what insight u are getting from that dashboard, i think
Nice Project, thanks to share and teaching
Beautiful and too helpful 🎉
Thanks for this video. Really helpful.😇
This is GOLD
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
Very nice
Very valuable video and project
thanx for the project sir....its very helpful for us..
plz tell how to mention this project in resume
Really informative!
very nice work
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....
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
Sir the date column in these files shows '#' multiple times and not the actual date value
As a person starting out from scratch can I begin with this tutorial
Hey thankyou so much i learnt alot
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
Depends on the criticality of the ask... most critical asks are delivered in 24hours
Really informative. It was an amazing session!
Glad you enjoyed it!
but in fact_booking there is no revenue_realized column sir
Thank you for your amazing work!
Can a Power BI begginer opt for this particular project ?
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
where is the sample linkedin post for the reference ? it will be very helpfull if you provide that as well
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..
One thing that I want to mention here is ALWAYS CHECK YOUR DATA TYPE WHILE TRANSFORMING THE DATA BEFORE MOVING THE DATA TO POWER BI OR EXCEL (SPECIALLY THE COLUMNS HAVING NUMBERS IN THEM).
Thanks buddy for mentioning this. Due to 'Text' datatype of 'wn', 'WoW' measure was not working for me. Finally figured it was data type issue and saw this comment as well.
awesomeee!!!
I Just want to know is there is no voice in videos for further dashboard creation
Pls start making videos on Tableau also bro..
hey I see few mistakes with wow % the same revenue wow % was used for Revpar and adrn (I used the correct ones in mine)
you guys done a great job..
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
Sir, is there no tableau? You said when you made the playlist of that one tableau project, you were considering doing it.
how can we get these datasets and content so we can do practice please provide
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?