The process of modifying the format, structure, or values of data is known as data transformation. Data can be modified at two phases of the data pipeline for data analytics initiatives. On-premises data warehouses often employ an ETL (extract, transform, load) method, with data transformation serving as the middle phase.