Hotel Booking Data Analysis

In this project, the goal was to analyze and visualize hotel bookings data from the years 2018, 2019, and 2020. Three business questions were defined to guide the analysis:

1. Is our revenue growing by year?
2. Should we increase our parking lot size?
3. What trend can we see in the data?

To begin, the dataset was imported into Microsoft SQL and the UNION function was used to combine sheets "2018", "2019", and "2020" into a single table called "Hotels." In order to answer the first business question about revenue growth, it was necessary to create a new revenue column by using the ADR column and the total days and nights of the week and the weekend booked by people. This data was then grouped by year and hotel types to see the trend.

The "market segment" sheet was then added as a column to the Hotels table using the LEFT JOIN function. Similarly, the "meal cost" sheet was also added to the Hotels table.

So, now that the SQL analysis is complete, let's move on to Power BI. In Power BI, the SQL query was imported and the Discount column was taken into consideration in order to factor in revenue. A new query was created to add the revenue column affected by the discount. The data was then visualized to answer the business questions and understand the trends in the hotel bookings data. Thanks to the AbsentData youtube channel for the amazing tutorial.