Data transformation turns, or converts, data from one format into another format. In the process, the data could restructured or cleaned.
Data transformation pipelines flow from the source where data is determined and its structure is mapped. The data is then structured in a way which is interpretable by other programs downstream, and for storage in data warehouses (DWHs) or data lakes.
It can unify and flatten data so that it's easier to work with.