Search
Every page on the site, 63 in all. Type to narrow the list; it searches titles, formulas, headings and text.
-
KPI · Labor
Absenteeism Rate Absenteeism rate definition and formula, why unplanned absences differ from PTO, realistic benchmarks by industry, and the Power BI DAX to track it by shift.
-
KPI · Production
Capacity Utilization Capacity utilization definition and formula, why running near 100% is a risk rather than a win, realistic benchmarks, and the Power BI DAX to calculate it.
-
KPI · Production
Cycle Time Cycle time definition and formula, realistic benchmarks against engineered ideal time, the gaming trap to watch for, and the Power BI DAX to track it.
-
KPI · Inventory
Inventory Days on Hand Days on hand definition and formula, realistic benchmarks by inventory type, why chasing it too hard causes stockouts, and the Power BI DAX to calculate it.
-
KPI · Quality
First Pass Yield (FPY) First pass yield (FPY) definition and formula, why it differs from rolled throughput yield, realistic benchmarks, and the Power BI DAX to calculate both.
-
KPI · Financial
4-Wall Margin 4-wall margin definition and formula, why there's no external benchmark, the corporate-allocation fight to watch for, and the Power BI DAX to build it.
-
KPI · Production
Changeover Time (SMED) Changeover time definition and formula, realistic SMED benchmarks, the ramp-up trap that hides scrap, and the Power BI DAX to track it by line and part.
-
KPI · Labor
Labor Productivity Labor productivity definition and formula, why raw units per hour misleads across product mixes, the standard-hours fix, and the Power BI DAX to build it.
-
KPI · Inventory
Inventory Turns Inventory turns definition and formula, why average inventory beats a snapshot, realistic benchmarks by category, and the Power BI DAX to calculate turns.
-
KPI · Production
MTBF (Mean Time Between Failures) MTBF definition and formula, realistic benchmarks by asset type, why failure-definition drift inflates the number, and the Power BI DAX to calculate it.
-
KPI · Production
MTTR (Mean Time to Repair) MTTR definition and formula, realistic benchmarks, the clock-stopping trap that hides real downtime, and the Power BI DAX to build it from maintenance events.
-
KPI · Production
OEE (Overall Equipment Effectiveness) What OEE means, how to calculate Availability × Performance × Quality, realistic benchmarks by industry, and the DAX to build OEE in Power BI.
-
KPI · Delivery
On-Time Delivery (OTD) OTD definition and formula, why delivery date beats ship date, realistic benchmarks by industry, and the Power BI DAX to track on-time delivery weekly.
-
KPI · Labor
Overtime Percentage Overtime percentage definition and formula, realistic benchmarks, why plant-wide averages hide the real problem, and the Power BI DAX to track it by line.
-
KPI · Delivery
Past-Due Backlog Past-due backlog definition and formula, why there's no external benchmark, the date-creep trap that hides it, and the Power BI DAX to track it by order.
-
KPI · Delivery
OTIF (On Time in Full) OTIF definition and formula, how it differs from OTD and fill rate, realistic benchmarks and gaming risks, plus the Power BI DAX to measure it per order.
-
KPI · Quality
Defect PPM (Parts per Million) Defect PPM definition and formula, realistic benchmarks from automotive to general manufacturing, the undercounting trap, and the Power BI DAX to build it.
-
KPI · Quality
Scrap Rate Scrap rate definition and formula, realistic benchmarks by process maturity, the rework-reclassification trap, and the Power BI DAX to track units and cost.
-
KPI · Production
Schedule Attainment Schedule attainment definition and formula, why 85% is the common target, how it differs from OEE and utilization, plus the Power BI DAX to measure it weekly.
-
KPI · Production
Takt Time Takt time definition and formula, why it isn't a performance metric like cycle time, how to compare it to actual pace, and the Power BI DAX to calculate it.
-
KPI · Safety
TRIR (Total Recordable Incident Rate) TRIR definition and formula, why the 200,000-hour constant exists, honest benchmarks by industry, and the Power BI DAX to track it on a trailing basis.
-
KPI · Production
Unplanned Downtime % Unplanned downtime definition and formula, how it differs from OEE availability, realistic benchmarks, and the Power BI DAX to track it by reason code.
-
Field Note
Your Agent Transcripts May Be Deleted After 30 Days The default cleanup setting removed my personal agent history. What I changed, and the append-only backup and monthly restore drill I put behind it.
-
Error guide
Direct Lake Relationship Skipped Because the Key Column Is Double A fact table key landed in Delta as Double, so the relationship was skipped. How I changed the column type from TMDL view and got the relationship active.
-
Error guide
Fabric Git Says "Can't fetch branches": Check the Tenant Setting Connecting a workspace to GitHub failed on a new tenant until an admin enabled a tenant setting that is easy to miss.
-
Error guide
Direct Lake: "relationship needs to be recalculated" Is a Refresh You Forgot After adding relationships to a Direct Lake model, queries fail until you reframe the model with a refresh.
-
Field Note
Don't Accept 'Done' from an Agent Without a Quoted Source An agent's 'done' only tells you what it believes happened. The rule I enforce: no quote and source, no done, plus read-only review passes when being wrong is expensive.
-
Error guide
PBIR Report Won't Import into Fabric: Missing definition/version.json A generated PBIR report failed to import because definition/version.json and two report.json fields were missing. What each one needs to contain.
-
Error guide
A Freshly Git-Deployed Power BI Model Won't Refresh After deploying an import model from Git into Fabric, refresh does nothing until you set the data source credential and re-enable scheduled refresh.
-
Error guide
TMDL InvalidLineType: A Doc Comment Followed by a Blank Line In a TMDL file, /// doc comments followed by a blank line produce an InvalidLineType parse error. What to look for and what to change.
-
Field Note
Guard Rails for Agents That Work Near Production A guard hook, a kill switch, a headless launcher with caps, and a serial-only refresh rule: how I keep agents from doing damage in my home lab, and why to start in shadow mode.
-
Field Note
Routing Agent Work by Model Tier, and Red-Teaming My Own Automation A task router that sends each job to the smallest model that can close it, plus a red-team unit that found a code-execution hole in my self-updating routine.
-
Error guide
Notebook saveAsTable Fails: The Default Lakehouse Isn't Attached A Fabric notebook that writes Delta tables errors if you run it before attaching a lakehouse. The set-default option only appears after you add one.
-
Error guide
TMDL View: One Command per Apply Pasting 21 separate createOrReplace commands into TMDL view does not work. Put the relationships under one command.
-
Error guide
Fabric Git Deploy Fails with 'Unable to finish metadata synchronization' A shared M function expression in a TMDL model broke deployment from Git. Inlining the M into each partition fixed it.
-
Field Note
Context Transition, Explained with Three Bugs I Wrote Three real DAX mistakes from this site, each a different side of context transition and filter arguments, with the broken version, why it broke, and the fix.
-
Field Note
How This Site Tests Its Own DAX Every DAX block here is linted on each build, every analysis number is computed from the demo CSVs, and the tests check identities, not snapshots. What that caught.
-
Field Note
Review a Power BI Release Before It Ships A short release review for a semantic model saved as a TMDL project: compare it with production, read the checks, and keep a Markdown dictionary in git so the next diff is readable.
-
Analysis
OEE Across Lines How unit-pooled OEE drifts once lines with different ideal rates roll up, and DAX in ideal-rate minutes that adds up.
-
Analysis
Downtime Pareto Unplanned minutes by reason per plant, with cumulative-share DAX that survives slicers and ties.
-
Analysis
XmR Chart Process behavior limits from a fixed baseline, read honestly, with the DAX to draw them.
-
Analysis
Inventory Snapshots Closing balance and average stock from month-end snapshots, and why LASTNONBLANK by part ships wrong numbers.
-
Analysis
On-Time Shipping Why the newest month flatters, how to count overdue open lines, and what changes between order month and ship month.
-
Analysis
TRIR with Small Numbers Exact Poisson ranges for a rate built on a handful of incidents, a test for whether a drop is real, and CHISQ.INV in DAX.
-
Analysis
ISO Weeks Why calendar year plus ISO week corrupts every week-1 total, an ISO year column, and two honest ways to compare with last year.
-
Analysis
Price-Volume-Mix A revenue bridge from the demo orders, and why measuring at the wrong grain turns customer mix into a pricing win.
-
Analysis
ABC Classification Parts ranked by usage value, the stock and days of supply each class holds, and dynamic ABC segmentation in DAX that handles ties.
-
Analysis
Top N and Others Top customers plus one Others bar that adds up, handles ties and respects slicers, and the HHI as one number for concentration.
-
Tool
Model Documenter Word and Excel data dictionary of a Power BI semantic model, with DAX and model checks. Runs in the browser.
-
Tool
DAX Lint Check DAX measures for division without DIVIDE, IFERROR, FILTER over whole tables and more.
-
Tool
Process Behavior Chart Paste a KPI series and get XmR limits, signals and a chart.
-
Tool
Rate Comparison Exact Poisson ranges for two incident rates and a test of whether the change is real.
-
Tool
Model Compare Compare two versions of a semantic model: tables, columns, measures with a DAX diff, relationships and roles.
-
Reference
Check Rules Every DAX Lint and Model Documenter rule, what it flags and why.
-
Tool
Fiscal Calendar Generator 4-4-5, 4-5-4 or 5-4-4 fiscal calendar as a DAX calculated table, with 53-week years shown.
-
Tool
KPI Calculators and DAX Generators Calculators that compare your number to a typical range, and DAX with your own table names.
-
Data
Demo Dataset A synthetic manufacturer in 13 CSV tables: profiles, bus matrix and key checks.
-
Exercise
Spot the Problem Charts that look right and are not, with the DAX that finds the problem.
-
Guide
Document the AdventureWorks Model A sample data dictionary from the Model Documenter.
-
Library
Manufacturing KPI Library Every KPI with its formula, typical range, DAX, calculator and generator.
-
Library
Field Notes Notes and error guides on running Power BI and Fabric.
-
Page
Home Free Power BI resources for manufacturing.
-
Page
About Who runs this site and why.