BI Processes $-$ Extract, Transform & Load $($ETL$)$

ETL refers to any time when data is taken from one source, transformed in some way, and loaded into a different destination. Data Engineers do a lot of ETL between database systems, whilst Data Analysts extract data from files and databases and transform it for specific projects.

Which of the following best describes the extract, transform & load $($ETL$)$ task of the data analyst's role?

Combine tables to create data models that link related data

Document data models and metric definitions

Write formulas to calculate business performance

Import, combine, and transform data. Convert data into the desired format before loading the data into a file or data model.