Seven trucking and logistics companies, $250M+ combined revenue: one data platform for lane-level profitability

Situation

A roll-up of seven trucking and logistics companies with $250M+ in combined revenue had no consolidated view of the business. Each company ran its own TMS, ERP, and accounting system, so basic questions (which lanes make money, which sites lose it) took manual spreadsheet work, every time. The group engaged Cameo Consulting to put the whole business on one data platform.

Approach

• Mapped every TMS, ERP, and accounting package across the seven companies, and the data each one held.
• Built a unified data warehouse that pulls from every source system into one consistent model of loads, lanes, costs, and revenue.
• Standardized definitions across the group so a lane, a load, and a margin mean the same thing at every company.
• Delivered a single BI platform on top of the warehouse, with views for group leadership and for each operating company.
• Structured the reporting around the questions owners actually ask: where profit comes from, where it leaks, and what changed this month.

Results

1. Seven companies now report through one BI platform instead of seven disconnected system stacks.
2. Cost and profitability are visible at the lane and site level across the full $250M+ group, for the first time.
3. Leadership compares performance across companies on consistent definitions, so portfolio reviews start with decisions instead of data gathering.

Why does this matter for a roll-up?

A roll-up inherits as many system stacks as it has acquisitions, and value creation plans stall when nobody can see margin below the P&L line. One warehouse turns seven sets of books into one operating picture, and every future acquisition has a platform to land on.