Link to Dashboard:- https://www.novypro.com/project/power-bi-17

Link to Challenge:- https://codebasics.io/event/codebasics-resume-project-challenge

Domain: Hospitality Function: Revenue

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.

Task :

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.

1. Create the metrics according to the metric list.
2. Create a dashboard according to the mock-up provided by stakeholders.
3. Create relevant insights that are not provided in the metric list/mock-up dashboard.

1. Mumbai generates the highest revenue and Delhi has the least revenue among 4 cities.
2. Delhi has the heighest occupancy rate and Average Ratings
3. At the time of weekend occupancy rate is heigher than weekdays
4. Bangalore has the highest cancellation rate(25%) as compare to other cities.

1. Offer additional extras or services
2. Create special packages
3. Work on your reviews