Chapter 7 Smartbook

What is the solution to the problem of being data rich and information poor?

Business intelligence

What contains a subset of data warehouse information?

Data mart

What determines the accuracy and completeness of its data?

Data quality audit

Select the statement that accurately describes a situation in which there is too much data to properly understand or make use of it.

Data rich and information poor

What is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks?

Data warehouse

___________, transformation, and loading is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.

Extraction

What is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse?

Extraction, transformation, and loading

What is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information?

Information cleansing

Select two terms that describe the process for weeding out, fixing, or discarding inconsistent, incorrect, or incomplete information.

Information cleansing Information scrubbing

Choose three reasons why operational systems are not appropriate for business analysis.

Operational systems are not integrated Operational information is mainly current Information from other operational applications is not included

Data _______ is the collection of data from various sources for the purpose of data processing.

aggregation

A(n) ___________ analysis can compare two or more data sets to identify patterns and trends.

comparative

BI can help managers with _______ monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

competitive

What occurs when a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products?

competitive monitoring

What is the collection of data from various sources for the purpose of data processing?

data aggregation

What is a business that collects personal information about consumers and sells that information to other organizations?

data broker

What is a storage repository that holds a vast amount of raw data in its original format until the business needs it?

data lake

What is a technique for establishing a match, or balance, between the source data and the target data warehouse?

data map

What is an individual item on a graph or a chart?

data point

What is an organized collection of data?

data set

What is an approach to business governance that values decisions that can be backed up with verifiable data?

data-driven decision management

Data-driven _______ management is an approach to business governance that values decisions that can be backed up with verifiable data.

decision

What is erroneous or flawed data?

dirty data

A data ______ is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

lake

A data _______ is a technique for establishing a match, or balance, between the source data and the target data warehouse.

map

A(n) __________ is a central location in which data is stored

repository

What identifies the primary location where data is collected?

source data

A data ________ is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

warehouse