Customer Analytics Dashboard For NOVOTEL-HOTEL

I developed an interactive Customer Analytics Dashboard to help NOVOTEL analyze guest feedback, booking sources, and operational performance in one centralized view.

The dashboard includes:

Average rating and NPS analysis to measure guest loyalty

Guest segmentation by gender and visit purpose

Department performance tracking (rooms, staff, restaurant, facilities)

Lead source analysis to evaluate marketing effectiveness

Year and month filters for trend and seasonal analysis

Business Growth Impact

This dashboard supported hotel growth by:

Improving customer satisfaction: Low-rated services (e.g., food variety and facilities) were identified and improved, increasing overall guest experience and review scores.

Increasing repeat bookings: By reducing detractors and focusing on promoters, the hotel strengthened loyalty and word-of-mouth referrals.

Optimizing marketing budget: High-performing channels like corporate organizations and booking platforms were prioritized, while low-performing channels were reduced, improving ROI.

Boosting corporate revenue: Insights showed strong organization-based bookings, leading management to expand corporate partnerships.

Supporting data-driven decisions: Management could quickly analyze trends and adjust pricing, promotions, and service strategies accordingly.

This project demonstrates my ability to turn raw data into strategic insights that directly contribute to revenue growth, operational efficiency, and improved customer retention.