Data transformation

Data transformation is the step of reshaping data so it can be used somewhere else. Dates written three different ways get put into one format. Product names that differ between Shopify and Xero get matched up. A single address field gets split into street, suburb, and postcode. It happens behind the scenes whenever you connect your tools, and it's where many connections quietly go wrong. A salon moving client records into Fresha might need old notes split into the right fields. A charity might need volunteer availability from texts turned into a table. AI is good at the messy parts, like reading free-text notes. A person should spot-check the results, because a small mistake repeats across every record.