L2 · Required

Data quality rules

Use data quality rules to make decisions inspectable.

What you should be able to do

Independently: Specify null, uniqueness, range and total checks.

Suggested prerequisites

A short guide

Use data quality rules to make decisions inspectable. Specify null, uniqueness, range and total checks. Read the indicated source section, identify its key concepts and conditions, and work through the example. Record inputs, sources, units and assumptions. Keep your method separate from the result, mark unanswered questions, and review the output against the checklist.

An example

Duplicate order IDs may require rejection or deduplication.

Your task

Specify null, uniqueness, range and total checks.

Start with this source

Read the indicated section relevant to data quality rules and complete the applied task.

This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.

Your learning checklist

Required items: 0 / 10 completed or already known

Device storage

Next: Read a role through its responsibilities

Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.

Self-check

Try a practice set

Calculations and choices receive immediate checks. Review open responses yourself against the rubric. All examples are educational.

1. 500 input rows with 10 explicitly rejected. Successful output?
2. How can a batch retry avoid duplication?
3. After the logs and lineage task, state one assumption, one supporting fact and one condition that would change your conclusion.