Case study · Logistics & freight · Data foundation
Trusted carrier data that unblocked two AI initiatives
A PE-backed freight brokerage. A governed data foundation that resolved duplicated carrier identities so matching and pricing models could be built on it.
The results
13:1duplication resolved: 3.13M records to 238K carriers
~97%of carrier records linked to a canonical carrier
2AI initiatives unblocked: matching and pricing
0records silently dropped (flag, don't filter)
!The challenge
- Carrier-to-load matching models blocked
- Freight pricing models blocked
- Carrier identity duplicated across systems
- No trusted, documented foundation for models
⚙The approach
- Fixed bid, 4 weeks plus ramp
- Medallion architecture built from operational systems
- SQL with record-level quality scoring
- Locked grain decisions and a data dictionary
The solution: Governed data foundation
Five governed Silver-layer tables built on one principle: flag, don't filter. Every record is kept and scored, so nothing disappears quietly.
- 1Five Silver-layer tablesGoverned tables on a medallion architecture, built from the operational systems
- 2Record-level quality scoringEvery record scored HIGH / MEDIUM / LOW / EXCLUDE
- 3Canonical carrier identity3.13M carrier records resolved to 238K canonical carriers
- 4Issue log & remediation backlogDocumented issues, data dictionary and a remediation backlog
Where else it appliesPorts, logistics and rail operators need the same first step: one trusted record per customer, carrier and asset before matching, pricing and planning AI can work.
Client names are withheld to respect confidentiality and shared on request. Ask for a reference
Want a result like this in your business?
Tell us the process you want to change and we'll start with a free 24-hour AI Blueprint.





