Validity: Format, Allowed-Value and Range Rules
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Completeness: Blank Cells, Field Completeness & Complete RecordsFree
- Validity: Format, Allowed-Value and Range Rules Pro
- Uniqueness: Duplicate Keys, Distinct Counts & Duplicate Emails Pro
- Consistency across Tables: Orphan Keys and Conflicting Values Pro
- Timeliness: Entry Lag, SLA Compliance, p90 and Freshness Pro
- Accuracy: Checking a Sample against Verified Values Pro
- The DQ Scorecard: Weighted Scores, RAG Status & Icon Sets Pro
- DQ Trend Dashboard & the Cost of Poor Data (with a Chart) Pro