Class 5
The ETL Process: Introduction to Transforming data
Description
This session introduces common data transformations used to clean, standardize, reshape, and prepare data for analysis. Transformation is important because analytical results depend on converting raw observations into consistent variables and structures that accurately represent the underlying business activity.
Motivation
How do we make messy data usable?
Review
The preceding sessions focused on acquiring data and understanding relationships among datasets. This session moves into the transformation stage of ETL by considering how extracted and combined data must be changed before they can provide useful analytical evidence.