Deck 17: Learn the basic concepts of business intelligence (BI)systems

Question 1

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Answer 1

False

Question 2

Report delivery is more important for data mining than it is for reporting systems.

Answer 2

False

Question 3

What are Business Intelligence (BI)systems?

Answer 3

Business Intelligence (BI)systems are information systems used by managers and other business professionals to analyze past and current activities and to predict future events.BI systems do not support the recording and processing of operational data - this is left to transaction processing systems.Instead,BI systems are management support systems that produce information for assessment,analysis,planning and control.There are two main categories of BI systems: reporting systems and data mining applications.

Question 4

Data mining is the application of mathematical and statistical techniques to find patterns and relationships that can be used to classify and predict.

Question 5

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

Question 6

A report generated by a reporting system is delivered to the appropriate users via a printed report.This system uses which of the following report modes?

A) Push
B) Pull
C) Query
D) OLAP
E) None of the above

Question 7

Business Intelligence (BI)systems fall into which of the following categories?

A) Processing
B) Reporting
C) Data mining
D) Both A and B
E) Both B and C

Question 8

Data mining applications are used to accomplish all except which of the following tasks?

A) Creating reports
B) Perform what-if analysis
C) Make predictions
D) Facilitate decision making
E) Perform data analyses using complex mathematical processing

Question 9

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

Question 10

Business Intelligence (BI)systems do which of the following?

A) Analyze current and past activities
B) Predict future events
C) Record and process transactions
D) Both A and B
E) Support operational activities

Question 11

Business Intelligence (BI)systems are information systems that help users analyze and use data.

Question 12

In unsupervised data mining,explanations are created after patterns are found.

Question 13

An extract,transform,and load (ETL)system obtain data from ________,external data,and other internal data.

Question 14

A(n)________ is an information system that helps users analyze and use data.

Question 15

Most data mining techniques are simple and easy to use.

Question 16

Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Question 17

The metadata maintained by a reporting system database describes all of the following except ________.

A) reports
B) users
C) database relations
D) roles
E) groups

Question 18

In unsupervised data mining,a model or hypothesis is created ahead of time.

Question 19

Business Intelligence (BI)systems support operational activities.

Question 20

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

Question 21

Problematic data include so-called "dirty data."

Question 22

What is data mining application?

Question 23

In supervised data mining,statistical techniques are used to estimate the parameters of the model.

Question 24

A data warehouse database differs from an operational database because ________.

A) data warehouse data are not stored in tables
B) data warehouse databases do not have metadata
C) data warehouse data are often stored in a dimensional database
D) Both B and C
E) None of the above

Question 25

Business Intelligence (BI)________ uses sophisticated statistical and mathematical techniques to perform what-if analyses,to make predictions,and to facilitate decision making.

Question 26

Problematic data are called ________.

Question 27

Cluster analysis is a commonly used technique in supervised data mining.

Question 28

Data warehouses are populated with data prepared by extract,transform,and load (ETL)systems.

Question 29

The combination of a data mart structure with a data warehouse architecture is known as an ________ data warehouse.

A) enterprise
B) entrepreneurial
C) encompassing
D) eclectic
E) integrated

Question 30

Which of the following is a common supervised data mining technique?

A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) Both A and B
E) Market Basket Analysis

Question 31

A data mart is a collection of data that addresses a particular component or functional area of a business.

Question 32

We have obtained access to the company's operational data.We examine 50 records for customers with phone numbers that should use the current area code of 345.Of these 50 records,we find 10 that still use an older area code of 567.This is an example of ________.

A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
E) a "too much data" problem

Question 33

We have obtained access to the company's operational data.In one record,we find that a customer's age has been recorded as "337." This is an example of ________.

A) dirty data
B) inconsistent data
C) non-integrated data
D) a "wrong format" problem
E) a "too much data" problem

Question 34

Data warehouse data is often stored in a(n)________.

Question 35

Which of the following are true about data mining applications?

A) They use sophisticated mathematical techniques.
B) They use sophisticated statistical techniques.
C) Their report delivery is more difficult than report delivery for reporting systems.
D) Both A and B
E) The results are never incorporated into some other report.

Question 36

Data mining techniques are used to find patterns and relationships that can be used to ________.

A) report
B) classify
C) predict
D) Both B and C
E) None of the above

Question 37

Which of the following is a common unsupervised data mining technique?

A) Cluster analysis
B) Regression analysis
C) RFM analysis
D) Both A and B
E) Neural Networks

Question 38

