Demonstration · Illustrative data · BI Consulting Services
Pivotal×BI Consulting Services

Build-to-Delivery Board over Epicor Kinetic

A no-pressure look at what a production-grade Power BI layer could look like for a low-volume eVTOL manufacturer: WIP by station, on-time build completion, supplier on-time delivery, material shortages and in-service events per aircraft — all from the Epicor modules you already run.

Prepared for Sohare
September 2026
Palo Alto, CA · Helix & BlackFly programs

Aircraft completed per month vs build plan

Epicor Job Management · job close date vs scheduled due · selected window highlighted

Completed on timeCompleted lateBuild plan

What this board answers

Three questions a build meeting actually asks

Station flow — work in process at period end

Epicor Job Management operations by resource group · WIP units vs station capacity · bottleneck = highest load

WIP within capacityLoad ≥ 90% of capacityOver capacity (bottleneck)

Supplier on-time delivery by commodity

Epicor Purchase Management · PO lines received vs promise date · target 92%

≥ target85–92%< 85%92% target

Deliveries by state (cumulative in window)

Epicor Order Management ship-to · aircraft handed over

In-service events per aircraft, by subsystem

Epicor Field Service + Quality · events ÷ fleet in service

Ask the data

Natural-language layer over the same semantic model (Copilot-style, governed by the model's measures)

ST
Answer · grounded in board measures

Where each number comes from

Epicor Kinetic modules → one governed Power BI semantic model

Job ManagementCompletions, on-time %, WIP by station. Job header due dates vs close dates; operations by resource group feed the station flow.
Purchase ManagementSupplier OTD by commodity. PO release promise date vs receipt date (PO line level).
Inventory / MRPOpen shortages. Negative projected on-hand against released jobs, by part class.
Field Service + QualityIn-service events per aircraft. Service calls and NCRs joined to serial number → subsystem.
Order ManagementDeliveries by state / segment. Ship-to state and customer group on the sales order.
Five modules, one refresh, one set of measures — the same numbers whether the question is asked in a build meeting or typed into the panel on the left.
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