Class 5
ETL: Cleaning and Transforming Data
Description
This class introduces common techniques for cleaning and transforming data, including filtering, selecting, sorting, calculating, and summarizing information. These transformations are important because raw accounting data often need to be modified before they can answer a specific accounting or business question.
Motivation
How do we prepare messy data for analysis?
Review
The previous classes introduced the ETL process and showed how information from different sources can be combined. This class expands that process by considering how individual observations and variables can be changed, cleaned, and summarized to create useful analytical data.
Data
Git extracted data in ACCTG320/data_cleansing (git pull maybe required).