Quiz 10 Practice

Which type of analytics would be associated with summarizing what happened in the past? Descriptive Prescriptive Diagnostic Predictive

Descriptive

Which type of analytics addresses "Why did it happen"? Descriptive Prescriptive Diagnostic Predictive

Diagnostic

The acronym, ETL, in the process of readying data for use in data analysis refers to what three words? Extrapolate, Transform and Lift Extrapolate, Transpose and Load Extract, Transform and Load Extract, Transform and Lift

Extract, Transform and Load

Which type of analytics would be associated with forecasting future sales amounts for a company? Descriptive Prescriptive Diagnostic Predictive

Predictive

Which type of analytics would be associated with finding the sales amount needed to break even? Descriptive Prescriptive Diagnostic Predictive

Prescriptive

According to estimates considered in the chapter, up to what percentage of a data analyst's time is spent cleaning (or scrubbing) the data to be ready for analysis? 90% 80% 30% 10%

90%

The A in the AMPS model stands for which of the following? Ask the Question Answer the Question Address the Question Ask the Decision Maker

Ask the Question

The AICPA developed standards called ADS for the formatting of data files and fields typically needed to support an external audit in a given financial business process area. What does the acronym ADS stand for? Accounting Doctoral Scholars Accounting Data Standards Audit Data Standards Auditor Data Standards

Audit Data Standards

Which term is used to describe the science of examining raw data, removing excess noise from the dataset, and organizing the data with the purpose of drawing conclusions for decision making? Big Data Data Analytics Information Analytics Extract, Transform and Load

Data Analytics

Big Data is often described by the four V's, or a) Volume, Velocity, Veracity and Variety b) Volume, Velocity, Volatility and Veracity c) Volume, Volatility, Variability, and Variety d) Volume, Volatility, Veracity, and Variability

a) Volume, Velocity, Veracity and Variety