Home / DMAIC / Measure

Measure · Tool guide 13 of 40

Test the Quality of Available Data

Data quality assessment checks whether existing records are suitable for a particular measurement purpose. It examines meaning, completeness, validity, consistency, duplicates, time coverage and traceability. A technically clean file can still contain misleading process records.

Expected output: A data-quality report and reproducible cleaning record supporting the baseline.

01 · Purpose

Why and when to use it

Use it before building a baseline from historical extracts or combining sources.

Who takes part?

The measurement owner works with people who understand the process and the recorded data. Statistical or measurement-system decisions should involve someone able to check the assumptions and study design.

02 · Application

How to apply it

Start with an agreed measurement purpose, explicit units and trustworthy observations. Identify missing cases and assumptions before calculating.

  1. Confirm field definitions against the actual process.
  2. Check required fields, duplicate keys and impossible values.
  3. Inspect timestamp sequence, units and code consistency.
  4. Compare selected records with independent evidence and check coverage across relevant groups.
  5. Document corrections and exclusions; retain raw records and unresolved cases.

03 · Example

A worked measurement example

Original fictional teaching example. Small datasets illustrate the method; they are not proposed as sufficient study sizes. Supplied parameters are assumptions, not estimates from a real process.

Quality checkIllustrative findingAction
Completeness20 of 1,000 handover timestamps missingReport 2% missing; investigate by shift
UniquenessFive duplicate order rowsResolve whether duplicates are split shipments or repeated records
ValidityThree handovers precede order releaseCheck time zones and event mapping

04 · Interpretation

What the result tells you

The checks identify reasons a late-dispatch calculation may be biased. Do not simply delete the troublesome records and report the remaining rate as complete-population performance.

Completion check: A data-quality report and reproducible cleaning record supporting the baseline.

05 · Judgement

Mistakes and limitations

Automated checks find structural problems but cannot establish that recorded events happened as described. Missingness related to delays can bias the estimate even at a small percentage.

07 · Reading

Sources and further reading

The tool list follows the accepted LeanTrainingLab overview and its reference to Six Sigma+Lean Toolset, second edition (Lunau, editor; Springer, 2013). The book chapters were not available for direct review during this build. Explanations, examples and worksheets are original teaching material. Further reading supplies professional background; local conventions are stated explicitly.