MIS Chp 7

A sales team should attempt to up-sell more expensive products to a customer who has an RFM score of ________.

113

Ajax Inc. is one of the customers of a well-known linen manufacturing company. Ajax has not ordered linen in some time, but when it did order in the past it ordered frequently, and its orders were of the highest monetary value. Under the given circumstances, Ajax's RFM score is most likely ________.

511

Push publishing delivers business intelligence ________.

According to a schedule or as a result of an event or particular data condition

Which of the following is true of unsupervised data mining?

Analyst do not create a model or hypothesis before running the anaylsis

Which of the following is an example of a measure in an OLAP report

Average cost

Which of the following statements is true about BI publishing alternatives?

BI servers extend alert/RSS functionality to support user subscriptions

________ is defined as information containing patterns, relationships, and trends of various forms of data.

Business Intelligence

Which of the following is a basic operation used by reporting applications to produce business intelligence

Calculating

With ________, statistical techniques can identify groups of entities that have similar characteristics.

Cluster Analysis

________ are information systems that support the management and delivery of documents including reports, Web pages, and other expressions of employee knowledge.

Content Management Systems

In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X."

Cross-Selling

Due to a phenomenon called the ________, the more attributes there are, the easier it is to build a model that fits the sample data but that is worthless as a predictor.

Curse of dimensionality

________ is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

Data acquisition

Which of the following statements is true about data marts?

Data marts address the needs of a particular department or functional area of business

Which of the following is a fundamental category of BI analysis?

Data mining

________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction

Data mining

A ________ takes data from the data manufacturers, cleans and processes the data, and locates the data on the shelves.

Data warehouse

Because of the various problems with operational data, large organizations choose to extract operational data and typically create and staff a group of people who manage and run a(n) ________.

Data warehouse

A ________ is a hierarchical arrangement of criteria that predict a classification or a value

Decision tree

The remarkable characteristic of OLAP reports is that they are ________, as they are online and the viewer of the report can change their format.

Dynamic

A sales report that is current at the time the user accessed it on a Web server, is an example of a(n) ________.

Dynamic report

Knowledge management (KM) benefits organizations because it ________.

Enables employees and partners to work smarter

In the context of KM systems, ________ attempted to directly capture employee expertise.

Expert Systems

A data mart is a lot larger than data warehouse

False

A decision tree analysis is a supervised data mining technique

False

A drawback associated with OLAP reports is their inability to let users drill down into the data

False

A sales report that is current at the time the user accessed it on a Web server is a static report.

False

Business intelligence systems have only four of the five components of an information system; Hardware software, data and people

False

Data acquisition is the process of creating business intelligence

False

Data mart is another term used for a data warehouse

False

Data warehouses do not include data that are purchased from outside sources.

False

In market-based terminology, confidence is the probability that two items will be purchased together

False

In market-basket terminology, a conditional probability estimate is called lift

False

In supervised data mining, a model is developed after the analysis

False

It is better to have data with too coarse a granularity, than data with too fine a granularity.

False

Knowledge management was done only after the advent of social media

False

Neural networks are a popular unsupervised data mining technique used to predict values and make classification

False

Placing BI applications on operational servers can dramatically increase system performance.

False

Push publushing requires the user to request BI results

False

RFM analysis considers how recently (R) a customer ordered, how frequently (F) they ordered, and how much margin (M) the company made on the orders.

False

Total sales, average sales, and average cost are examples of dimensions used in an OLAP report.

False

________ is a term that refers to the level of detail represented by the data.

Granularity

_______ is the application of social media and related applications for the management and delivery of organizational knowledge resources.

Hyper-Social knowledge management

Which of the following accurately defines a dimension in an OLAP report?

It is a characteristic of a measure

Which of the following is true of source data for a BI system? A) It refers to the organization's metadata. B) It refers to data that the organization purchases from data vendors. C) It refers to the level of detail represented by the data. D) It refers to the hierarchical arrangement of criteria that predict a classification or a value.

It refers to data that the organization purchases from data vendors

________ is the process of creating value from intellectual capital and sharing that knowledge with employees, managers, suppliers, customers, and others who need it.

Knowledge Management

Which of the following terms is used as a synonym for data mining

Knowledge discovery in databases

In market-basket terminology, the ratio of confidence to the base probability of buying an item is called ________.

