PowerBI_Hospitality_Project

所属分类:数据挖掘/数据仓库
开发工具:Others
文件大小:0KB
下载次数:0
上传日期:2024-02-22 12:43:24
上 传 者sh-1993
说明:  PowerBI酒店项目
(PowerBI Hospitality Project)

文件列表:
Hospitality_Project.pbix

# PowerBI_Project - Hospitality Domain ## 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” 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 Created 2 dashboards with relevant KPIs to find insights from the given data and help business to make achieve their objectives. ## Insights 1. Mumbai emerges as the top revenue generator, contributing a significant 668.6 million, while Delhi exhibits the lowest revenue at 294.5 million. Focused efforts are needed to unlock its full potential and bridge the gap with high-performing regions like Mumbai. 2. Atliq Exotica property has performed better than others with Revenue 320M, Average rating 3.62, Occupancy percentage 57 and Cancellation rate as 24.4%. 3. While Atliq Seasons recorded the lowest average rating (2.29), a significant 72.54% gap with the top-performing Atliq Blu(3.96 Average Rating), necessitates targeted strategies to enhance guest satisfaction in this property. 4. AtliQ Bay excels in attracting guests, achieving a 66% Occupancy. 5. Despite leading in bookings, Elite rooms require focused attention due to their elevated cancellation rate. 6. A significant increase in cancellations during June (25.09%) led to a 0.24% decrease in Occupancy Rate compared to the average.

近期下载者

相关文件


收藏者