Data analytics can be disaggreated into two parts: ETL (extract, transform, and
ID: 2545629 • Letter: D
Question
Data analytics can be disaggreated into two parts: ETL (extract, transform, and load) or analysis. Classify each of the following processes as either ETL or analysis.
a. Removal of extraneous data and noise
b. Looking for trends in the data that might predict new sales opportunities
c. Finding the necessary data from the financial reporting system to give the external auditor for analysis
d. Performance of a test of internal controls by the external auditor
e. Considering Champaign, Illinois, weather patterns to predict corn production in the immediate area
f. Consolidating large volumes of data from multiple sources and platforms
Explanation / Answer
ETL ( Extract, transform, and load ) or ANALYSIS Classification
a. Removal of extraneous data and noise - ETL
b. Looking for trends in the data that might predict new sales opportunities - ANALYSIS
c. Finding the necessary data from the financial reporting system to give the external auditor for analysis - ETL
d. Performance of a test of internal controls by the external auditor - ANALYSIS
e. Considering Champaign, Illinois, weather patterns to predict corn production in the immediate area - ANALYSIS
f. Consolidating large volumes of data from multiple sources and platforms - ETL
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.