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” 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.
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.
-
The data was provided in csv format files for Hotels, Rooms and bookings. The data was checked and cleaned, and tranformations were performed to create calculated columns and measures with common functions and formulas. -Build a relational data model, creating active relations between tables and understanding cardinality and filter flow.
-
Designed interactive dashboards to visualize data using charts and visuals.
-
Created page navigation, custom tooltip.
Dashboard 1: Revenue Performance & KPI Analysis
Dashboard 2: Market Trend & Customer Insights Dashboard
Dashboard 3: Booking Behavior & Operational Efficiency
-
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%
-
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
