SAMPLE: Drummond Company × BI Consulting Services

Business unit / site

Period

Production vs shipments — monthly tons

Raw tons producedClean tons shippedPlan

What this board answers

from the same dataset

Cost per clean ton by operation

lower is better · vs unit plan

Mine-to-market flow — where the tons go

period totals · kt = thousand tons

Ask the data

mock · private model on your own server

Ask about production, cost, safety or shipments…↵

Growth recommendations we'd start with

from the Oct 2024 conversation

1One certified dataset per business unit on Report Server, refreshed from SQL Server on a schedule — every report on this page reads from it, so numbers agree across mine, plant and finance.
2Row-level security by site so a mine manager opens the same .pbix and sees only their operation; the unit VP sees "All".
3Subscriptions instead of spreadsheets — Report Server e-mails the shift/daily PDF at 06:00; nobody re-keys the production log.
4A private "ask the data" layer (below) that runs beside Report Server on your own hardware — nothing leaves the network, no per-seat cloud licence.

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

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
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
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
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
Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.