Validity: Format, Allowed-Value and Range Rules
This lesson is part of the course
In this lesson
You test every email for a basic format, every country against an allowed list and every credit limit for type and range, compute validity rates per rule and per row, and add a Data Validation rule that stops new bad limits.
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