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

Excargo Services × BI Consulting Services

TMS Drayage Operations Board — Port Houston terminals → Genoa Red Bluff yard → customer
Prepared for Ronnie
September 2026 · Interactive demo

Every number here is recalculated live from the TMS-shaped data behind the page when you change period, terminal or freight segment. It answers the question from your original note — "a lot of data in the TMS, but the reporting is lacking" — with a single board: containers moved, on-time performance, terminal turn time, revenue per load, driver utilisation, and detention & demurrage exposure by customer.

Signature view · Houston dray network

Port-to-yard-to-customer lane map

Lane width = loads in the selected window. Left legs run terminal → Excargo's 35-acre yard on Genoa Red Bluff Rd; right legs run yard → customer cluster. Hover any lane.

Selected terminal / laneOther lanesRail rampsExcargo yard
Terminal turn time

Container turn at the gate, by terminal

Average minutes from arrival in the queue to gate-out, split into the three legs the TMS timestamps. Dashed line = 90-minute target turn.

Queue to gate-inGate-in to liftLift to gate-out
Trend · trailing 12 months

Loads moved and on-time delivery, by month

Bars = loads (containers moved). Line = on-time delivery %. Shaded band = the period you have selected.

LoadsLoads in selected periodOn-time delivery %
What this board answers

Three questions, three numbers

Ranking · customers

Top customers by loads, with revenue per load

Red bars flag customers whose detention & demurrage exposure exceeds 6% of their revenue in the window.

Exposure · detention & demurrage

Detention (chassis / driver wait) vs demurrage (container at terminal)

Dollars accrued in the window and how much was recovered from customers. The gap is margin leaking out of the yard.

Detention accruedDemurrage accruedRecovered from customer
Fleet · driver utilisation

Turns per driver-day and idle hours

Distribution of the ~85-driver fleet by turns per working day in the window. Target is 2.5 turns; drivers below 1.5 are mostly waiting on chassis or gate queues.

AI layer · ask the data

Ask the board a question in plain English

Illustration of the natural-language layer that sits on top of the TMS model. The answer below is generated from the same numbers as the panels above and changes with your filters.

Which customers drove detention charges last month, and how much did we recover?
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