AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years.
This project demonstrates data analysis skills and visualization for the company using SQL Server and PowerBI.
Company is losing its market share and revenue in the luxury/business hotels category. Due to strategic moves from other competitors and ineffective decision-making in management.
The management wants to fix this issue, the managing director wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue.
The goal of this project is to perform data analytics on data to incorporate “Business and Data Intelligence” to regain the market share and revenue using various tools and technologies.
The Company has a comprehensive database that contains information about Customers,Markets,Products,Transactions,Date of Transactions
The database captures details such as customer_name, customer_type, market_name, zones, sales_quantity, sales_amount and many more.
💹 Data Model
Database Used - https://tinyurl.com/4hyfjatj
Dataset - https://tinyurl.com/yu8txn4r
Metadata - https://tinyurl.com/yu8txn4r
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent