Role
Data Analyst (Student)
Context
Academic (Consulting case study)
Stack
3 tools
Case study on a hotel dataset (occupancy, pricing, seasonality) to identify performance levers. Dataset cleaning (Excel). Creation of pivot tables (occupancy, RevPAR, ADR). Construction of visual dashboards to facilitate trend reading. Writing a report with recommendations (dynamic pricing, segmentation).
Technologies
Excel/SheetsPivot TablesData Analysis
Deliverables
Cleaned and structured dataset
Excel/Sheets dashboards
Analysis report
Pricing recommendations
🎯 Results
Clear visualization of performance gaps by season, room type, and sales channel. Practical recommendations to improve occupancy rates.