Data Transformation Overview
Data transformation is the process of converting data from one format to another. The most common data transformations are converting raw data into a clean and usable form, converting data types, removing duplicate data, and enriching the data to benefit an organization. During the process of data transformation, an analyst will determine the structure, perform data mapping, extract the data from the original source, execute the transformation, and finally store the data in an appropriate database.
Transformed data is usable, accessible, and secure to benefit a variety of purposes. Organizations may transform data to make it compatible with other types of data, move it into the appropriate database, or combine it with other crucial information. Organizations benefit from transforming data by gaining insights into vital operational and informational internal and external functions. In addition, data transformation makes it possible for organizations to transform data from a storage database to the cloud to keep information moving.