An interactive Power BI business intelligence solution designed to analyze hotel revenue performance, occupancy trends, customer behavior, and booking insights for AtliQ Grands — a luxury hotel chain operating across India.
AtliQ Grands, a five-star hotel chain with over 20 years of presence in the luxury and business hospitality sector, experienced declining market share and revenue due to increased competition and ineffective strategic decision-making.
To address these challenges, management initiated a business intelligence transformation aimed at leveraging historical booking and revenue data for performance monitoring and operational optimization.
The organization required an analytics dashboard capable of delivering actionable insights into revenue performance, occupancy behavior, customer satisfaction, and booking trends.
Design and develop an interactive Power BI dashboard to:
- Monitor hotel revenue and occupancy performance
- Analyze booking and cancellation trends
- Evaluate customer satisfaction and ratings
- Identify high-performing cities, platforms, and room categories
- Support data-driven hospitality and revenue management decisions
Developed the Hospitality Domain Dashboard in Power BI featuring:
- Revenue and occupancy monitoring
- Booking platform performance analysis
- Cancellation trend tracking
- Customer satisfaction and rating insights
- Room category and city-level analysis
- Interactive KPI reporting and filtering
- Power BI – Dashboard development and visualization
- Power Query – Data cleaning and transformation
- DAX – KPI calculations and business metrics
- Excel – Initial data exploration and validation
- GitHub – Portfolio presentation and version control
- Business Intelligence – Hospitality performance analytics
- Mumbai generated the highest revenue at approximately ₹0.67B.
- Delhi achieved the highest occupancy rate (60.55%) and customer rating (3.78).
- Weekend bookings accounted for nearly 63% of total reservations, indicating strong leisure demand patterns.
- The cancellation rate reached 24.83%, highlighting opportunities for booking optimization and customer retention improvements.
- The “Others” booking platform generated the highest booking volume and revenue contribution.
- Luxury and Elite room categories consistently outperformed across occupancy and revenue metrics.
- Improved visibility into hotel and platform performance
- Enabled data-driven occupancy and pricing analysis
- Supported customer satisfaction monitoring
- Identified booking and cancellation behavior trends
- Delivered centralized hospitality intelligence reporting
--
📦 Hospitality-Domain-Dashboard
┣ 📊 .pbix file (Power BI dashboard)
┣ 📈 PNGs of each dashboard page
┣ 📄 README.md (This case study)
This project helped AtliQ Grands:
- Gain visibility into platform and property performance
- Understand guest behavior by time and region
- Identify gaps in occupancy and satisfaction
- Make data-driven decisions for strategic turnaround
- 🌐 LinkedIn: Asim Ahmed
- 💻 GitHub: asimahmedio
- ✉️ Email: asim.atia@gmail.com