Extract, Transform, and Load (ETL) Fundamentals

Description

This class discusses Extract, Transform, and Load (ETL) as a process for obtaining data and preparing it for analysis. ETL is important because accounting data frequently need to be collected, cleaned, or reorganized before they can be used to answer a question.

Motivation

How do we turn raw data into usable data?

Review

The prior class considered problems that can affect the quality of accounting data. This class introduces a systematic process for moving from the data we receive toward a dataset that is ready for analysis.

Preparation

• Review the introductory material on data quality and ETL processes.

Concepts

• Primary keys

Data

Git extracted data in ACCTG320/ETL (git pull maybe required).