Hotel Revenue Analysis
Hotel Revenue Analysis
Embedded Files
This project aimed to evaluate hotel performance during 2018–2020 using data analytics tools.
Completed Tasks
Completed Tasks
Merged hotel data from multiple years using SQL
Cleaned and transformed the data in Power Query
Created a calculated revenue column and performed performance analysis in Power BI
Designed an interactive dashboard to answer key business questions
Sample Queries
Sample Queries
Dashboard
Dashboard
Key Insights
Key Insights
Revenue grew from 2018 to 2019, then declined in 2020 due to the pandemic.
Demand for parking spaces decreased, indicating no need for expansion.
Bookings increased during summer months, especially in tourist-focused hotels.
Recommendations
Recommendations
Adjust capacity planning for parking
Capitalize on strong summer demand
Mitigate revenue drops like those seen in 2020
Focus on tourist hotel segments
Page updated
Google Sites
Report abuse