Star Grand Hotel in Buea had a marked rise in cancellations and no-show reservations, erratic occupancy rates, and irregular booking patterns.

STAR GRAND HOTEL - POWER BI REPORT

Industry: Hospitality

Data Analysis, Excel, Power BI

Problem:

Star Grand Hotel in Buea had a marked rise in cancellations and no-show reservations, erratic occupancy rates, and irregular booking patterns. Additionally, the hotel noticed variations in revenue among platforms and room classes, but it was unable to provide definitive explanations for these variations. Demand forecasting was further hampered by seasonal fluctuations, which made efficient resource planning challenging. Furthermore, it was difficult to see how various booking platforms and room types affected overall performance. It was difficult to monitor important indicators, comprehend visitor behavior, and pinpoint problem areas impacting income and occupancy in the absence of trustworthy performance tracking.

Solution:

This project addresses these challenges through a comprehensive data analysis approach, including Exploratory Data Analysis (EDA), key metric tracking (Revenue, ADR, RevPAR, Occupancy), and Week-over-Week (WoW) performance evaluation. By analyzing patterns in bookings, cancellations, platform usage, and room class preferences, the goal is to uncover actionable insights that drive smarter decision-making.

Dashboard Creation

Create dynamic dashboards to display:

Total Revenue and WoW change %
Occupancy and ADR trends
Noshow rates and cancellation analysis
RevPAR and realisation % trends
Booking trends by platform and room class

Performance Reporting

Generate reports summarizing key findings on:
Revenue, occupancy, and ADR trends
Platform and room class performance
Areas for optimization (e.g., reducing noshows and cancellations)

Result:

The final deliverables include dynamic dashboards and performance reports that provide a clear view of business performance, highlight areas for optimization, and support data-driven strategies for increasing guest satisfaction and profitability.

📈 Regional Revenue Analysis: Yaoundé with Highest Revenue of 199,557,262 fcfa

✅Calculate Revenue per Category: Luxury was making the highest revenue of 75,503,040 fcfa.

📊Occupancy Analysis: Occupancy stood at 18% during weekends & 13% during weekdays.

🚢NoShow and Cancellation Analysis: Cancellation rates where 24% & NoShow Rate at 5%.

🙋🏽Booking %tage by Platform: Other platforms dominates with 41%, direct offline stood at 5%.

STAR GRAND HOTEL - POWER BI REPORT

Problem:

Solution:

Result:

Let’s Work Together