Production-Grade Power BI for Manufacturing Operations
Free resources for people who build Power BI for plants: what each KPI means, how to calculate it, and the DAX to start from.
62.5%
- Availability
- 87.5%
- Performance
- 75.0%
- Quality
- 95.2%
OEE % = [Availability %] * [Performance %] * [Quality %] Drag a bar to see what it does to OEE. Run it with your own numbers
What Do You Need?
- What a KPI means, or its formulaKPI Library
- To check a number by handCalculators
- DAX with my own table namesDAX generators
- Help with an error messageError guides
- A data dictionary for my modelModel Documenter
- To sharpen my eye for bad numbersSpot the Problem
- A second look at my DAXDAX Lint
- Data to practice onDemo dataset
- To tell a signal from noiseXmR chart
Free tool
Model Documenter
Drop a Power BI project folder and get a Word and Excel data dictionary. It runs in your browser, so your model never gets uploaded anywhere.
Tools for Power BI Developers
13 rules that read DAX as tokens, plus a formatter that proves it changed only whitespace.
Model CompareTwo versions of a TMDL model: every changed measure, partition, parameter and role, with a line diff.
Fiscal Calendar GeneratorA 4-4-5, 4-5-4 or 5-4-4 calendar as a DAX table, with every 53-week year shown first.
Check RulesWhat each DAX and model check flags, and why it matters.
Live Analysis on the Demo Data
How unit-pooled OEE drifts once lines with different ideal rates roll up, and DAX in ideal-rate minutes that adds up.
Downtime ParetoUnplanned minutes by reason per plant, with cumulative-share DAX that survives slicers and ties.
XmR ChartProcess behavior limits from a fixed baseline, read honestly, with the DAX to draw them.
Inventory SnapshotsClosing balance and average stock from month-end snapshots, and why LASTNONBLANK by part ships wrong numbers.
On-Time ShippingWhy the newest month flatters, how to count overdue open lines, and what changes between order month and ship month.
TRIR with Small NumbersExact Poisson ranges for a rate built on a handful of incidents, a test for whether a drop is real, and CHISQ.INV in DAX.
ISO WeeksWhy calendar year plus ISO week corrupts every week-1 total, an ISO year column, and two honest ways to compare with last year.
Price-Volume-MixA revenue bridge from the demo orders, and why measuring at the wrong grain turns customer mix into a pricing win.
ABC ClassificationParts ranked by usage value, the stock and days of supply each class holds, and dynamic ABC segmentation in DAX that handles ties.
Top N and OthersTop customers plus one Others bar that adds up, handles ties and respects slicers, and the HHI as one number for concentration.