Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Problem statement
Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.
Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.
Learnings things from this Project
- Snowflake data model.
- By referring different cancellation polices followed by different hotels, understood that most of the hotels charge zero fee, only if the booking is cancelled before three months of booking date. If the booking is cancelled after that, the charge range from 60 to 90% of the booking cost.
- Choosing a good colour palette accoding to the problem statement.
- How to use KPI indicators, especially when there is inverse praportinality.
Some Important insights from the Dashboard
- Most occupied hotel is Atliq Blu having average occupancy of 62.02%.
- Hotels in Delhi are most occupied with an average of 60.55%.
- Total Revenue in 3 months from all hotels is ₹1.71 billion.
- There are a total of 232576 rooms of which only 57.87% are occupied, which means 97985 rooms remain vaccant.
- Week 24 recorded the highest revenue among all, which is 139.6 Million.
- AtliQ Exotica performs better compared to all 7 type of properties with 320 million revenue, rating 3.62, occupancy percentage 57 and cancellation rate as 24.4%.
- Delhi generates the lowest revenue.
Follow me on Linkedin : www.linkedin.com/in/shubham-shaah
Github : https://github.com/Shaah-i
eyJrIjoiYmEwZWFjMTQtZWY0NC00ZWI5LWExNTEtNjViMDIyMjYwNTEzIiwidCI6ImRmODY3OWNkLWE4MGUtNDVkOC05OWFjLWM4M2VkN2ZmOTVhMCJ9&pageName=ReportSection