Ga naar de hoofdinhoud

Build a Completeness Check From a Business Rule

Create a completeness check that defines scope, denominator, required field, tolerance, and exception handling.

data-quality-management5 min read

Customer tier is missing in the customer table, but the team has not defined which customers require it or when. DMAIC for completeness: Define population -> Measure denominator -> Analyze exceptions -> Improve capture -> Control drift Counting nulls across the whole table treats prospects, inactive customers, and newly-created accounts as equal defects. Define Required field: customer_tier. Required population: active enterprise customers with signed contracts. Required timing: within one business day of activation. Definition prevents false defects. A prospect without tier may be acceptable; an active enterprise customer without tier is not. Measure Completeness = active enterprise customers with customer_tier…

Read the full lesson

Sign up free: one personalized lesson every day, matched to your role and goals.

← Back to library

Neem contact op