Data flow - Activity
Transform
Cleaning, reshaping or combining data so it is ready for its next use
What's it for?
Cleans or reshapes information so it is ready for another system, report or analysis.
For example…
Currency codes are standardised and duplicate customer rows are merged before a board pack is built
A transform step converts dates into one format, changes pence to pounds and joins product names onto raw sales records before reporting
Think of it like…
Washing, chopping, and measuring ingredients before cooking, not serving them straight from the bag