Data Lineage · source → fact → mart → portal
Every KPI on this portal traces back to its source. Click a column header to follow the chain.
1 · Sources
raw signals · 8 systems · streaming + batch
LiteAPI REST
EXTERNAL API
/data/hotels · /hotels/rates · /bookings · /data/hotel
LiteAPI MCP
EXTERNAL API
open-source mcp-server · session-tagged calls
Stripe webhooks
WEBHOOK
billing.* events for partner SaaS-tier
Partner CRM
BATCH
Salesforce sync · partner_id, contract_terms
Booking events
STREAM
Kafka · search → shop → book → confirm
Support tickets
BATCH
Zendesk JSON dump · NPS/CSAT scoring
Infra logs
STREAM
Cloudflare + Vercel + API logs
Marketing
BATCH
GA4 · Adwords · LinkedIn campaign API
↓
2 · Landing (raw)
bronze layer · DWH · partitioned by ingest date
raw_bookings
bronze
Kafka → BigQuery via Cloud Composer · 5min lag
raw_hotels_snapshot
bronze
Daily snapshot from /data/hotels · 3M rows
raw_rates_history
bronze
Hourly rates poll · price-parity ground truth
raw_partner_events
bronze
All partner-side activity · session-tagged
raw_mcp_traces
bronze
MCP middleware logs · tool, latency, status
raw_tickets
bronze
Zendesk daily dump · ticket lifecycle
↓
3 · Curated (silver) — dbt models
cleaned · typed · partitioned · documented · tested
dim_hotel
dbt
Master hotel dim · joins LiteAPI + cross-source rohId
dim_partner
dbt
API customer dim · concentration buckets
fact_bookings
dbt
1 row per booking · price, commission, status
fact_rates
dbt
1 row per rate quote · supplier, board, price
fact_mcp_calls
dbt
1 row per MCP tool call · tool, latency_ms, status
fact_industry_daily
dbt
agg fact · revenue/sessions/users/events per day
↓
4 · Marts (gold)
department-shaped · what dashboards consume
travel_bookings_reservations_daily_2022_2024.csv
mart · gold
Bookings & Reservations · daily values · 11 cols
travel_finance_daily_2022_2024.csv
mart · gold
Finance · daily values · 11 cols
travel_customer_experience_daily_2022_2024.csv
mart · gold
Customer Experience · daily values · 11 cols
travel_inventory_management_daily_2022_2024.csv
mart · gold
Inventory Management · daily values · 11 cols
travel_marketing_daily_2022_2024.csv
mart · gold
Marketing · daily values · 11 cols
travel_operations_daily_2022_2024.csv
mart · gold
Operations · daily values · 11 cols
travel_partner_management_daily_2022_2024.csv
mart · gold
Partner Management · daily values · 11 cols
travel_it_platform_daily_2022_2024.csv
mart · gold
IT & Platform · daily values · 11 cols
↓
5 · Portal · what you see now
Next.js dashboard · this site
Command Center
/
Live KPIs from LiteAPI sandbox + 8-dept rollup
Daily 360° Overview
/daily-360
fact_industry_daily_travel · all 8 departments
Departments
/departments
one mart per department · drill-in to all KPIs
KPI Catalog
/kpi-catalog
98 KPIs · 13 categories · formula + source per row
Supply Quality / Pricing
/supply-quality
live LiteAPI · per-city · sortable + filterable
MCP Funnel & Latency
/mcp/*
agentic differentiator · mocked, prod-ready
Read the chain: a number you see on the portal came from a curated dbt model that read from a typed landing table that ingested raw events from a named source system. Every link is documented and tested on the production stack; here we ship the JSON snapshots compiled at build time.