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.
-
Provide Insights to Revenue Team in Hospitality Domain
-
You are a Data Analyst who has been provided with sample data and a mock-up dashboard
-
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.
- Total Bookings
- Revenue
- Average Rating
- Total Capacity
- Total Successful bookings
- Occupancy %
- Total Cancelled Bookings
- Cancellation Rate
This file contains all the meta information regarding the columns described in the CSV files. we have provided 5 CSV files:
- dim_date
- dim_hotels
- dim_rooms
- fact_aggregated_bookings
- fact_bookings
Business Intelligence
Hospitality
Microsoft Software Power BI
- Suggested, ways to raise revenue by 29% and enhance occupancy rates. Take advantage of late bookings and additional days of stay to increase revenue
- Occupancy Percentage is maximum on Weekends
- Maximum bookings are done through others and makeyourtrip platform
- Average rating is between 3.65 and 3.6
- Delhi is showing high average rating
- Mumbai and Hyderabad shows high fall in occupancy during June