Skip to content
BENIBIX Learn

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

Data validity is whether a value follows the rules for its field. A date must be a real date, and an email must have an @ in it. A status must be one of a fixed list, such as paid or refunded. A quantity must be zero or more. Validity can be checked by machine, unlike accuracy. A valid value can still be wrong.
Validity is the last tile. 31 February breaks the rules for a date.

Common mistake

Letting a free text box fill a field that has fixed choices. Every spelling then becomes its own value.

Key takeaways

  1. 1
    Right type. A date is a date, a number a number.
  2. 2
    Allowed values. Within a list or a range.
  3. 3
    Not the same as true. Valid values can still be wrong.