Data Transformation

Synonyms: Data Conversion, Interactive Data Transformation 

What is Data Transformation? 

Data Transformation is the process of changing the value of data, format, and/or structure. Transformation of data helps businesses realize analytical and operational business goals. 

Data transformation are of two types: 

  1. Businesses that use on-premises data warehouse use an ETL (Extract, Transform and Load) where the transform is the middle step. 
  2. Businesses that use cloud-based data warehouse where the process of ELT (Extract, Load and Transform) is followed. 

Based on requirements data transformation can be automated by ETL tools that can be synched based on data requirements. Scripting languages such as Python or Domain-specific languages like SQL can be used by Data Analysts, Data Scientists, and Data Engineers.