A hospitality data architecture

Every data source a hotel or serviced-apartment operator already has (PMS, booking channels, reviews, CRM), unified in one lakehouse it owns, powering the reporting the team actually uses. A worked example, not a template.

Hotels and serviced apartments: PMS, IBE, OTAs and channel managers.

Data flows in from 8 sources
Data flows in from 8 sources
Insights flow out
Insights flow out
DATEV

Accounting & finance

Your Business plans & goals

Reviews & guest feedback

Market & competitor data

Booking Channels

· incl. OTAs

apaleo
Mews
Booking.com
Airbnb
Expedia
Agoda

CRM

Marketing Performance

Google Ads
Meta
Instagram
LinkedIn

+ more

GA4 (Google Analytics 4)

Web tracking

Data Lakehouse

Your central source of truth

Raw data transformed into metrics
Raw data transformed into metrics

Investor & fundraising materials

Board decks, data rooms, metrics

Dashboard chart types
Dashboard chart types

Dashboards

Live KPIs across the business

Custom reports, forecasts & more

Ad-hoc analysis, projections

+ 6 more sources: web tracking, CRM, market data, guest reviews, your business plans, accounting

+ 6 more sources: web tracking, CRM, market data, guest reviews, your business plans, accounting

How to read this

Left: the sources. Middle: the lakehouse (one place, one definition per number, owned by you). Right: what the business gets out of it. The sources change from client to client; the shape rarely does.

See the e-commerce example →

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.

Curious what yours would look like?

I usually sketch the target architecture in the first two weeks, before anything gets built.