Hotel Bookings

July 2023 Geographic Difficulty 3/5 TXT · XLSX 14.0 MB 119,390 rows × 32 cols 0 downloads
  • hotels
  • bookings
  • hospitality
  • cancellations
  • timeseries

119,390 hotel-booking records with lead time, cancellation, deposit type, market segment, and average daily rate fields. Classic operations dataset for cancellation-risk modelling and segment-level ADR analysis.

Challenge brief

slug: 2023-07-hotel-bookings title: Hotel Bookings year: 2023 month: 07 source: authored authored_at: 2026-04-19 needs_leon_review: true

Hotel Bookings - Challenge Brief

Challenge period: July 2023 Dataset: Reconstructed brief based on the shipped data file for the July 2023 DataDNA challenge.

About the data

The primary data table for this challenge carries the following columns:

  • hotel
  • is_canceled
  • lead_time
  • arrival_date_year
  • arrival_date_month
  • arrival_date_week_number
  • arrival_date_day_of_month
  • stays_in_weekend_nights
  • stays_in_week_nights
  • adults
  • children
  • babies
  • meal
  • country
  • market_segment
  • distribution_channel
  • is_repeated_guest
  • previous_cancellations
  • previous_bookings_not_canceled
  • reserved_room_type
  • assigned_room_type
  • booking_changes
  • deposit_type
  • agent
  • company
  • ...and 7 more columns

Suggested analytical angles

  • Which customer segments have the highest cancellation risk?
  • How do lead time and deposit type interact with outcomes?
  • Which market segments drive the highest average daily rate?
  • How do arrival-month patterns differ between resort and city hotels?

What great submissions did

This brief was reconstructed from the dataset contents in 2026 as part of the Playground audit. The original July 2023 challenge brief was not preserved as a separate file in the source archive, so the analytical angles above are inferred from the column list. See the corresponding /challenges/ entry on datadna.onyxdata.co.uk for examples of how participants approached the data.

Editorial note

_This stub was authored by Claude on 2026-04-19 for Leon's review. Refine the suggested angles and confirm factual accuracy before setting brief_status = leon_reviewed in the audit log._

This dataset was the subject of the DataDNA July 2023 community challenge. The original scoring and leaderboard pre-date the current submission system and are not available for display.

Browse open challenges