AtliQ Grands' Data-Driven Renaissance: Reviving Luxury Hotels with Business Intelligence

Summary: As AtliQ Grands endeavors to rejuvenate its operations amidst a downturn in market share and revenue within the luxury/business hotels sector, the transformative potential of Business Intelligence (BI) emerges as a beacon of hope. In the absence of an in-house data analytics team, the company has enlisted the expertise of external service providers to harness insights from its wealth of historical data. As a Data Analyst entrusted with this critical mission, you are poised to harness the power of sample data and a provided mock-up dashboard to sculpt essential metrics and extract actionable insights.

• Revenue Distribution: The business category generated 61% of total revenue, highlighting its significant contribution to the overall financial performance.
• Hotel Performance: Atliq Exotica, located in Mumbai, generated a substantial revenue of ₹9M, with an impressive average rating of 4.29 for their Presidential Suite, indicating high customer satisfaction and revenue potential.
• Key Metrics Improvement: Key metrics such as Revenue per Available Room (RevPAR), Average Daily Rate (ADR), and Occupancy Percentage witnessed a consistent increase over time, reflecting positive trends in hotel performance and profitability.
• Week-on-Week Analysis: Week-on-Week analysis revealed significant differences in occupancy and ADR for Premium rooms in Delhi, with a 6% variance in occupancy and nearly ₹1000 difference in ADR. Additionally, weekdays experienced a 1% increase in realization, indicating potential weekday booking optimization opportunities.
• Booking Preferences: Elite rooms in Bangalore are predominantly booked through the hotel website, with 72.27% of customers preferring direct online booking. This highlights the effectiveness of the hotel's online booking platform in attracting customers.
• Customer Acquisition: Standard rooms in Hyderabad are primarily booked offline, with 73.10% of customer acquisition occurring directly. This underscores the hotel's strong presence in the industry, attributed to factors such as location and service quality, despite offline booking preferences.