Skip to content
BENIBIX Learn

Data Consistency

Also known as Consistency (Data Quality)

Whether the same fact matches in every place it is kept.

Think of it like

Mum says dinner is at six. Dad says it is at seven. They cannot both be right.

Example

The sales report says 1,200 orders yesterday, but the finance report says 1,150. The team traces the gap to refunds counted in one and not the other.

Why it matters

Two numbers for one thing destroy trust fast. People stop using both reports.

Definition

Data consistency is whether the same fact agrees in every place it shows up. A customer's country should match in the shop, the billing system and the warehouse. Totals should match their parts, such as order lines adding up to the order. Formats should match too, such as dates written one way. When two places disagree, at least one of them is wrong.
Consistency is the third tile. Two places give two totals for the same thing.

Common mistake

Checking each table on its own. This kind of problem only shows when you put two places side by side.

Key takeaways

  1. 1
    Same fact, same value. Every copy agrees.
  2. 2
    Parts add up. Details sum to their totals.
  3. 3
    Compare across. Checks span two or more places.