Transportation & logistics · Data engineering & BI

Decision analytics for operators that outgrew spreadsheets.

DTM connects your TMS, Excel, and accounting to dashboards and pipelines you can trust — without replacing the systems that run your operation.

Book a 20-minute discovery call See our services

Scattered data

Operations in one system. Finance in another. Truth in Excel.

Manual reporting

Hours every week on copy/paste — and numbers are stale before leadership sees them.

BI that didn't stick

Pretty charts, no tie-out, nobody trusts the dashboard.

Built for freight operators, not enterprise IT departments

We work with mid-size teams that have real volume, spreadsheet-heavy workflows, and no dedicated data analyst — but leaders who need accurate numbers to run the business.

Freight forwarders, brokers & relocation operators

Typically 5–50 employees, TMS- and Excel-heavy, with margin visibility gaps. We deliver Margin Map: shipment, customer, and lane profitability across TMS exports, vendor cost spreadsheets, and QuickBooks — so you know what to grow, reprice, or exit.

What we deliver

  • Reporting automation Scheduled exports or API pulls → modeled metrics → your BI tool or Excel.
  • BI platform approach Tool-agnostic: Power BI, Domo, QuickSight, Tableau, or Excel — no forced migration.
  • Validation & tie-out Documented variance rules and parallel runs. We don't call it done until finance and ops agree.
  • Operational dashboards Exceptions, profitability, pace — late shipments, unbilled costs, margin at risk.
  • Data Bridge (scale-up) SQL, Python, and Snowflake when exports aren't enough — ETL, history, multi-office models.
  • Managed analytics Fractional team: refresh monitoring, ad-hoc analysis, quarterly business review support.

Start with a fixed-scope pilot — Margin Map

Shipment and customer profitability visibility without replacing your TMS.

Typical timeline

4–6 weeks

Starting investment

$8,000 – $15,000

Discovery (optional)

$500 – $2,000

Discovery is often credited toward pilot scope. Ongoing retainers from $1,500/month.

Request a scoped proposal

Export-first. Prove it. Then scale.

  1. Discovery — Walk your workflow. Inventory data sources. Agree on three questions the pilot must answer.
  2. Field mapping — Document every metric: source column → model → dashboard.
  3. Pilot — Read-only, fixed scope, 4–6 weeks. Deliverable in your chosen BI platform.
  4. Validation — Side-by-side tie-out vs. your manual process or finance records.
  5. Retainer or Foundation — Ongoing refresh, new metrics, or warehouse + ETL when you're ready.

No platform replacement required to start · NDA before client data · Fixed fees, defined deliverables

Domain knowledge plus production data engineering

Most BI consultants don't know a TEU from a house bill. Most ops people stop at Excel. DTM sits in the middle: 14+ years in transportation — international forwarding, ocean pricing, shipper logistics — and production experience building BI and Snowflake pipelines on enterprise freight data platforms.

  • Tool-agnostic BI — Power BI, Domo, QuickSight, Tableau, or Excel
  • Export-first — lowest friction, fastest proof
  • Tie-out discipline — validated before handoff
  • Productized pilots — repeatable, not open-ended
  • Right-sized for SMB — enterprise methods without enterprise overhead

Founded by BJ Oyejobi · DTM Analytics Group LLC · Denver, CO

Let's talk about the report you rebuild every week.

20-minute discovery call. No pitch deck. We'll walk your workflow and tell you honestly if a fixed-scope pilot fits.

Or email directly: info@dtmanalyticsgroup.com