Ch. 7 CIS Exam 2

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

-information cleansing -information scrubbing

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.

What is an organized collection of data?

A data set

What is the collection of data from various sources for the purpose of data processing (age, profession, or income)?

Data aggregation

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

Data map

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

Data warehouse

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 (ETL)

A data________is a business that collects personal information about consumers and sells that information to other organizations.

broker

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

business intelligence

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 competitors activities on the web using software that automatically tracks all competitor website activities such as discounts and new products?

competitive monitoring

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

data lake

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_______contains a subset of data warehouse information.

mart

A data________is an individual item on a graph or a chart.

point

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

repisitory

What identifies the primary location where data is collected?

source data