Demonstration · Illustrative data · BI Consulting Services
×BI Consulting Services

Trucking Lane & Mileage Board — Americas

Zip-to-zip lane distance, cost per mile and on-time performance across the Atlanta, Chicago, Miami and New York trucking network, with the Laredo–Monterrey cross-border corridor. One place for the questions the Trucking desk asks every Monday.

Prepared for Carrie
Department Trucking, Americas
Regional Head Office Americas Atlanta, GA
Issue September 2026
110,800
Shipments · 20251
19
Americas locations
6
Country organizations
€292.0m
Net sales · 2025
Showing trucking · all regions · last 13 weeks

Network at a glance

Every tile recalculates from the lane-level fact table when a filter changes. Deltas are vs the prior period of the same length, or vs target where marked.

1

Lane map — four US hubs and the Laredo gateway

Arc thickness = shipments in the selected period · arc colour = on-time delivery. Hover a lane for zip-to-zip detail.

≥ 95% on-time delivery 90–95% < 90% (signal) low volume  high volume
2

Zip-to-zip distance

The modification the Trucking desk asked for: pick two zips and the report returns road miles, transit days and a cost estimate from the lane matrix.

3

On-time delivery trend vs 95% target

Weekly on-time delivery %, with shipments per week beneath it.

4

Shipments by carrier

Contracted carriers ranked by volume in the selected lanes; on-time delivery shown beside each bar.

5

Lane detail — zip to zip

Sorted by shipments. Cost per mile is all-in linehaul or drayage rate including fuel.

LaneTypeMilesShipments$ / mileOT pickupOT delivery
6

Shipments by region & service

Trucking split into linehaul vs drayage. Switch Service to “All modes” to lay air & ocean alongside.

7

What this board answers

Three questions from the Trucking desk, each answered with a number from the filtered data above.

8

Ask the data

A natural-language layer over the same model. Ask in plain English, get a number and the panel it came from.

Which lane is hurting on-time delivery most, and how many shipments were late?
9
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min