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.

  1. 1Five Silver-layer tablesGoverned tables on a medallion architecture, built from the operational systems
  2. 2Record-level quality scoringEvery record scored HIGH / MEDIUM / LOW / EXCLUDE
  3. 3Canonical carrier identity3.13M carrier records resolved to 238K canonical carriers
  4. 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

All case studies

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.

Get your AI Blueprint →