Data flow - Activity
Data transformation
Changing data’s format, structure or values so it is ready for another use
What's it for?
Changes data into the shape or format needed by another system or report.
For example…
Dates from US and UK formats are converted to one standard before a global sales report runs
A transformation converts prices from pence to pounds, splits a full name into separate fields and calculates net revenue before loading a report table.
Think of it like…
Converting measurements from inches to centimetres so a shared recipe works for everyone