Class 6
The ETL Process: Advanced Data Transformations
Description
This session develops more advanced techniques for restructuring, aggregating, joining, and deriving information from complex datasets. These techniques are important because many accounting questions require analysts to move beyond cleaning individual variables to constructing new measures and analytical datasets from multiple observations and sources.
Motivation
How do we restructure complex data?
Review
The prior session introduced transformations that make raw data usable. This session extends those techniques to more complex settings in which the analyst must determine how observations should be combined, summarized, or reorganized to address a specific question.