Data integrity preserves accurate, consistent relationships among linked tables, variables, and entities. It matters when records are captured, loaded, transformed, or shared across systems. section 1.2.3
Employee records across tables
An employee’s details may be distributed across multiple tables connected by employee ID. Data integrity requires those relationships and entity details to remain consistent. section 1.2.3
Check integrity alongside broader data-quality problems:
- Compare values reported by different systems, such as conflicting revenue figures, and seek business guidance when discrepancies remain. section 1.2.3
- Inspect for nulls, blanks, invalid characters, incorrect types, duplicates, and outliers that can degrade downstream analysis. section 1.2.3
Figure 1.5 Data quality is of paramount importance; attributes of good-quality data are shown.
Use the data-quality figure to situate integrity among the attributes of usable data. section 1.2.3
