Demonstration · Illustrative data · BI Consulting Services
D&S Car Wash Supply × BI Consulting Services
Sales & Distribution board on top of the ERP

Every dollar, bay by bay — from the High Ridge warehouse to the wash tunnel.

Revenue, margin and fill rate by product family, distributor territory and account — the ERP reporting integration you asked about in 2024, shown as a working Power BI-style board. Chemicals, IQ systems, parts, service and WashCard, one screen.
Prepared for MikeVP Sales & Marketing
SEPTEMBER 2026 · v1 DEMO

Revenue & gross margin — trailing 24 months

Trend
Monthly revenueOutside selected periodGross margin %

What this board answers

Three questions a sales VP asks the ERP every Monday
Answers

The revenue tunnel — where the dollars flow, stage by stage

Each arch is a product family; arch width = share of revenue in the selected scope, tint = gross margin. A customer drives in with a chemical order and leaves through WashCard.
Signature · product mix

Distributor territories — revenue & margin

Five sales territories served from High Ridge, MO and the Manila, AR plant
Ranking

Inventory turns & fill rate by family

Turns = annualised COGS ÷ average on-hand · fill rate = lines shipped complete from stock
Operations

Top accounts — revenue, reorders, chemical volume

Accounts

Ask the data

Natural-language layer over the same model — typed question, generated answer, chart reference
AI layer · mock
Which accounts dropped chemical volume >20% vs last year?
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