Master Data Defect Rate, DPMO and Sigma Level Calculator
Quality teams know DPMO and sigma levels from the shop floor. The same maths works for master data: treat every rule check on a record as an opportunity and every failure as a defect. This calculator turns your profiling counts into a defect rate, DPMO, sigma level and rework cost.
Your numbers
Number of active master records you ran the checks against.
Number of distinct rules tested on each record, such as completeness, validity and consistency tests.
Total number of rule failures across all records.
Distinct records that failed one or more checks.
Steward time plus downstream rework, per record.
Your results
Sigma is computed with the conventional 1.5 sigma shift used in Six Sigma tables and assumes defects are independent. Treat it as a comparison index across master data domains and months, not as a precise process capability figure.
DPMO as failed checks rise
Sweeps Failed checks found from 0 to 1500, holding your other inputs fixed.
Get a monthly master data sigma report
Optional: we can compute these figures from your live ERP and send them to data owners automatically.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Run your data quality checks across a set of active records. Enter the number of records tested, the number of rule checks applied to each record, the total number of failed checks and the number of distinct records with at least one failure. Add an average cost to fix one record if you want a rework estimate. The calculator reports defects per million opportunities, a sigma level and the share of records that passed everything. The chart shows how DPMO climbs as failures increase, so you can see the impact of cleanup targets.
The formulas
Opportunities equal records tested times checks per record. Defect rate equals defects divided by opportunities. DPMO equals that rate times one million. Sigma level uses the standard normal inverse of the yield, one minus the defect rate, plus the conventional 1.5 shift. Record accuracy is different from defect rate: it counts a record as bad if any check fails, so it is always lower than check-level yield.
- Opportunities = records x checks per record
- DPMO = defects / opportunities x 1,000,000
- Sigma = NORMSINV(1 - defect rate) + 1.5
- Record accuracy = clean records / records tested
Worked example
With 5,000 records and 8 checks each there are 40,000 opportunities. If 360 checks fail, the defect rate is 0.9 percent, DPMO is 9,000 and the sigma level is about 3.9. If 290 distinct records have a failure, record accuracy is 94.2 percent. Fixing 290 records at 12 dollars each costs about 3,480 dollars, which is the cleanup budget for that snapshot. A good use is comparing vendor, customer and item masters on the same scale, then focusing effort on the lowest sigma.
Common mistakes
Do not change the number of checks between months and compare sigma, because adding easy checks inflates sigma. Do not count one root cause several times: if a bad unit of measure fails three rules, decide whether that is one defect or three and apply the choice consistently. Do not use sigma to compare master data to a manufacturing process in absolute terms. Finally, always report record accuracy next to sigma, since business users understand it more easily.
Frequently Asked Questions
What is a good sigma level for master data?
There is no universal target. Many teams treat 4 sigma, about 6,200 DPMO, as a reasonable first goal for transaction-critical rules and aim higher for fields that block orders or payments. Compare against your own trend.
What counts as an opportunity?
An opportunity is one rule check applied to one record. If you test eight rules on every record, each record offers eight opportunities. Keep the rule set fixed when you compare periods.
Why is record accuracy lower than the yield?
Yield counts failed checks across all opportunities. Record accuracy counts a whole record as bad if any one check fails. A few failures spread across many records lowers record accuracy much more than yield.
What does the 1.5 shift mean?
It is a Six Sigma convention that long-term performance drifts about 1.5 sigma from short-term performance, so published tables add 1.5. It is a convention rather than a measured value, which is why sigma is best used for comparison.
If you would like these defect counts produced automatically from your ERP each month, we can build the checks and the scorecard on your own infrastructure.
Related Tools
Master Data Quality Dimensions and Metrics Reference
Searchable list of data quality dimensions, each with a definition, an ERP example rule and a measurable formula.
Developer ToolsERP Master Data Completeness Profiling SQL Generator
Enter a table and up to four columns to get SQL that reports null, blank and placeholder rates for each field.
Developer ToolsERP Duplicate Master Record Finder SQL Generator
Fill in your master table and match columns to get a ready-to-run SQL query that groups likely duplicates for review.
ERP OperationsMaster Data Management Maturity Self-Assessment
Ten questions that place your master data practice on a maturity scale and suggest the next steps.
More Quality & Inspection tools
See all- SAP QM Process Capability Cp Cpk Calculator
- SAP QM Lot Rejection Rate, PPM and Sigma Level Calculator
- SAP QM Gauge R&R Study Calculator
- SAP QM Cp and Cpk Capability Calculator
- Job Shop Material Certification Log Worksheet
- Job Shop First Piece Inspection Sign-Off Template
- Job Shop Scrap and Rework Cost Calculator
- Master Data Audit Sample Size Calculator
- Data Quality Sigma Level Calculator