As part of the codebasics september month resume challenge, I have worked on this analysis project.
Link to Interactive Dashboard
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.
You are a data analyst who has been provided with sample data and a mock-up dashboard to work on the following task. You can download all relevant documents from the download section.
- Create the metrics according to the metric list.
- Create a dashboard according to the mock-up provided by stakeholders.
- Create relevant insights that are not provided in the metric list/mock-up dashboard.
🔹Mumbai is the top revenue-generating city, followed by Bangalore, Hyderabad, and Delhi.
🔹AtliQ Exotica outperforms all 7 property types with a revenue of 320 million, rating of 3.62, occupancy percentage of 57%, and cancellation rate of 24.4%.
🔹AtliQ Bay has the highest occupancy rate of 66%.
🔹Week 24 generated the highest revenue of 139.6 million compared to other weeks.
🔹Delhi has the highest occupancy and rating among the four cities, followed by Hyderabad, Mumbai, and Bangalore.
🔹AtliQ suffered a loss of around 298 million due to cancellations.
🔹The Elite type rooms have the most bookings, but also have a higher cancellation rate.
🔹AtliQ Exotica's performance indicates that the hotel is doing well in terms of generating revenue and maintaining occupancy.
🔹AtliQ Bay's high occupancy rate suggests that the hotel has been successful in attracting guests.
🔹The high cancellation rate for the Elite type rooms indicates a need to review the booking and cancellation policies to reduce losses.