# Data Consistency

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

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Consistency (Data Quality)

## Think of it like

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

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Data Quality Dimensions](https://learn.benibix.com/term/data/data-quality-dimensions)
- [Data Accuracy](https://learn.benibix.com/term/data/data-accuracy)
- [Master Data Management (MDM)](https://learn.benibix.com/term/data/master-data-management)
- [Data Quality Check](https://learn.benibix.com/term/data/data-quality-check)

![Six tiles, one per quality dimension, each with a small broken example: accuracy shows a wrong price, completeness a blank email, consistency two totals that disagree, freshness a table last loaded 3 days ago, uniqueness an order listed twice, and validity a date of 31 February.](https://learn.benibix.com/diagrams/data-quality-dimensions.svg)

---

Source: https://learn.benibix.com/term/data/data-consistency
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
