Guides

Practical walkthroughs for working with the hotel data, using the free sample's real columns and figures.

Load Hotel Building Polygons (WKT) in GeoPandas, PostGIS and QGIS

Step-by-step guide to loading the hotel building polygons from WKT into GeoPandas, PostGIS and QGIS, checking match grades and converting them to GeoJSON.

Hotel Direct vs OTA Prices: How to Read the Data

How to read direct_vs_lowest_ota_pct: what the gap between a hotel website price and the lowest OTA offer means, what the sample shows and its caveats.

How to Build a Hotel Prospect List in Excel

Build a hotel prospect list in Excel: filter the hotel data by country, class, rating, chain and available contacts, and choose the columns that matter.

Track Hotel Openings and Closures Month by Month

Use the lifecycle columns, the monthly change log and neighbourhood momentum in the hotel data to track hotel openings, closures and reopenings over time.

Every column mentioned in the guides is in the data dictionary. To follow along, download the sample.