Hotel RevPAR Performance Readout
The hotel charges more than its comp set and fills fewer rooms.
A monthly STR-style performance report for an urban hotel: occupancy, ADR, RevPAR, and market share indices against a competitive set. Built from 119,000 real bookings through a bronze, silver, and gold Delta pipeline on Databricks.

Source: Kaggle Hotel Booking Demand dataset. Comp set simulated from the source data.
Recommendation
Hold rate. The property earns more per available room than its comp set because its rate premium outweighs an occupancy shortfall. The shortfall is concentrated in midweek, short-lead corporate business that a discounting competitor is winning. Address it with targeted corporate rates and a two-week booking offer rather than a general rate cut.
A general rate cut would give up revenue the property already earns to buy occupancy it can win at lower cost.
Results
The property's RevPAR index is above 100 in every month of the trailing twelve. The gain comes from rate: the ADR index is above 100 throughout while the occupancy index is below it.


Occupancy
The occupancy shortfall is concentrated midweek, where a discounting competitor is taking share. Segment mix and booking pace point to transient corporate demand booked inside two weeks.


Pipeline
Raw bookings are loaded to a Unity Catalog volume and written to a bronze Delta table unchanged, with an ingestion timestamp.
Arrival dates assembled, cancellations typed, zero-guest and negative-rate rows removed, one €5,400 ADR outlier capped, market segments normalized to five values. Data-quality checks stop the run on any failure.
Four competitor hotels simulated from the subject's daily history with different pricing behavior. Results are aggregated room-weighted, following STR practice.
Bookings expanded to stay nights for daily occupancy, ADR, and RevPAR. Monthly rollups add MPI, ARI, and RGI. Booking pace measured at 120, 60, and 30 days before arrival.
Background
Hotel revenue analyst roles require reading STR reports, so this project follows STR conventions: RevPAR index, MPI, ARI, comp set, pace, and pickup. The pipeline is built as a production Databricks lakehouse would be. The output is the monthly report a general manager receives.
Portfolio project on public data. The competitive set is simulated and does not represent a real market. Code and tests are on GitHub.








