Consistency across Tables: Orphan Keys and Conflicting Values
This lesson is part of the course
In this lesson
You look up every order's customer in the master table, count the orphan orders and the revenue they carry, find orders whose region contradicts the master and compute a consistency rate.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Completeness: Blank Cells, Field Completeness & Complete Records Locked
- Validity: Format, Allowed-Value and Range Rules Locked
- Uniqueness: Duplicate Keys, Distinct Counts & Duplicate Emails Locked
- Consistency across Tables: Orphan Keys and Conflicting Values Locked
- Timeliness: Entry Lag, SLA Compliance, p90 and Freshness Locked
- Accuracy: Checking a Sample against Verified Values Locked
- The DQ Scorecard: Weighted Scores, RAG Status & Icon Sets Locked
- DQ Trend Dashboard & the Cost of Poor Data (with a Chart) Locked