Unlocking Hospitality Performance with Data

Transforming hotel metrics into actionable insights using Tableau, PostgreSQL, and Python.

Featured Analysis Projects

Booking Pace Analysis

Visualizing year-over-year room sales and seasonality insights using Tableau dashboards.

View

Segment Performance

PostgreSQL & Python visualizations tracking ADR across market segments weekly.

Explore

Forecast vs Actual

Compare forecasted and actual demand across lead times, segments, and seasons.

Details

Project Highlights

Market Segment Booking Pace Analysis

Analyzed OTA vs Direct bookings (2018–2020) using historical OTB data.
Segmented bookings by lead time and grouped by weekly arrival dates.
Generated KPIs: Room Nights, ADR, Revenue by segment and lead time.
Created dynamic filters by hotel and channel in Tableau dashboards.

Booking Trends Analysis

ADR & RevPAR Weekly Insights

Tracked weekly ADR shifts and pricing volatility by segment and year.
Visualized ADR change YoY between 2018–2020 for pricing optimization.
Identified underperforming weeks and price sensitivity indicators.

View ADR Insights

Forecast vs Actual Performance

Measured variance in forecasted vs actual room nights and ADR by week.
Highlighted segment-level forecast accuracy and booking behaviors.
Supported future model refinement based on variance tracking.

View Forecast Comparison

Check out My Portfolio →