Introduction:
Welcome to the Hospitality Revenue Analysis Dashboard, designed to provide data-driven insights for AtliQ Grands to regain their market share and revenue in the luxury/business hotels category. As a data analyst, I have been tasked with leveraging historical data to create a comprehensive dashboard and provide relevant insights.
Data Sources:
The data used for this analysis comes from the following CSV files:
dim_date: Contains information related to date and time.dim_hotels: Provides data on the hotels owned by AtliQ Grands.dim_rooms: Contains information about the rooms within each hotel.fact_aggregated_bookings: Aggregated booking data.fact_bookings: Detailed booking data.
Metrics and KPIs:
The following metrics and key performance indicators (KPIs) have been incorporated into the dashboard:
-
Occupancy Rate: This metric provides an overview of how well AtliQ Grands' rooms are utilized.
-
Average Daily Rate (ADR): A key revenue metric, ADR measures the average income generated per room per day.
-
Revenue Per Available Room (RevPAR): It represents the revenue generated per available room, providing a more comprehensive view of hotel performance.
-
Booking Channel Analysis: Insights into the most profitable booking channels, enabling targeted marketing efforts.
-
Month-over-Month (MoM) Revenue Growth: Evaluating revenue growth compared to the previous month.
-
Customer Review Ratings: Monitoring customer satisfaction through ratings and feedback.
-
Realisation% : It is nothing but the successful "checked out" percentage over all bookings happened.
-
DBRN(Daily Booked Room Nights) :This metrics tells on average how many rooms are booked for a day considering a time period.
-
DSRN(Daily Sellable Room Nights) :This metrics tells on average how many rooms are ready to sell for a day considering a time period.
-
DURN(Daily Utilized Room Nights) :This metrics tells on average how many rooms are successfully utilized for a day considering a time period.
My meticulous approach, driven by comprehensive data analysis, has allowed to develop an intricate yet intuitive dashboard that encapsulates a plethora of critical metrics and actionable insights. This portfolio description encapsulates the essence of this analytical masterpiece. Below is the brief description of the findings.
Key Insights & Findings:
Conclusion:
The Hospitality Revenue Analysis Dashboard aims to provide AtliQ Grands with the necessary data and insights to regain their market share and optimize revenue. By monitoring key metrics, visualizing data effectively, and leveraging additional insights, AtliQ Grands can make informed decisions and improve their positioning in the luxury/business hotels category.