Data contains booking information for two hotels from 2018-2020. The goal of this project is to create a database with the data then cleaning/formatting the data to be analyzed and visualized in Power BI.
Questions:
- Is the hotel revenue growing each year?
- Should the parking lot be expanded?
- What trends can we see in the data?
Process:
- Build a MySQL database
- Develop SQL queries
- Connect Power BI to the database
- Visualize findings
- Summarize findings
Conclusions: Both hotels' revenue grew from 2018-2019 but slowed in 2020. This trend can be due to COVID, however, the low revenue numbers for 2018 and 2020 can also be attributed to the lack of data for the full year. The parking lot does not have to be expanded as not every guest booking required a parking space. The peak usage was 19% and trend line is flat. Overall, we can see postive trends for the following: average daily rate, total nights booked, and discounts.