SAMPLE AND DEMONSTRATION ONLY. Illustrative analysis of publicly available information, prepared by BI Consulting Services. Not affiliated with, endorsed by or produced for any company shown.
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" panel above is built to run on a GPU server inside your own network: an open-weight model over your own documents, with every answer citing the file it came from. No per-seat licence, works offline, and nothing leaves the building.

How it sits in your environment

YOUR NETWORK · NOTHING LEAVES THE BUILDING Your files policies · SOPs · contracts reports · ERP exports indexed locally GPU One server, in your building open-weight model · your data only in seconds Cited answers every reply links to the source file and page no cloud AI · no third-party processor
One appliance-class server on your rack or in a secured closet. Your files are indexed where they already live; the model runs locally; answers come back with the source page attached.

What that means in practice

  1. 1
    Your data only, on your hardwareAn open model over your own documents and exports. No third-party AI processor, no data-transfer agreement to review.
  2. 2
    Every answer cites its sourceReplies point to the file and page they were drawn from, so people check the answer instead of trusting it blind.
  3. 3
    No per-seat licenceThe whole team can ask questions. Cost is the server and our build, not a monthly number that grows with headcount.
  4. 4
    Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.

The short deck

14 slides on how a private AI server is scoped, secured and rolled out. Click through, or take the PDF.

Download the PDF
Private AI on your own server — slide 1 of 14 Private AI on your own server — slide 2 of 14 Private AI on your own server — slide 3 of 14 Private AI on your own server — slide 4 of 14 Private AI on your own server — slide 5 of 14 Private AI on your own server — slide 6 of 14 Private AI on your own server — slide 7 of 14 Private AI on your own server — slide 8 of 14 Private AI on your own server — slide 9 of 14 Private AI on your own server — slide 10 of 14 Private AI on your own server — slide 11 of 14 Private AI on your own server — slide 12 of 14 Private AI on your own server — slide 13 of 14 Private AI on your own server — slide 14 of 14
1 / 14Tap or click a slide to advance · arrow keys work too

Worth a conversation? Book 30 minutes with NicholeBI Consulting Services · powerbiconsultingservices.com