Hotel Bookings Data

Project Overview

Dream It, Plan It, Book It. Have you ever wondered when the best time of year to book a hotel room is? Or the optimal length of stay to get the best daily rate? What if you wanted to predict whether a hotel was likely to receive a disproportionately high number of special requests? This data set contains information which compares various booking information between two hotels: a City Hotel and a Resort Hotel.

The data set contains booking information for a City Hotel and a Resort Hotel, for the year 2015, 2016 and 2017 and includes information such as when the booking was made, length of stay, the number of adults, children, and/or babies, and the number of available parking spaces, among other things.

Role:

Problem Statement

Selling the right room to the right customer, at the right time, at the right price, on the right distribution channel, with the lowest possible commission is easy when you know how, daunting when you don’t especially in today’s complex, multi-channel environment.

As hotel chains consolidate and booking apps and short-term rentals grow, new fees and new restrictions make it tougher to reserve the best rate. Also, as travel websites get bigger, booking a decent hotel room gets harder. In 2018, there are over 148 million travel bookings made annually. The online travel market projection of $756 billion in 2019 is expected to grow to $817 billion by 2020. 15.4% growth in worldwide online travel sales and 10.3% growth in online hotel bookings.

Executive Summary

Data Dictionary

Key Takeaways