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!
I also sometimes envy Indians who want to enter Data Analytics field, having so many great mentors from shared culture background. I found the videos from this channel extremely practical and trust the on-hand skills of whom got the Codebasic's Certifications. Is the Codebasic trainings mainly aim to help fellow Indians? I am not of Indian background, so one reason I couldn't make up my mind in getting into the training course.
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
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 RUclips 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.
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.
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 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
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.
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!
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...!!
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.
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.
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❤❤
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.
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…
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!
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.
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
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.
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
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.
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
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
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! 🤝🤝
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.
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.
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.
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
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.
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.
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!
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..
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
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.
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
![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??
I also sometimes envy Indians who want to enter Data Analytics field, having so many great mentors from shared culture background. I found the videos from this channel extremely practical and trust the on-hand skills of whom got the Codebasic's Certifications. Is the Codebasic trainings mainly aim to help fellow Indians? I am not of Indian background, so one reason I couldn't make up my mind in getting into the training course.
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
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 RUclips 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.
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.
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 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
Last stakeholders review is gold ......
👍👍
one of the top level content with bussiness perspective , we need more like this with anand, vedivel
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.
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!
Sir we are also waiting for mathamatics and statistics videos for data analytics and data scientist.
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...!!
Dhaval Patel sir ,,, is the best teacher ... He understands the problems of students ..
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 ??
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.
Thanks a lot Mr Dhaval ! Its extra ordinary! Involving the Subject Expert is Fantastic! Thanks to your team for all your efforts!
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. 🌟
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.
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.
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!
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
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
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
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?
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.
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
What a amazing learning i had today with this video...please make more videos like this with stakeholders thankyou ❣
Hyderabad is all time favorite for everyone
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
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! 🤝🤝
Sir your effort are amazing....
Thank you so much for this project words are less to appreciate your work.
please continue to make these type of video on real type data for BI very very Useful Thanks
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 this video. Really helpful. I have same domain background and I can relate this with my current knowledge of Analytics
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
Can we consider this video as a virtual internship? The content is top notch. Thank you!!!
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.
Thanks a lot Mr Dhoval !
Your way of teaching was amazing and your channel was like goldmine for beginners like me
Most welcome!
the stackholder review part was very helful and insightful, Loved it.
Calculating the Average Daily rate is used by total bookings, but in one day there are more than two bookings and different booking ids
Very informative and well explained by Abhishek 👏👏
really very very good thing i learn about the power BI
Thank you so much for this amazing insight on requirement gathering.
Just appreciate your work guys so informative and helpful.
This video is so helpful. Want more this kind of explanation video.
Thanks for this awesome info. live from nairobi Kenyan
Hey Dhaval, Please bring such more dashboards.....
Thanks a ton... ❤
Highly impressive vedio. Hats off to your expertise guys❤
Very informative video. Thanks team
Awesome , well explained videos i have found Thanks @Abhishek for provinding wonderfull
the hotel business insights and matrix
Thanks a lot Mr Dhaval sir ,so more learning point in DAX function,how to visualization of data in properly format
really worth it. please make more this type of content
great work. we expect more such projects in the future........
Such a great explanation!! Thanks codebasics team for amazing insights
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
Excellent video as always, very informative and insightful.
This is great! it's like being part of the team. I learned a lot thankyou!
Very Insightful video sir !!
That was a great insight and an interactive session.
Great video. First time seeing a video like this where the actual industry perspective is taken into account . Keep it up Guys
This is GOLD
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.
Please do same for retail industry if possible ..
Nice Project, thanks to share and teaching
Thanks for this video. Really helpful.😇
Awesome!
Great content with detailed steps of an end to end power bi project
very nice work
how much time should an expert typically take to finish this type of dashboard?
Untill whys stop occuring!
As a person starting out from scratch can I begin with this tutorial
Very nice
Very valuable video and project
Beautiful and too helpful 🎉
Really informative!
thanx for the project sir....its very helpful for us..
plz tell how to mention this project in resume
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.
Sir the date column in these files shows '#' multiple times and not the actual date value
Hey thankyou so much i learnt alot
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....
Really informative. It was an amazing session!
Glad you enjoyed it!
Thank you for your amazing work!
awesomeee!!!
1:11:32 Hyderabad ❤
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!
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..
Pls start making videos on Tableau also bro..
you guys done a great job..
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
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
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
its very good
but in fact_booking there is no revenue_realized column sir
Dashboard creation 45:16
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
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 helpful
ty so much!!!!!!!!
In DAX I can see day like Sunday, Monday in your table