Progress
Chapter 7 / 9
Explore every atomic fact and conformed dimension by domain. Dashed relationships point from fact foreign keys to shared dimensions.
A fact table exists only when the business process has a distinct grain.
fact_trip
1 row per trip request, including cancelled and expired outcomes
fact_trip_event
1 lifecycle event per trip
fact_location_ping
1 accepted device-location observation
fact_ride_request
1 rider request attempt
fact_match_attempt
1 dispatch offer to 1 candidate driver
fact_driver_supply_snapshot
1 geo cell × service × snapshot interval
fact_fare_quote
1 fare quote per rider and service option
fact_payment_transaction
1 payment-ledger movement
fact_driver_earning
1 earning component credited or debited to a driver
fact_rating
1 rating submission
fact_promotion_redemption
1 applied promotion component per trip
fact_driver_incentive
1 driver × incentive program × period
fact_safety_incident
1 reported safety incident
fact_support_case
1 support case
fact_experiment_exposure
1 verified experiment exposure
The same historical definitions support marketplace, finance, safety, support, and experimentation facts.
dim_date
1 calendar date
dim_time
1 second or minute of day
dim_rider
1 historical rider profile version
dim_driver
1 historical driver profile version
dim_vehicle
1 historical vehicle version
dim_service_type
1 service product definition
dim_city
1 operating city
dim_geo
1 historical H3/S2 cell mapping
dim_trip_status
1 canonical trip status
dim_event_type
1 canonical event type
dim_payment_method
1 tokenized payment-method definition
dim_currency
1 ISO currency
dim_promotion
1 promotion definition
dim_incentive_program
1 driver incentive definition
dim_experiment
1 experiment definition
dim_variant
1 treatment variant
dim_device_app
1 app/device release combination
dim_channel
1 interaction channel
dim_safety_incident_type
1 controlled incident classification
