thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Data Transformation

Converting data from one structure, format or value set to another, by filtering, joining, aggregating, pivoting, deriving or recoding.

Definition

Transformations happen in ETL/ELT pipelines, BI prep layers and SQL views, and should be version controlled and tested.

Exam tip

Know the common transformation types: aggregation, derivation, normalization or denormalization, pivoting, filtering and joining.

Related terms