Skip to content

This Projects tackles the business problem of lowering cancellation rates of Hotels to increase their efficiency and boost their revenue . Each variable of the problem is explored in detail and findings are presented through precise visualizations . A detailed report gives various insights of the Project .

Notifications You must be signed in to change notification settings

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

Repository files navigation

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.

About

This Projects tackles the business problem of lowering cancellation rates of Hotels to increase their efficiency and boost their revenue . Each variable of the problem is explored in detail and findings are presented through precise visualizations . A detailed report gives various insights of the Project .

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published