Question

chapter 9

Required:

13.Data analytics can be disaggregated into two parts: ETL (extract, transform, and load) or analysis. Classify each of the following processes as either ETL or analysis.

Process ETL/Analysis a. Removal of extraneous data and noise ETL 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 to 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

8. Which of the following is not a characteristic of an Excel table?

Multiple Choice

• No blank rows

• Includes charts

• No blank columns

• Includes a header row

• None of the choices are correct

10.

Which of the following is not true about a pivot table?

Multiple Choice

• Users can select report row variables.

• Users can select report column variables.

• Users can select to include grand totals.

• Users must sum the values in the pivot table.

• Users can format the values in the pivot table.

Answer 1

Ans.13.

	Process	ETL/ Analysis
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 to the external auditor for analysis	ETL
d.	Performance of a test of internal controls by the external auditor	ETL
e.	Considering Campaign, Illinois, weather patterns to predict corn production in the immediate area	Analysis
f.	Consolidating large volumes of data from multiple sources and platforms	ETL

Ans.8. Includes a header row

Ans.10. Users must sum the values in the pivot table.