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?

IT Exam Items Repository › Category: Data Analytics Essentials › 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?

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