Financial analysis and performance review of ATLIQ Hotels: Strategic expansion perspectives

ATLIQ Hotels, being one of the upscale hotel chains with hotels in major Indian cities, embarked on data-driven innovation with an aim to enhance its marketing and operational strategy. This capstone project integrates high-value transactional data and interactive Power BI reports to disclose action-oriented insights for the months May to July 2022. From a combination of hotel reservations, room categories, finances, and customer reviews, the project offers an integrated depiction of ATLIQ's day-to-day performance environment. Five key datasets of hotel facilities, room categories, guest actions, and reservation outcomes were considered in the analysis. Critical measures such as Revenue per Available Room (RevPAR), occupancy, cancellation/no-show rate, and guest satisfaction were cross-tabulated across cities and room categories. Presidential and Elite rooms consistently generated higher revenues for Luxury compared to Business class, but with greater guest satisfaction. Lower occupancy levels suggest price inefficiencies. Weekend days showed higher cancellation rates, which may reflect overbooking or misguided promotional efforts. Power BI graphics depicted significant city-level variations: Delhi and Mumbai yielded highest revenues, whereas Ahmedabad apartments lagged behind although retaining consistent traffic. Skeptical analysis of booking platforms revealed undue third-party platform dependence, and this made it clear that there was scope for increasing ATLIQ's direct channel exposure. Ultimately, the project proposes dynamic pricing systems, location-based experience optimization, and platform diversification. This information-driven system positions ATLIQ Hotels to heighten customer engagement, maximize revenue capture, and achieve competitive edge by concentrating on promotion in a highly dynamic hospitality environment.