Data platform that gave a fuel carrier one view of outages, tolls, deliveries, and drivers
Consolidated six systems (DTN, Gravitate, Samsara, Bestpass, TMW, Google) into one data platform for the same mid-market fuel carrier. Dashboards track tank outages across 5,000+ sites, hold toll spend to policy and reclaim $200K+ a year, score every delivery window by GPS geofence, and keep driver hours honest.
The client's name has been anonymized at the customer's request. The market, technologies, and solution are presented as delivered.
The problem
After the TMS integration work, the carrier brought us back for a different problem: operational data that existed everywhere and answered nothing.
The carrier runs on more than a dozen systems. Orders and dispatch live in Gravitate. Telematics and driver logs live in Samsara. Tolls live in Bestpass. BOLs and rack data come from DTN. Trucking operations run through TMW. Each one answers its own questions, and none of them answer the questions that run a fuel business: Which sites keep running dry, and why? Is toll spend inside policy? Did we hit the delivery windows we promised? Where are driver hours going?
Those answers lived in exports and hand-stitched spreadsheets, assembled after the fact and stale before they reached a decision.
What we built
A consolidated data platform. Six systems feed it today (DTN, Gravitate, Samsara, Bestpass, TMW, and Google mapping data): raw data lands in an S3-based lake, catalogued with Glue and queried through Athena, dbt models apply one set of business logic across sources, and Metabase serves the dashboards the carrier runs on. Every view drills down to the underlying records, so questions get answered without an analyst in the middle.
Four examples of what the platform answers daily:
Tank outages
Outage counts, outage trends, and average stick distributions across 5,000+ sites, with views by market sector, store, owner, and product. The team sees which sites run dry, how often, and which way the trend is moving, instead of finding out one phone call at a time.
Toll spend
Every toll transaction from Bestpass, joined to routes from Samsara and Google mapping data and orders from Gravitate, then scored against company toll policy. Utilization trends, spend by action, spend by cost center. Non-compliant spend stops hiding in monthly statements, and the dashboard reclaims $200K+ a year.
Delivery-window accuracy
GPS geofencing marks the moment a truck crosses a site boundary, and every delivery scores against the window the customer was promised. Breakdowns by day, by customer, by store. Service quality stops being an impression and becomes a number teams can move.
Driver accountability
When drivers log in, how much of their clock goes to deliveries, and who is running past safe hours. Leaderboards turn the numbers into healthy competition, and a reward system turns the competition into performance, productivity, and culture.
These four are a sample, not the catalog. The platform keeps growing as new questions earn a dashboard.
Results
The questions that used to take an analyst and a week of exports now have standing answers. Toll compliance alone reclaims $200K+ a year. Outage patterns surface in trend views instead of after-the-fact phone calls. Delivery accuracy is measured against the same geofences for every customer. And drivers compete on numbers everyone can see.
The toll dashboard pays for the platform every year. The rest compounds: six systems, one set of answers, and operating decisions made in the room instead of in next month’s spreadsheet.