[] Create a Problem Statement.
[] Identify the data you want to ananlyse.
[] Explore and Clean the data-sets. {before analysis}
[] Analyse the data to get useful insights. {problem statement, research questions, and hypothesis : at last}
[] Present the data in terms of reports or dashboards using visualizations.
# Business Problem
''' In recent years, City Hotel and resort hotel have seen high cancellation rates. Each hotel is now dealing with a number of issues
as a result, including fewer revenues and less than ideal hotel room use. Consequently, lowering cancellation rates in both hotels'
is our primary goal in order to increase their efficiency in generating revenue, and for us to offer through business advice to address
their problem. '''
The analysis of hotel cancellations as well as other factors that have no bearing on their business and yearly revenue generation are the main topics of this report.
- No unusual occurrences between 2021 and 2023 will have a substantial impact on the data used.
- The information is still current and can be used to analyse a hotel's possible plans in an efficient manner.
- There are no unanticipated negatives to the hotel employing any advised technique.
- The hotels are not currently using any of the suggested solutions.
- The biggest factor affecting the effectiveness of earning income is booking cancellations.
- Cancellations result in vacant rooms for the booked length of time.
- Clients make hotel reservations the same year they make cancellations.
1. What are the variables that affect hotel reservations cancellations?
2. How can we make hotel reservations better?
3. How will hotels be assisted in making pricing and promotional decisions?
1. More cancellations occour when prices are higher.
2. When there is a longer waiting list, customers tend to cancel more frequently.
3. The majority of clients are coming from offline travel agents to make their reservations.