Welcome to the Hospitality Data Analysis project! This repository presents a detailed analysis of Atliq Grand's data, a luxury hotel chain in India, with the aim of uncovering actionable insights to regain market share and boost revenue through data-driven strategies.
Atliq Grand, a well-established five-star hotel chain in India, has been in the hospitality industry for over 20 years. Recently, due to competitive strategies and ineffective management decisions, the organization has experienced a decline in both market share and revenue in the luxury/business hotel category. To address this issue, the managing director initiated a plan to integrate Business and Data Intelligence. However, lacking an in-house analytics team, they enlisted a third-party service provider to generate insights from historical data.
The dashboards developed in this project provide the Revenue Management Team with critical insights, focusing on revenue trends, customer behavior, and operational efficiency. Below are some key takeaways:
- Elite Customers: These customers are key revenue drivers across cities and should be prioritized.
- Room Type RT2: This room type contributes the most to revenue and requires focused attention.
- Booking Platforms: Strengthen partnerships with platforms like MakeMyTrip and LogTrip to maximize bookings.
- Weekend Revenue: The last two weekends of the month are critical for balancing realized revenue.
- Revenue Trends: Revenue declined by 28.17% in the last four days of the month.
- City Contribution: Mumbai accounts for 13.59% of the total revenue.
- Cancellation Trends: June experienced the highest cancellation rate (25.09%), reducing the occupancy rate by 0.24%.
- Hotel Ratings: Atliq Blu achieved the highest average rating, 72.54% higher than Jason Seasons, which had the lowest rating at 2.29.
The following KPIs were developed using DAX for advanced insights:
- Total Bookings
- Total Revenue
- Average Rating
- Total Capacity
- Total Successful Bookings
- Occupancy Percentage
- Total Cancelled Bookings
- Cancellation Rate
- Revenue Loss
- Total Stay
- Storytelling with data using visually compelling dashboards.
- Translating business requirements into actionable insights.
- Creating advanced visualizations and DAX measures in Power BI.
- Designing an intuitive and engaging dashboard user interface.
- Crafting smart narrations to effectively communicate insights.
- Power BI: For developing interactive dashboards.
- DAX (Data Analysis Expressions): For calculating advanced KPIs.
Mayur Jambe
- Kaggle Profile: Mayur Jambe
- GitHub Profile: Mayur Jambe
- LinkedIn: Mayur Jambe
Feel free to explore, fork, and contribute to this project. Your feedback is always welcome! 🌟