Demonstration · Illustrative data · BI Consulting Services

Kanaflex Corporation × BI Consulting Services

Vernon Hills, IL manufacturing · The Original Flexible Hose™ since 1952

Prepared for Roger, Plant Manager
September 2026 · Power BI concept board

Plant Operations Board — extrusion to dock

One screen a plant team reads every morning: OEE by extrusion line, feet produced against plan, scrap, on-time shipment and inventory days by product family. Every number below recalculates from the three filters.

Production trend

Weekly output vs plan

Feet extruded per week (bars) against the production plan (line). Weeks below plan are shaded.

Actual ftBelow planPlan

Signature view · 800 Woodlands Pkwy

Plant floor — extrusion lines by OEE, live from the same filters

Each line is drawn extruder → cooling trough → take-up reel; the coloured run length is the line's OEE for the selected period. Dimmed lines are filtered out.

≥ 78% target70–78% watch< 70% belowFiltered out

Ranking

OEE by extrusion line

Availability × Performance × Quality. Target 78%. Sorted lowest first — the morning meeting starts at the top.

Inventory

Inventory days by product family

Finished-goods cover at period end vs. the 35-day target.

Demand

Open orders by customer segment

Feet on open sales orders at period end, by the market the distributor serves.

Ask the data · Copilot-style layer (mock)

Plain-English questions, answered from the model

Which line cost us the most planned feet in August, and why?

What you'd learn to build · one-on-one Power BI training

Three report pages, built with your team, on your data

PAGE 1

Production

Output vs plan by line and shift, OEE with A/P/Q breakdown, downtime reasons.

  • Connect: ERP work orders + line PLC/log sheets
  • Learn: Power Query, date table, DAX measures
PAGE 2

Quality

Scrap % by line and cause code, first-pass yield, food-grade lot traceability.

  • Connect: QC inspection log, scrap tickets
  • Learn: relationships, conditional formatting, drill-through
PAGE 3

Shipping & inventory

On-time shipment by distributor, open orders by segment, inventory days by family.

  • Connect: order book + warehouse stock snapshot
  • Learn: row-level security, scheduled refresh, mobile layout

Everything on this page was built with the same visuals your team would build — no custom code needed inside Power BI.

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