Hospitality Domain Project

Project Overview

Operation manager at one of the hotel chains asked for a dashboard that allows him to monitor the following key metrics

1. Revenue & revenue WoW change.

2. Total number of bookings.

3. Total capacity.

4. Total successful bookings.

5. Occupancy %

6. Average rating.

7. Number of days.

8. Total canceled bookings.

9. Cancelation %

10. Total Checked out.

11. Total no-show bookings.

12. No show %

13. Booking % by platform.

14. Booking % by room class.

15. ADR (measures the average paid for rooms booked in a given time period).

16. Realization % (successful checked out percentage overall bookings).

17. RevPAR (represents the revenue generated per available room, whether or not they are occupied - helps hotels measure their revenue-generating performance to accurately price rooms)

18. DBRN (measures on average how many rooms are booked for a day in a given time period)

19. DSRN (measures on average how many rooms are ready to sell for a day in a given time period)

20. DURN (measures on average how many rooms are successfully utilized by customers for a day in a given time period)

21. Occupancy WoW % change.

22. ADR WoW % change.

23. RevPAR WoW % change.

24. Realization WoW % change.

25. DSRN WoW % change.

Also, I got asked to prepare an infographic for the team members that will be responsible to update the dashboard in order to help them with the training they received.