Infosys-HotelRevAi

Project information

The project focuses on developing a Hotel Revenue Optimization and Guest Analytics Dashboard using Power BI to analyze booking, customer, and room data. The approach began with data collection, cleaning, and transformation using Power Query to ensure accuracy and consistency. A star schema data model was created with booking data as the fact table and Date, Customer, Room, and Hotel Branch as dimension tables. Calculated columns such as booking duration, stay type, and lead time were added to enhance analysis. Key performance indicators like Occupancy Rate, Average Daily Rate (ADR), and Revenue Per Available Room (RevPAR) were developed using DAX to measure hotel performance. The project was implemented through modules including occupancy and revenue analysis, guest segmentation, forecasting and cancellation trends, and a revenue strategy dashboard. Interactive dashboards with filters and visuals were created to present insights clearly. Technologies used include Power BI, Power Query, DAX, and data modeling techniques. This project has real-world impact by helping hotel management improve pricing strategies, optimize occupancy, reduce cancellations, and make data-driven decisions.

PowerBI data analysis