City and hotel resort data analytics

City & Resort Hotels: End-to-End Data Analysis and Interactive Canva Dashboard

Project Description:

Data Cleaning & Preprocessing: Processed and cleaned a comprehensive hospitality dataset comprising 119,390 unique reservation records spanning from July 2015 to August 2017 across City and Resort properties. Handled data normalization, missing values, and exploratory data analysis (EDA) across 32 distinct hotel booking metrics.

Key Analytical Findings:

Analyzed operational patterns, discovering that City Hotels experience a much higher volume of total guests and cancellations compared to Resort Hotels.

Identified market trends showing that 90%+ of guests book without a deposit, Portugal (PRT) serves as the primary visitor market, and Bed & Breakfast (BB) dominates meal preferences.

Assessed booking lead times, room type allocations (with Room Type A being the most requested), channel distributions (heavily dominated by Travel Agencies / TA/TO), and seasonal peaks.

Visualization & Delivery: Designed an eye-catching, professional, and dynamic multi-slide dashboard layout using Canva to present high-level executive metrics, granular answers to 16 key business questions, and actionable strategic recommendations for hotel management.