Data architecture - Process
Data standardisation
Making values follow agreed formats and conventions
What's it for?
Makes values follow the same formats and conventions so they can be compared and combined reliably.
For example…
Data standardisation converts “UK”, “United Kingdom” and “GB” into one agreed country value before reporting.
A migration standardises dates into YYYY-MM-DD and phone numbers into one format so the target system receives consistent values.