Qosina × BI Consulting Services — Sales Order Intelligence Board

Sales Order Intelligence Board for a 5,000-component catalogue

One Power BI model over sales-order lines from Ronkonkoma and Cusano Milanino: orders and revenue by product family, line-item fill rate, sample-to-order conversion, top OEM accounts and backorder ageing — refreshed from the ERP, not from spreadsheets.

Prepared for DJEVP & CITDO, Qosina

September 2026Concept demonstration

Data scope24 months · 3 regions · 6 families · 24 sub-families

Trend · 24 months

Order revenue by month, with line-item fill rate

Fig. 1

Revenue, selected periodRevenue, outside periodFill rate (lines shipped complete)

What this board answers

Three questions the sales team asked

Signature view · Component catalogue grid

24 sub-families sized by order lines, shaded by fill rate

Fig. 2

Fill rateTile area = order lines · dashed outline = below 95% target

Ranking · Accounts

Top 8 OEM customers by revenue

Fig. 3

USEURest of world

Availability · Backorder ageing

Open backorder lines by age band

Fig. 4

Conversion · Free samples

Sample request → quote → first order

Fig. 5

Ask the data · AI layer

Natural-language question over the same model

DJ · 09:14 · scope: All regions · All families · Last 12 months

Ask a follow-up, e.g. “which EU accounts are waiting on silicone tubing?”Ask

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.