Data ontology
The estate, by business domain 6 domains, the apps & tables, metrics and reports inside each, and the flows that funnel between them. Zoom into any lane to its lineage, then into any table to its fields. 3 of 6 contested; 5 of 6 have no owner.
↰ Zoom out ▲ Explode OTD
credit_amount forks BOTH Revenue (Billing) and On-Time Delivery (Delivery) orders.origin_facility_id → facilities: 4 orphan rows (value 999), no enforced key Delivery timeliness CONTESTED The estate's most contested domain — two OTD numbers, no canonical source, no owner. 3 tables · 2 metrics · 5 reports TMS Dana Reyes › Delivery timeliness — The estate's most contested domain — two OTD numbers, no canonical source, no owner. (source: TMS; owner: Dana Reyes) Billing & revenue CONTESTED Gross-vs-net revenue forks on the same credit field that forks OTD. 1 table · 1 metric · 0 reports Billing / ERP UNOWNED › Billing & revenue — Gross-vs-net revenue forks on the same credit field that forks OTD. (source: Billing / ERP; UNOWNED — no owns edge) Customer CONTESTED 'Active customer' resolves two ways. 1 table · 1 metric · 0 reports CRM UNOWNED › Customer — 'Active customer' resolves two ways. (source: CRM; UNOWNED — no owns edge) Carrier performance CLEAN Carrier scorecard is in regular, trusted use. 2 tables · 0 metrics · 1 report TMS UNOWNED › Carrier performance — Carrier scorecard is in regular, trusted use. (source: TMS; UNOWNED — no owns edge) Warehouse throughput CLEAN WMS throughput; lightly modeled. 1 table · 0 metrics · 0 reports WMS UNOWNED › Warehouse throughput — WMS throughput; lightly modeled. (source: WMS; UNOWNED — no owns edge) Exceptions & claims CLEAN Exceptions log in regular use; resolution timing is patchy. 1 table · 0 metrics · 0 reports TMS UNOWNED › Exceptions & claims — Exceptions log in regular use; resolution timing is patchy. (source: TMS; UNOWNED — no owns edge) Source Tables Metrics Reports & dashboards Delivery timeliness TMS Source system: TMS shipment_events 10,613 rows shipment_events — 10,613 rows. Click to open its fields. shipments 5,416 rows shipments — 5,416 rows. Click to open its fields. orders 5,000 rows orders — 5,000 rows. Click to open its fields. On-Time Delivery contested On-Time Delivery (headline metric) — contested OTIF (On-Time In-… undefined OTIF (On-Time In-Full) — undefined Ops OTD Dashboard 94.1% OTD Ops OTD Dashboard — 94.1% (shipment grain, vs the SLA date) Finance OTD Pack 87.7% OTD Finance OTD Pack — 87.7% (billed order, post-credit) Board OTD Pack computes Board OTD Pack Carrier Scorecard 94.1% OTD Carrier Scorecard — 94.1% (shipment grain, vs the SLA date) Exec KPI Scorecard computes Exec KPI Scorecard credit_amount ← Billing credit_amount arrives from Billing/ERP and forks the OTD number. Click to jump to the Billing lane. ← invoices → orders Incoming flow from Billing & revenue: invoices → orders ← exceptions → shipments Incoming flow from Exceptions & claims: exceptions → shipments shipments → carriers → Outgoing flow to Carrier performance: shipments → carriers orders → customers → Outgoing flow to Customer: orders → customers orders → facilities → Outgoing flow to Warehouse throughput: orders → facilities (orphaned reference — 999) Source Tables Metrics Reports & dashboards Billing & revenue Billing / ERP Source system: Billing / ERP invoices 4,695 rows invoices — 4,695 rows. Click to open its fields. Revenue contested Revenue — contested invoices → orders → Outgoing flow to Delivery timeliness: invoices → orders invoices → customers → Outgoing flow to Customer: invoices → customers Source Tables Metrics Reports & dashboards Customer CRM Source system: CRM customers 60 rows customers — 60 rows. Click to open its fields. Active customer contested Active customer — contested ← orders → customers Incoming flow from Delivery timeliness: orders → customers ← invoices → customers Incoming flow from Billing & revenue: invoices → customers Source Tables Metrics Reports & dashboards Carrier performance TMS Source system: TMS shipments shared · see Delivery shipments — 5,416 rows. Click to open its fields. carriers 12 rows carriers — 12 rows. Click to open its fields. Carrier Scorecard 94.1% OTD Carrier Scorecard — 94.1% (shipment grain, vs the SLA date) ← shipments → carriers Incoming flow from Delivery timeliness: shipments → carriers Source Tables Metrics Reports & dashboards Warehouse throughput WMS Source system: WMS facilities 8 rows facilities — 8 rows. Click to open its fields. ← orders → facilities Incoming flow from Delivery timeliness: orders → facilities (orphaned reference) Source Tables Metrics Reports & dashboards Exceptions & claims TMS Source system: TMS exceptions 157 rows exceptions — 157 rows. Click to open its fields. exceptions → shipments → Outgoing flow to Delivery timeliness: exceptions → shipments shipment_events 10,613 rows · TMS event_id unknown event_id [unknown] shipment_id unknown shipment_id [unknown] event_type unknown event_type [unknown] event_time unknown event_time [unknown] shipments 5,416 rows · TMS · Golden source ⚠ delivered_date 2.9% null · promised_delivery_date 1.0% null · 13 delivered-before-shipped · status ha… shipment_id unknown shipment_id [unknown] order_id unknown order_id [unknown] carrier_id unknown carrier_id [unknown] ship_date unknown ship_date [unknown] promised_delivery_date date 1% null feeds On-Time Delivery promised_delivery_date [date] — feeds On-Time Delivery delivered_date date 2.9% null feeds On-Time Delivery delivered_date [date] — feeds On-Time Delivery status text 5 casing variants status [text] weight_lbs unknown weight_lbs [unknown] orders 5,000 rows · TMS ⚠ origin_facility_id: 4 orphan rows (1 bad value) order_id unknown order_id [unknown] customer_id unknown customer_id [unknown] order_date unknown order_date [unknown] promised_date unknown promised_date [unknown] service_level unknown service_level [unknown] origin_facility_id integer 4 orphan rows (value 999) origin_facility_id [integer] status unknown status [unknown] invoices 4,695 rows · Billing / ERP · Financial · Golden source ⚠ credit_amount is the OTD fork field invoice_id unknown invoice_id [unknown] customer_id unknown customer_id [unknown] order_id unknown order_id [unknown] invoice_date unknown feeds Active customer invoice_date [unknown] — feeds Active customer amount unknown feeds Revenue amount [unknown] — feeds Revenue credit_amount numeric feeds On-Time Delivery, Revenue credit_amount [numeric] — FORK FIELD: feeds On-Time Delivery + Revenue status unknown status [unknown] exceptions 157 rows · TMS ⚠ resolved_at 30.6% null exception_id unknown exception_id [unknown] shipment_id unknown shipment_id [unknown] reason_code unknown reason_code [unknown] opened_at unknown opened_at [unknown] resolved_at date 30.6% null resolved_at [date] customers 60 rows · CRM · PII / customer data · Golden source ⚠ 'active' = 53 by CRM status vs 60 billed in 90d customer_id unknown customer_id [unknown] name unknown name [unknown] segment unknown segment [unknown] region unknown region [unknown] status unknown feeds Active customer status [unknown] — feeds Active customer created_at unknown created_at [unknown] carriers 12 rows · TMS carrier_id unknown carrier_id [unknown] name unknown name [unknown] mode unknown mode [unknown] scac unknown scac [unknown] facilities 8 rows · WMS facility_id unknown facility_id [unknown] name unknown name [unknown] region unknown region [unknown] type unknown type [unknown] On-Time Delivery, traced on the same data — two answers
94.1%
Ops, shipment grain
4,895 / 5,203
87.7%
Finance, post-credit
4,116 / 4,695