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