Revenue Analysis - Hospitality Business

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. 

KEY INSIGHTS:

• There is a negative correlation between revenue and revenue per guest, this is probably because the more expensive rooms have fewer guests/bookings.

• The Atliq Palace and Atliq City have a relatively high average revenue per guest and revenue realized.

• Luxury properties account for 61% of the total revenue.

KEY PERFORMANCE INDICATORS:

• Bookings with an average revenue per guest of 5000 or less account for 40% of total bookings, 78% of canceled bookings, 27% of total realized revenue, and 71% of total lost revenue.

• Properties that cost up to 13,000 per guest had zero canceled bookings.

• Atliq seasons and Atliq Grand's ratings were below the average of 4.