🛡️Data Validity
Also known as Validity (Data Quality), Valid Data
Whether a value keeps to the rules, like a real date.
Think of it like
A form asks for your age, and someone writes "blue". It is not even the right kind of answer.
Example
A country field holds UK, United Kingdom and GB. Only GB is on the allowed list, so the other two fail the validity check.
Why it matters
Invalid values break joins, filters and charts. They are cheap to catch at the door and costly to clean later.
Definition
Common mistake
Key takeaways
- 1Right type. A date is a date, a number a number.
- 2Allowed values. Within a list or a range.
- 3Not the same as true. Valid values can still be wrong.