AtliQ Grands Hospitality Insights

Provide Hospitality insights

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.

Tech Stacks:

• Power BI
• Power Point
• Excel
• Language- M, DAX

Workflow steps:

1. Data collection and exploration, create date table in Power Query (M language).
2. Data load to Power BI and initial validation.
3. Data Transformation in Power Query.
4. Data Modelling and creating calculated columns.
5. Creating measures using the DAX language.
6. Build Executive View, Finance View, Revenue View, Occupancy and Booking View and Key Metrics View.
7. Designing an effective Dashboard which includes page navigation with buttons, tooltips, using KPI’s, conditional formatting of the values in visuals.
8. Deploying the solution using Power BI Service.

• Dashboard link: https://app.powerbi.com/view?r=eyJrIjoiNzk3N2U1NjUtMDJmZS00ZWMzLWI4Y2ItNzA1ZGE4Y2EyNWJjIiwidCI6ImM2ZTU0OWIzLTVmNDUtNDAzMi1hYWU5LWQ0MjQ0ZGM1YjJjNCJ9
• LinkedIn: https://www.linkedin.com/in/venkata-siva-santhi-anantha-71634a27a/

Key metrics:

• Revenue realized: 1.69 billion rupees
• RevPAR: 7,337
• DSRN: 2,528
• Occupancy percentage: 57.8%
• ADR: 12.70K
• Realization percentage: 70.1%

Recommendations:

1. Atliq Grands, a luxury hotel in Delhi, despite its good ratings, is underperforming in revenue generation. A strategic plan is needed to boost bookings and reduce cancellations.
2. Atliq Palace in Hyderabad is struggling with low bookings, potentially due to low ratings. As a business hotel, its high ADR of 9,480 rupees and low Occupancy percentage need attention.
3. Atliq Grands in Hyderabad is another hotel with lower revenue due to poor ratings and low Occupancy percentage. Efforts should focus on increasing bookings.
4. The decline in revenue is primarily linked to low Occupancy percentages, which, in turn, result from fewer bookings. Strategies should be devised to enhance booking rates.
5. ADR should be adjusted dynamically based on factors like the city, weekdays, and low-demand days to maximize revenue.

• Finally, I would like to thank codebasics team, Dhaval Patel, Hemanand Vadivel for creating this wonderful course.