# Data Enrichment

> Adding facts from a second list to your rows, like a city.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Data Enhancement, Data Appending

## Think of it like

It is like adding a map to a list of addresses. Each address now shows where it is.

## Definition

Data enrichment adds useful facts to your data from another source. An order might gain the buyer's region. A web visit might gain the city its IP address points to. The new facts often come from a lookup table or a paid data service. It is done after cleaning and before analysis. It answers questions the raw data could not.

## Example

An online shop adds a country to each order from the buyer's postcode. Sales can now be split by country in one click.

## Why it matters

Raw data rarely holds every fact you need. Enrichment adds the missing ones and leaves the source alone.

## Common mistake

Enriching with a lookup that is out of date. Every new row gets the wrong value, and nobody notices.

## Three principles

- **Adds facts.** New columns from another source.
- **From a lookup.** A list, a table or a service.
- **After cleaning.** Clean first, then enrich.

## Related terms

- [Data Transformation](https://learn.benibix.com/term/data/data-transformation)
- [Data Cleaning](https://learn.benibix.com/term/data/data-cleaning)
- [Reference Data](https://learn.benibix.com/term/data/reference-data)
- [SQL Join](https://learn.benibix.com/term/development/join)
- [Data Quality](https://learn.benibix.com/term/data/data-quality)
- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)

![An order with an id, a $40 total and the postcode 10115 meets a dashed lookup table that says 10115 is Berlin, Germany. Both arrows meet in a match step, and out comes a highlighted enriched order that keeps the first three facts and adds the city Berlin and the country DE.](https://learn.benibix.com/diagrams/dat3-enrichment.svg)

---

Source: https://learn.benibix.com/term/data/data-enrichment
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-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
