⚙️Data Enrichment
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
Common mistake
Key takeaways
- 1Adds facts. New columns from another source.
- 2From a lookup. A list, a table or a service.
- 3After cleaning. Clean first, then enrich.