Revenue Insights Hospitality Analysis - Hotel Chain Business

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 is 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” 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 with insights from their historical data.

Task List

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. ** Some Important Insights from the Dashboard**

Mumbai generates the highest revenue (669 M) followed by Bangalore, Hyderabad and Delhi AtliQ Exotica performs better compared to all 7 types of properties with 320 Million revenue, a rating of 3.62, an occupancy percentage of 57 and a cancellation rate as 24.4%. AtliQ Bay has the highest occupancy of 66% Week 24 recorded the highest revenue among all, which is 139.6 Million Delhi tops both in occupancy and rating followed by Hyderabad, Mumbai, Bangalore AtliQ lost around 298 Million in cancellation Elite-type rooms have the most bookings and higher cancellation rate

Some Important insights from the Dashboard

Mumbai generates the highest revenue (669 M) followed by Bangalore, Hyderabad and Delhi 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%. AtliQ Bay has the highest occupancy of 66% Week 24 recorded the highest revenue among all, which is 139.6 Million Delhi tops both in occupancy and rating followed by Hyderabad, Mumbai, Bangalore AtliQ lost around 298 Million in cancellation Elite type rooms has the most booking and as well higher cancellation rate