Demonstration · Illustrative data · BI Consulting Services
Ceres Global × BI Consulting Services
Prepared for Nathan
Director, Information Technology
September 2026

Grain merchandising & operations board — 13 facilities, 45 million bushels, one warehouse

An executive view built on top of a modelled Ceres data warehouse: bushels handled, storage utilisation by facility, margin by commodity, rail and truck logistics across the Northern Plains and Prairies — plus a live health panel for the warehouse itself. Every panel below recalculates when you change the filters.

Period
Region
Commodity

Bushels handled by month — receipts vs shipments

Trailing 24 months · million bushels
Receipts (in)Shipments (out)Storage utilisation %Selected period

What this board answers

Three questions from the June 2024 discovery call, answered with numbers from the board.

Facility network — elevators & terminals

Circle = licensed capacity · fill = utilisation
Owned facilityJoint-venture assetRail corridor to port / millUtilisation 40% → 95%

Storage utilisation by facility

Avg. of month-end stock ÷ capacity

Red tick = 90% operating ceiling. Sorted high → low.

Margin by commodity

Gross margin, US$ million · bar length = margin, label = ¢/bu

Share of bushels shipped

Top facility by margin

Rail vs truck shipments

Million bushels / month
Rail (BNSF · CPKC · CN)Truck

Data warehouse health

Live

Sources integrated, refresh status and row volume for the selected slice.

SourceRefreshStatusRows

Ask the data

AI layer · natural-language query over the warehouse

A typed question, answered from the same model that drives the board. Shown here as a static example of the AI layer.

Enter ↵

Demonstration · Illustrative data · BI Consulting Services
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