Data quality rules
On This Lesson 4 topics
This lesson is planned. The outline below lists the topics it will cover. The full lesson has not been published yet.
In this lesson
specify data quality rules and how they are measured and reported.
Planned topics
- Common dimensions: completeness, validity, uniqueness, consistency, timeliness.
- A rule is specific and testable: "every order has a store or web channel code".
- Each rule has a measure, a threshold, an owner, and a place where results are reported.
- Check rules where data enters, not only in the report; unmeasured rules do not exist.
Draft outline details
Demonstration
a rule sheet: rule, dimension, measure (percentage of failing rows), threshold, owner, report location, action on breach.
Check your understanding
What makes a quality rule real?
Show answer
It is measured, has a threshold, has an owner, and is reported.
Practice
Apply this lesson with the module's lab, exercises and quiz.
Marking a lesson complete is optional and you can undo it any time. Your progress stays in this browser.