Skip to content
BENIBIX Learn

Data Enrichment

Data⚙️ ProcessingData Transformation

Also known as Data Enhancement, Data Appending

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

Think of it like

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

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.

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.
The order never had a city. A lookup on its postcode adds one.

Common mistake

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

Key takeaways

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