Lift

________ is a technique for harnessing the power of thousands of computers working in parallel.

MapReduce

Which of the following shows the products that customers tend to buy together?

Market-Based Analysis

A data ________ is a data collection, smaller than the data warehouse, that addresses the needs of a particular department or functional area of the business.

Mart

BI servers use ________ to determine what results to send to which users and on which schedule.

Metadata

________ records the source, format, assumptions and constraints, and other facts about the data.

Metadata

The ________ is the most popular BI server today.

Microsoft SQL Server Report manager

An ________ and an OLAP report are the same thing.

OLAP cube

Which of the following observations about RFM and OLAP reports is true?

OLAP reports are more dynamic than RFM reports

The viewer of an OLAP report can change its format. Which term implies this capability?

Online

_______________ Requires the user to request BI results

Pull publishing

Which of the following statements is true about operational data?

Purchased operational data often contains missing elements

RFM analysis is used to analyze and rank customers according to their ________.

Purchasing Patterns

________ analysis is a way of analyzing and ranking customers according to their purchasing patterns.

RFM

Which of the following is an example of a supervised data mining technique?

Regression Analysis

U.S. Steel Corp. is a well-known steel manufacturing company. SAMCROW, one of the customers of U.S. Steel Corp. holds an RFM score of 111. Which of the following characteristics relates SAMCROW with its RFM score

SAMCROW has ordered recently and orders frequently, and it orders the most expensive goods.

An OLAP report has measures and dimensions. Which of the following is an example of a dimension?

Sales region

With ________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

Supervised data mining

In market-basket terminology, ________ describes the probability that two items will be purchased together.

Support

How should a sales team respond to a customer who has an RFM score of 545?

The sales team should let go of this customer, the loss will be minimal

Which of the following observations concerning expert systems is true?

These systems encode human knowledge in the form of "If/Then" rules.

A BI server extends alert/RSS functionality to support user subscriptions

True

A common business application of decision trees is to classify loans by likelihood of default.

True

A data mart is a data collection that addresses a particular functional area of the business

True

A reporting application is a BI application that inputs data from one or more sources and allies reporting operations to that data to produce business intelligence

True

All management data needed by any of the BI servers is stored in metadata

True

An OLAP cube and an OLAP report are the same thing

True

An OLAP report, a measure of data item of interest

True

Cluster analysis is used to identify groups of entities that have similar characteristics

True

Data mining is the application of statistical techniques to find patterns and relationships among data for classification and prediction

True

Dynamic reports are BI documents that are updated at the time they are requested

True

Expert systems are rule-based systems that encode human knowledge in the form of "if/then" rules

True

Granularity is a term that refers to the level of detail represented by the data

True

Hadoop is an open-source program supported by the Apache Foundation4 that implements MapReduce on potentially thousands of computers.

True

In expert systems, the programs that process a set of rules are called expert systems shells

True

In marketing transactions, the fact that customers who buy product X also buy product Y creates a cross selling opportunity

True

It is possible to capture the customers clicking behavior using clickstream data

True

Knowledge discovery in databases (KDD) is used as a synonym for data mining

True

MapReduce is a technique for harnessing the power of thousands of computers working in parallel.

True

OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data.

True

Operational data is structure for fast and reliable transaction processing

True

Problematic data are termed dirty data

True

Regression analysis measures the effect of a set of variables on another variable

True

Report servers are specialized Web servers.

True

Static reports are BI documents that are fixed at the time of creation and do not change

True

The defining characteristics of OLAP reports is that they are dynamic

True

The five basic reporting operations that produce business intelligence can all be accomplished using SQL and basic HTML or a simple report writing tool.

True

The four fundamental categories of BI analysis are reporting, data mining, BigData, and knowledge management.

True

The software component of a BI system is called a BI application

True

The three primary activities in the BI process are to acquire data, perform analysis and publish results

True

With unsupervised data mining, analysts do not create a model or hypothesis before running the analysis.

True

knowledge management is the process of creating value from intellectual capital and sharing it with those who need it

True

Which of the following statements is true about reporting applications?

Two important reporting application are RFM analysis and OLAP

Problematic operational data are termed ________.

dirty data

OLAP stands for

online analytical processing

A value of 999—999—9999 for a U.S. phone number is an example of dirty data for BI purpose.

tRUE