# Data Transformation

> Raw data is changed into the shape a report needs.

**Field:** Data Engineering  
**Category:** Processing  
**Also known as:** Transformation, Data Transform

## Think of it like

It is like making soup from a bag of shopping. You wash, cut and mix until it is ready to eat.

## Definition

Data transformation changes raw data into the shape a report or model needs. It can fix types, rename columns, join tables, filter rows and add up totals. It is the T in ETL and ELT. Today it is often written in SQL and run inside the warehouse. Each step should be tested, so a bad change is caught early.

## Example

Raw orders hold prices as text and dates in three formats. A transformation fixes both, then adds up sales by day.

## Why it matters

Raw data is rarely ready to use. Most of a data team's time goes into this step.

## Common mistake

Doing all the work in one huge query. Small steps are easier to test, fix and reuse.

## Three principles

- **Raw in, shaped out.** Fix, join, filter and sum.
- **The T in ETL.** Often SQL in the warehouse.
- **Small tested steps.** Catch a bad change early.

## Related terms

- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)
- [Extract, Load, Transform (ELT)](https://learn.benibix.com/term/data/elt)
- [dbt (Data Build Tool)](https://learn.benibix.com/term/data/dbt)
- [Data Cleaning](https://learn.benibix.com/term/data/data-cleaning)
- [Data Pipeline](https://learn.benibix.com/term/data/data-pipeline)
- [Data Enrichment](https://learn.benibix.com/term/data/data-enrichment)

---

Source: https://learn.benibix.com/term/data/data-transformation
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.
