An analyst is reviewing gathered data from various sources and modifying incompatible metrics into a usable form. In which ETL step would this task be completed in?
- action
- extract
- load
- transform
Explanation: There are three processes in data preparation:
- Extract - the process of gathering the data to be analyzed
- Transform - the process of aggregating data and modifying it into a usable form
- Load - the process of transferring data to a database
Related exam: Module 3.5.2 Quiz – Preparing and Cleaning Data for Analysis
