Data Quality
5 open issuesCompleteness, uniqueness, validity — including missing VIN and unknown driver rules.
Completeness
0
Uniqueness
0
Validity
0
Freshness
0
Referential
0
Rejects 24h
0
Duplicates 24h
0
Quality issues
Missing VIN · unknown driver · GPS bounds · fuel txn duplicates
5 records
| Issue | |||||||
|---|---|---|---|---|---|---|---|
| high | dim_truck | VIN required & checksum | Missing or malformed VIN on truck master after Fleetio sync Samples: trk-014, trk-067, trk-091 | 7 | Fleet Data Steward | open | 12 hours ago |
| medium | fact_trips | driver_id must resolve to dim_driver | Unknown driver on telematics trips (contractor ELD mismatch) Samples: trip-88211, trip-88240, trip-88301 | 38 | Driver Ops | triaging | 12 hours ago |
| medium | fact_trips | lat/lng within CONUS bounds | Invalid GPS coordinates (0,0) or ocean points Samples: trip-79012, trip-79100 | 54 | Telematics Eng | open | 12 hours ago |
| high | fact_trips | unique (truck_id, start_ts) | Duplicate trips from overlapping Samsara + Motive feeds Samples: trip-90101, trip-90102 | 21 | Data Engineering | open | 12 hours ago |
| critical | fact_fuel | unique txn_id | Fuel card duplicate IDs after vendor re-send — CPM distortion risk Samples: fuel-02901, fuel-02902, fuel-02940 | 142 | Data Engineering | triaging | 13 hours ago |