Adam
Dandi
Live Demo
ADAMS PROJECT

Revenue Analysis of Atliq Grands Hotels: Identifying Factors Influencing Revenue Generation

Industry

Hospitality

Company

Atliq Grands

Completion

July 25, 2024

Unlocking Hotel Revenue Potential: Data-Driven Insights for Atliq Grands

This project aimed to analyze the revenue generated by different Atliq Grands hotels across India and identify key factors influencing revenue performance. By examining booking data, room categories, and booking platforms, the analysis sought to provide actionable insights for optimizing revenue generation strategies.
Data Details
The project utilized five datasets from Atliq Grands: dim_date: Information about dates. dim_hotels: Information about hotel properties. dim_rooms: Information about room categories. fact_aggregated_bookings: Aggregated booking data. fact_bookings: Individual booking data, including revenue and booking platforms.
The Problem
Atliq Grands sought to understand the revenue performance of its different hotels and identify the factors affecting revenue generation to optimize pricing strategies and operational efficiency.
The Solution
The project involved data cleaning, merging datasets, and conducting exploratory data analysis (EDA) to identify trends and patterns. Data visualization techniques were used to present key findings, including total revenue per hotel and room class, average revenue per night, and revenue by booking platform.
Showcase
No items found.
Insight

Significant variations in revenue performance exist across different hotels and room classes. Presidential room classes generally have higher average revenue per night. Specific booking platforms like 'makeyourtrip' and 'others' contribute the most to revenue.

Recommendation

Focus on promoting Elite and Premium room classes in underperforming hotels. Optimize booking platform strategies by strengthening partnerships with high-revenue platforms. Adjust pricing and promotional strategies based on average revenue per night, particularly for Presidential room classes. Evaluate underperforming hotels to identify areas for improvement in offerings and pricing. Prioritize customer experience and service quality to enhance satisfaction and loyalty.

Look at more projects

Step into a galaxy of analytics where every dataset unveils a new world of possibilities.
View all projects
Market Analysis

Empowering Indonesia’s Future Leaders through Scholarship Program Design

View
January 14, 2025
Exploratory Data Analysis

Analyzing Trends in Paying Users on Educational Platform

View
December 27, 2024
Statistical Analysis

Student Competency Achievement Evaluation in Vocational High School (SMK)

View
December 19, 2024
Hire me

Ready to explore the data universe?

Uncover hidden patterns and transform your data into galaxies of insights. Let’s navigate your data multiverse together.
Schedule a call
About
Projects
Services
Contact
© 2025 Adam Dandi
Privacy policy
Terms & conditions