Introduction - This Power BI project focused on analyzing hotel business data from OYO Rooms. This project involved transforming raw data into actionable insights, enhancing my analytical skills.
TechStack - Microsoft Power BI
The process includes:
-Data cleaning and transformation using Power Query.
-Data modelling
-Calculating various key measures using DAX functions
-Data visualisation
Key Performance Indicators:
-Revenue
-Revenue Per Available Room (RevPAR)
-Occupancy %
-Realization %
-Cancellation %
-Average Daily Rate (ADR)
-Average rating
-Daily Sellable Room Nights (DSRN)
-Daily Booked Room Nights (DBRN)
-Daily Utilized Room Nights (DURN)
Informative Charts:
Percentage of Revenue by Category
Trend by Key Metrics - ADR, RevPAR, Occupancy %
Realization % and ADR by Booking Platforms
Property by Key Metrics
Week over week changes of Key Metrics