Hotel-Revenue-Excel-Analysis

Excel Dashboard to analyze data of a hotel over the past three years.

BY MOHAMED ALGHALY

Dashboards

Bookings Analysis

Insights on reservations demand and key factors that impact the bookings.

Cancellation Analysis

Insights on what are the factors that affect bookings' cancelation .

Age Analysis

Analyze customer satisfaction over each age.

INSIGHTS & RECOMMENDATIONS

1- Cancellation rates and booking rates are higher for City Hotel.

• As cancellation rates are higher for City Hotel, we need to make some extra effort to improve its performance.

2- The cancellation rate increases as the gap between booking and arrival increases.

• We should set a limit on the lead time, like you can’t book a room before a month of arrival.

• We can set the limit to 2 weeks max.

3- Cancellation rates are lower in November.

• We need to communicate with the management team to understand why cancellation rates are lower in November.

4- Bookings are higher in July – August – October.

• We should do some marketing and offers in other months.

5- Bookings are high at the end of the month.

• We can offer more products or services to benefit from rush days.

6- We have serious issues with groups, families, and large parties.

• We should come up with a program to offer that suits families and groups.

7- Most of the meals we are offering are not popular.

• We must upgrade our kitchen and improve our food.

8- Most of the booking channels are not active.

• We need to hire a good marketing team.

9- People with previous cancellations of more than 10 are a danger.

• We can refuse any booking when the customer has cancelled more than 10 bookings before.

• Or take a non-refundable deposit from him.

10- When the customer doesn’t get the room, he has asked for, he is upset.

• We should try our best to give him the room he wants.

• When a customer asks for any type of room give him the least popular one.

• We need to communicate with the management team to come up with other solutions for this issue.

11- Non-Refundable deposits are not acceptable.

• We could limit that option as we can.

12- Cancellation rates are higher for non-regular customers.

• We can make offers and deals for new customers.

13- The best performing salesmen are 250 and 9.

• We can make offers for salesmen to improve their performance.