Which of the following popular data mining techniques require special software?

A) Decision tree analysis
B) Logistic regression analysis
C) Neural networks
D) Both A and B
E) A, B and C

Question 39

We have obtained access to the company's operational data.We have been asked to produce a report with an item by item analysis of sales,but the only sales figure available is the total sale value for each order.This is an example of ________.

A) dirty data
B) inconsistent data
C) non-integrated data
D) an incorrect format problem
E) a "too much data" problem

Question 40

A data warehouse is a database system that has data and programs for,as well as personnel specialized in,BI processing.

Question 41

Market basket analysis is a data mining technique for determining which sets of products customers tend to purchase at the same time.

Question 42

Market basket analysis is ________.

A) a data mart specific technique
B) a reporting technique
C) an RFM application
D) an OLAP application
E) a data mining technique

Question 43

Refer to the table above.What is the definition of support for Drug A and Drug B?

A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased

Question 44

What is a data warehouse?

Question 45

In market basket analysis,confidence is the probability that one particular product will be purchased.

Question 46

Refer to the table above.What is the lift for Drug B being purchased given that Drug A has been purchased?

A) )200
B) )250
C) )333
D) )500
E) )667

Question 47

Market basket analysis,as described in the text,uses the statistical technique of ________.

Question 48

Refer to the table above.What is the support for Drug A and Drug B?

A) )025
B) )075
C) )100
D) )125
E) )200

Question 49

Why is operational data sometimes unusable for Business Intelligence purposes?

Question 50

Decision trees are widely used today,because the exact process used to build a decision tree is simple and straightforward.

Question 51

Market basket analysis as described in the text uses the technique of conditional probabilities.

Question 52

BI Reporting systems are intended to create meaningful information from disparate data sources and to deliver that information to the proper users on a timely basis.

Question 53

In market basket analysis,lift is confidence divided by support.

Question 54

In market basket analysis,support is defined as the probability that two items will be purchased together.

Question 55

In a decision tree,there will be only one root in the tree.

Question 56

A(n)________ is a collection of data that addresses a particular component or functional area of a business.

Question 57

Refer to the table above.What is the confidence of Drug B being purchased given that Drug A has been purchased?

A) )200
B) )250
C) )333
D) )400
E) )500

Question 58

Refer to the table above.What is the definition of confidence for Drug B with reference to Drug A?

A) The probability that Drug A will be purchased
B) The probability that Drug B will be purchased
C) The probability that both Drug A and Drug B will be purchased
D) The probability that Drug A will be purchased given that Drug B has been purchased
E) The probability that Drug B will be purchased given that Drug A has been purchased

Question 59

Data warehouses are populated with data prepared by ________ programs.

Question 60

What is a star schema?

Question 61

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

Question 62

Report systems include three functions: authoring,management and delivery.

Question 63

One Business Intelligence (BI)reporting system that uses extensions to SQL is ________.

A) cluster analysis
B) OLAP
C) regression analysis
D) RFM analysis
E) decision trees

Question 64

Business Intelligence (BI)reporting systems can do which of the following operations?

A) Filter data
B) Group data
C) Modify data
D) Both A and B
E) All of the above

Question 65

RFM analysis is a way of analyzing and ranking customers based on online survey data.

Question 66

Report modes include dynamic and static.

Question 67

Reports that do not change once prepared are called static reports.

Question 68

Report authoring includes responsibility for delivery of the report.

Question 69

Which of the following is not a reason that operational data are difficult to read?

A) Dirty data
B) Duplicated data
C) Non-integrated data
D) Missing values
E) Incorrect format

Question 70

A reporting system does not maintain a database of metadata.

Question 71

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Question 72

Reports that rely on the most current data when they are prepared are called dynamic reports.

Question 73

In a common form of RFM analysis,an RFM score of 5 1 1 means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

Question 74

Report management defines who gets the report,how often,and how it is to be delivered.

Question 75

A report that is sent to users on a predetermined schedule is called a push report.

Question 76

A report that is sent to users only upon the users' request is called an on-demand report.

Question 77

A digital dashboard is an electronic display customized for an individual user.

Question 78

A BI reporting system ________.

A) creates meaningful information from disparate data sources
B) delivers information to users on a timely basis
C) uses statistical procedures to predict future events
D) Both A and B
E) None of the above

Question 79

In RFM analysis,R stands for "how recently",F stands for "how frequently" and M stands for "how many months."

Question 80

Report management systems include the ability to create associated user accounts and groups.