/AtliQ-Grands-Hospitality-Insights-using-Power-BI

AtliQ Grands hotel Data Analysis using Power BI

Atliq Grands Hospitality Insights using Power BI PowerBI

As part of the Codebascis resume project challenge, I've created a dashboard

The Challenge 🏆

The challenge is about the imaginary company called AtliQ Grands which owns multiple Five-Star hotels across India. AtilQ Grands is losing business to competitors due to their management’s ineffective decision-making.

Now AtliQ Grands is losing its market share and revenue in the luxury/business hotels category. The revenue management team has decided to use Business and Data intelligence to identify the gaps and make decisions accordingly.

They are looking for a Data Analyst who can provide them with the relevant insights to help them solve this problem.

Tasks 🔖

  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.

Technologies used ⚙️

  • Power BI PowerBi

  • Statistics Statistics

Power BI Dashboard Link 🔗

AtliQ Grands 🏩

Here are some important statistics to consider before diving into visualization:

  1. AtliQ Grands is a prestigious five-star hotel chain operating across 4 cities.
  2. The chain comprises seven properties, with branches in all four cities.
  3. Accommodations within these properties are classified into four categories: Elite, Premium, Presidential, & Standard.
  4. Room bookings are facilitated through six main platforms, each playing a crucial role in the hotel's operations.

Data Modelling in Power BI

Power BI Dashboard

Overall Analysis

Key Insights 🔍

Based on the Dataset:

  • AtliQ Exotica led among all seven property types, with $320 million revenue, a rating of 3.62, and 57% occupancy.
  • Mumbai led in revenue generation with $669M, followed by Bangalore, Hyderabad, and Delhi.
  • Delhi ranked highest in both occupancy and rating, followed by Hyderabad, Mumbai, and Bangalore.
  • May led in revenue generation with $582M, followed by July and June month.
  • Week 24 had the highest number of bookings with 11K, generating a revenue of $140M and achieving an occupancy rate of 62%.
  • AtliQ Seasons had the lowest revenue at $66M, with an occupancy of 45% and an average rating of 2.29.

Project References: 🔗

Sr.No. 🔢 References 👨‍💻 Links 🔗
1 Codebascis Resume project challenge Codebasics
2 Star Schema: Fact Table & Dimension Table Microsoft docs.