This Power BI project provides a detailed analysis of AtliQ Hospitality's performance, covering revenue, occupancy rates, ADR (Average Daily Rate), RevPAR (Revenue per Available Room), and booking trends. The analysis aims to uncover insights across various properties and cities, offering data-driven recommendations to enhance revenue generation, optimize occupancy, and improve overall operational efficiency.
Analyze revenue and occupancy trends by property, city, and room class. Understand factors influencing ADR, RevPAR, and booking performance. Provide strategic recommendations to address underperformance and boost profitability.
Revenue Analysis
Total Revenue: AtliQ properties collectively generated 1.69 billion in revenue. Top City: Mumbai leads in revenue generation with 661M, followed by Bangalore (415M) and Hyderabad (321M). Top Property: AtliQ Exotica is the highest revenue-generating property, while AtliQ Seasons lags. Room Class Performance: Premium (32.81%) and Elite (27.04%) classes contribute the most to revenue. Insight: Revenue performance varies significantly across cities and properties, indicating potential for optimization.
Occupancy Trends Overall Occupancy: Average occupancy is 57.79%, meaning approximately 42% of rooms remain unoccupied. City-wise Occupancy: Cities like Bangalore show lower-than-average occupancy rates. Seasonal Trends: Occupancy fluctuates between 55-60% from May to July, with noticeable dips during certain weeks. Insight: Maximizing occupancy is crucial for improving revenue, especially during low-demand periods.
ADR & RevPAR Insights ADR: Average Daily Rate is 12.70K, with Bangalore having the highest rate at 15K. RevPAR: Mumbai leads in RevPAR at 9K, while Hyderabad lags at 5K. Insight: ADR remains relatively stable, suggesting a consistent pricing strategy, but dynamic pricing could help capture more value during peak times.
Realization & Cancellations Realization Rate: 70.14% across properties. Cancellation Rate: Ranges between 24-26%, with spikes close to booking dates that impact room resale opportunities. Insight: Cancellation patterns suggest a need for flexible policies to reduce last-minute cancellations.
Booking Platform Performance Top Platforms: Third-party sources like "Others" and "MakeyourTrip" perform well, while direct channels underperform. Insight: Heavy reliance on third-party platforms may boost realization but reduces margin due to platform fees.
-
Benchmark Best Performers Action: Analyze successful properties like AtliQ Exotica to identify factors (e.g., pricing strategy, customer base) that could benefit other properties.
-
Tailored Marketing Campaigns Action: Create city-specific marketing plans, particularly for high-revenue areas like Mumbai and Bangalore, to capitalize on market strengths and boost occupancy in low-performing regions.
-
Seasonal Promotions Action: Launch discounts, weekend packages, and holiday offers to increase occupancy during low-demand periods.
-
Dynamic Pricing Strategy Action: Implement dynamic pricing that adjusts rates based on competitor pricing and guest demand, especially during peak seasons.
-
Flexible Booking Policies Action: Introduce non-refundable discounts or stricter policies during high-demand periods to reduce cancellations, while offering last-minute deals to fill canceled rooms quickly.
-
Increase Direct Bookings Action: Develop loyalty programs and exclusive offers to drive direct bookings, reducing dependency on third-party platforms and improving profit margins.
Clone or download this repository. Open the .pbix file in Power BI to explore the interactive dashboard. Review the insights and recommendations to understand the drivers of AtliQ Hospitality's performance and potential strategies for improvement.