PlantOps BI

Tools

Calculators run in your browser and compare your result to the typical range stated on the KPI page. All 22 KPI pages have a calculator and a DAX generator where you enter your own table and column names.

Browser tool

Model Documenter

Document a Power BI semantic model in Word and Excel.

Open the Model Documenter

Browser tool

Model Compare

Two versions of a model, every added, removed and changed table, measure, relationship and role, with a DAX line diff.

Compare Two Models

Browser tool

DAX Lint

Paste measures and check them for division without DIVIDE, IFERROR, FILTER over whole tables and more.

Open DAX Lint

Browser tool

Process Behavior Chart

Paste a KPI series and get XmR limits from a baseline you choose, with every signal marked.

Open the Chart Tool

Browser tool

Rate Comparison

Is this year's TRIR really better? Exact ranges for two incident rates and a test of the change.

Compare Two Rates

Browser tool

Fiscal Calendar Generator

A 4-4-5, 4-5-4 or 5-4-4 calendar as a DAX calculated table, with every 53-week year shown before you paste it.

Build a Fiscal Calendar

KPI Calculators and DAX Generators

Production 9

KPIFormulaOpen
Capacity Utilization Actual output ÷ maximum practical capacity Calculator DAX
Changeover Time (SMED) Time from last good unit of the previous run to first good unit of the next run Calculator DAX
Cycle Time Run time ÷ units produced Calculator DAX
MTBF (Mean Time Between Failures) Total operating time ÷ number of failures Calculator DAX
MTTR (Mean Time to Repair) Total repair time ÷ number of repairs Calculator DAX
OEE (Overall Equipment Effectiveness) Availability × Performance × Quality Calculator DAX
Schedule Attainment Units produced ÷ units scheduled (per line, per week) Calculator DAX
Takt Time Available production time ÷ customer demand Calculator DAX
Unplanned Downtime % Unplanned downtime minutes ÷ total planned production minutes Calculator DAX

Quality 3

KPIFormulaOpen
Defect PPM (Parts per Million) (Defective units ÷ total units produced) × 1,000,000 Calculator DAX
First Pass Yield (FPY) Units passing a process step correctly on the first attempt ÷ total units started Calculator DAX
Scrap Rate Scrap units (or scrap cost) ÷ total units produced (or total cost) Calculator DAX

Delivery 3

KPIFormulaOpen
On-Time Delivery (OTD) Orders delivered on or before the promised date ÷ orders due Calculator DAX
OTIF (On Time in Full) Orders delivered on time AND at full ordered quantity ÷ orders due Calculator DAX
Past-Due Backlog Count (or $ value) of open orders past their promised date Calculator DAX

Safety 1

KPIFormulaOpen
TRIR (Total Recordable Incident Rate) Recordable incidents × 200,000 ÷ total hours worked Calculator DAX

Inventory 2

KPIFormulaOpen
Inventory Days on Hand (Average inventory value ÷ COGS) × 365 Calculator DAX
Inventory Turns Cost of goods sold ÷ average inventory value Calculator DAX

Financial 1

KPIFormulaOpen
4-Wall Margin (Plant revenue - plant-controllable costs) ÷ plant revenue Calculator DAX

Labor 3

KPIFormulaOpen
Absenteeism Rate Unplanned absence hours ÷ total scheduled hours Calculator DAX
Labor Productivity Units produced ÷ total labor hours Calculator DAX
Overtime Percentage Overtime hours ÷ total hours worked Calculator DAX