HOTEL BOOKINGS PROJECT
Introduction
In this data set, it includes data from a city and resort hotel about multiple bookings and the details into the bookings. It includes when the room was booked, the length of stays, the amount of people staying and much more. In this project, I will be cleaning up the data to make it easier to use, writing up queries to explore the data and creating a dashboard to visualize the data. I hope to find out things such as what the most popular months are for bookings, meal plans and the hotel type that accommodates to hotel guests the best.
​
Link for Data: https://www.kaggle.com/jessemostipak/hotel-booking-demand
Data Cleaning and Exploration with SQL Server
Link to Code: https://github.com/tracylam1/Portfolio/blob/main/HotelCleaningExp.sql
​
I started off the project with cleaning the data set to make it easier for me to explore the data later on. Some things I did was combine the month, day and year columns together so that it is easier to see the arrival dates. I also switched the '0' and '1's in some of the columns to 'yes' or 'no' so that it is easier for me to know what the 0 and 1's meant. Another thing I did was combine the 'SC' and 'Undefined' under the meal column since they both meant no meal plan. The photo below shows my code for changing the dates. The link above shows the whole code I did for cleaning.
A part of the exploration I wanted to highlight was when I wanted to find the cancellation rates for both of the hotel types. To do this, I used a temp table which includes creating a temporary table that contains the results of the query I made with the create table and insert into functions. After the temp table is made, I did the calculations needed with the basic select statement structure to obtain the cancellation rates. I also explored more of the data which can be seen in the link to the code above.
Data Visualization with Tableau
Link to Dashboard:
https://public.tableau.com/app/profile/tracy.lam/viz/HotelBookings_16291668438390/Dashboard1
​
In this dashboard, I created a visualization of the queries I used to explore the data in SQL. Some of the things I looked at in this dashboard compared the city and resort hotel in terms of average nights stayed, the amount of repeated guests, cancellation rates and different meal plans. I also created a bar chart showcasing the months with the most stays to show what months are the most popular in terms of reservations.
.png)