Skip to content

Latest commit

 

History

History
30 lines (20 loc) · 1.69 KB

File metadata and controls

30 lines (20 loc) · 1.69 KB

Data-Analysis-Project-on-Hotel-Reservation-Cancellations

BUSINESS PROBLEM:

In recent years City Hotel and Resort Hotel have seen drastic cancellation rates of their respective bookings. Each hotel is thus dealing with a number of issues including fewer revenues and less than ideal hotel rooms to use. Therefore , lowering Cancellation rates is both hotels’ primary goal in order to increase their efficiency, boost their revenue and for us to offer thorough business advice to solve this problem.
image

ASSUMPTIONS-

  1. No unusual occurrences between 2015-17 will have substantial effect on data used.
  2. The information is still current.
  3. There are no unanticipated negatives to the hotel employing advising technique.
  4. The hotels are not currently using any suggested solutions.
  5. The biggest factor reducing effectiveness of earning income is cancellations.
  6. Clients make the hotel reservations the same year as cancellations.
  7. Cancellations result in vacant rooms for booked length of time.

Research Questions-

  1. What are the variables affecting hotel reservation cancellations?
  2. How can we make reservation and cancellation process better?
  3. How will hotels be assisted in making pricing and promotional decision?

Hypothesis-

  1. More Cancellations occur when prices are higher.
  2. Customers cancel more frequently when there is a longer waiting list.
  3. The majority of clients are coming from offline travel agents to make their reservations.