Trend · lead time vs published target
Weeks of open orders on the books, by month
Backlog ÷ shipping rate, in weeks. Dashed line is the published target for the selected mix (3 wks fifth wheels · 5–6 wks landing gear).
Breakdown · backlog vs target by line & plant
Where the lead-time promise is at risk
Bar = current weeks of backlog. Tick = published target. Colour = status.
Signature · plant-to-OEM supply map
Shipments from two plants to OEM truck & trailer plants in three countries
Arc width = units shipped in the period. Hover a destination or a plant.
Grand Haven, MIGreeneville, TNOEM plant
Customer mix
Units by customer segment
Truck OEMs, trailer OEMs, dealers & aftermarket, vocational (HYVA).
Quality · scrap & rework
Scrap and rework as % of units produced
Stacked by month. Plant target: ≤ 2.5% combined.
ScrapReworkTarget 2.5%
What this board answers
Three questions, three numbers
Ask the data · mock
Plain-English questions, answered from the same model
Illustration of a private AI layer over the star schema. Pick a question — the answer recalculates with your filters.
Why this page loads in seconds when the source SQL is slow
Import star schema with incremental refresh — not DirectQuery
The pilot ran DirectQuery against the production SQL Server, so every click waited on the database. Here the heavy work happens once per refresh, off-hours; the report answers from an in-memory model.
- 01Star schema. One fact table (order lines: ordered, shipped, on-time, scrap, rework) and five dimensions — Date, Plant, Product line, Customer, Destination — instead of wide ad-hoc views.
- 02Incremental refresh. Only the last 3 days of order lines are re-read each night; 24 months of history stay as compressed partitions. Refresh runs in minutes, not hours.
- 03Manual data in the same model. Scrap tallies and OEM forecasts from Excel land in a staging table with the same keys, so they join to the fact table like any other source.
- 04Measured, not assumed. The timer in the header is this page recalculating — data cells across every panel after your last click.
