Deck 9: Business Intelligence Systems

Question 1

Decision trees are good at sorting through lots of data and making binary:

A) projections.
B) classifications.
C) forecasts.
D) analysis.
E) decisions.

Answer 1

B

Question 2

To obtain a(n) ___________report, users go to a Web portal or digital dashboard and click on a link or button to produce and deliver the report.

A) pull
B) static
C) push
D) OLAP
E) query

Answer 2

pull

Question 3

Two ___________of storage would be equivalent to the amount of information in an entire research library.

A) petabytes
B) gigabytes
C) exabytes
D) terabytes

Answer 3

terabytes

Question 4

When a decision tree classifies customers into good and bad prospects for future sales, a company should be careful not to ___________ the bad prospects based on this.

A) neglect
B) cross- sell
C) support
D) reveal

Question 5

Tools for searching business data in an attempt to find patterns are called___________ tools.

A) DSS
B) BI
C) KM
D) EDI
E) CRM

Question 6

Because of problems with operational data, many organizations choose to extract operational data into a(n):

A) OLAP server.
B) database server.
C) EDI application.
D) data warehouse.
E) Web service.

Question 7

A petabyte of data is equal to ____________ gigabytes of data.

A) .001
B) 100
C) 1000
D) 1,000,000

Question 8

___________security precautions are more difficult to implement than physical security precautions.

A) Auditing
B) Illegal
C) Information system
D) Semantic

Question 9

Before it can be loaded into the data warehouse, operational data must be extracted and:

A) sorted.
B) cleaned.
C) processed.
D) filtered.

Question 10

___________reports allow users to drill down to view increasingly detailed levels of the data.

A) Dynamic
B) OLAP
C) Pull
D) Query
E) Push

Question 11

The purpose of a business intelligence system is to provide the right information to the right people at the right:

A) place.
B) price.
C) time.
D) situation.

Question 12

A reporting system supports the reporting process by helping to___________ , manage, and deliver reports.

A) publish
B) update
C) author
D) browse
E) retrieve

Question 13

All the words ever spoken by human beings could be stored on five ____________ of storage capacity.

A) exabytes
B) gigabytes
C) terabytes
D) megabytes
E) petabytes

Question 14

___________reports have measures and dimensions and allow users to change them.

A) OLAP
B) Pull
C) Static
D) Push
E) Query

Question 15

___________is the best known example of an indexing engine.

A) BI system
B) KM
C) Yahoo
D) Google
E) RSS

Question 16

If you wanted to see which products that customers tended to buy together, so that you could cross- market them you would perform a(n) ______________analysis.

A) regression
B) neural network
C) RFM
D) market- basket
E) OLAP

Question 17

Reports may process data into information by _______the source data.

A) updating
B) displaying
C) downloading
D) filtering

Question 18

___________is a problem that occurs when data- mining is used to create overly complex models that are not suited to making accurate predictions.

A) Dirty data
B) Overfitting
C) Inconsistent data
D) Model degradation

Question 19

Discussion groups and FAQs are forms of organizational:

A) CM.
B) BI.
C) RFM.
D) expert system.
E) KM.

Question 20

___________reads data from an operational database, performs calculations, and stores them on an OLAP database.

A) Drill down databases
B) OLAP servers
C) Operational servers
D) Access

Question 21

With a(n)___________ you can subscribe to content sources and be notified when they have been changed.

A) RSS reader
B) BI feed
C) KM feed
D) Index reader
E) BI system

Question 22

The ratio of confidence to the base probability of buying an item is the ____________ .

A) support
B) lift
C) confidence
D) cross- selling

Question 23

With OLAP reports it is possible to___________ in order to further divide the data into more detail.

A) filter
B) drill down
C) make calculations
D) summarize
E) sort

Question 24

____________ servers have customizable user interfaces.

A) Web
B) Commerce
C) Database
D) Portal

Question 25

Expert systems take the knowledge of experts and represent it in the system in the form of:

A) variables.
B) nodes in a graph.
C) rules.
D) XML tags.
E) attributes.

Question 26

RFM analysis generates reports that are used by:

A) finance.
B) operations.
C) marketing and sales.
D) human resources.
E) accounting.

Question 27

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

A) measure
B) lift
C) dimension
D) support
E) confidence

Question 28

A ____________ is a collection of data, taken from the data warehouse that is used to support the needs of a particular functional area like marketing.

A) Web farm
B) data mart
C) query
D) server

Question 29

On a web site, a customer's clickstream data provides a record of___________ on the site.

A) the orders placed
B) everything done
C) the ads viewed
D) the queries activated
E) the linked clicked

Question 30

___________tools are programs that read data from a variety of sources, process that data, and produce and deliver formatted reports to users.

A) RFP
B) Web service
C) XML
D) Data- mining
E) Reporting

Question 31

___________is/are used to predict values and determine classifications f good prospect customers.

A) Neural networks
B) Decision trees
C) Regression analysis
D) Cluster analysis

Question 32

In developing a data- mining application, it is important not to react to the results based on our:

A) past history.
B) biases.
C) budget.
D) resources.

Question 33

It is almost certain that in reality, when you take on a data- mining project, the data will be:

A) formatted properly.
B) full of viruses.
C) dirty.
D) buggy.

Question 34

It is not a good idea to___________ the model developed for a data- mining application just because the results were not what was expected.

A) publish
B) cancel
C) overfit
D) change

Question 35

Portals, ____________, and expert systems are technologies that are used for knowledge sharing among humans.

A) email
B) collaboration systems
C) content management
D) BI systems
E) KM systems

Question 36

An RFM score of ___________probably means that this customer has taken their business elsewhere and is probably not worth spending too many marketing resources on.

A) 321
B) 111
C) 333
D) 121
E) 555

Question 37

The "curse of dimensionality" is that the more attributes there are in the data warehouse the ___________it is to build a model that fits them.

A) easier
B) less effective
C) more important
D) costlier
E) harder

Question 38

In one famous example of how data- mining was used to find hidden relationships, it was found that on Thursday evenings, customers who buy diapers are much more likely to also buy:

A) beer.
B) formula.
C) frozen pizzas.
D) wipes.
E) motor oil.

Question 39

When protected information is released unintentionally through the combination of unprotected reports and documents, this is a violation of ___________security.

A) semantic
B) system
C) physical
D) illegal
E) auditing

Question 40

Problematic data is called ____________.

A) granularity.
B) rough data.
C) bad data.
D) dirty data.

Question 41

A firm's knowledge assets reside in documents, data, and ___________.

Question 42

___________is a technique that looks for groups of entities that have similar characteristics.

A) Decision trees
B) Neural networks
C) Regression analysis
D) Cluster analysis

Question 43

A data warehouse also contains a special database that stores the___________ , which records its source, history, format, and constraints.

A) metadata
B) dirty data
C) dimensional data
D) clickstream data
E) media format

Question 44

When creating a data warehouse that will be used for BI, programs first must extract,___________and prepare the operational data.

Question 45

Sometimes, large organizations break out___________ from their data warehouses so they can be used for a specific functional area of the organization like marketing or finance.

A) data marts
B) special groupings
C) Web services
D) OLAP applications
E) database servers

Question 46

Organizations often create ____________ to make information available to their employees.

Question 47

James wants to know how frequently each customer purchases from his stores and how much they spend, in order to offer discounts to the better customers. Catherine suggests that he perform a(n) ____________.

Question 48

In most cases, data- mining tools are used to make:

A) decisions.
B) predictions.
C) solutions.
D) assessments.

Question 49

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

A) Sales
B) TQM
C) Purchasing
D) CRM
E) RFM

Question 50

One benefit of ___________is that it fosters innovation and encourages the free flow of ideas.

Question 51

Data- mining projects are ____________ because you never know how they will turn out, and senior management may have high expectations about the results.

Question 52

A ___________takes data from operational systems, cleans it, and stores it.

A) data mine
B) data mint
C) data warehouse
D) data mart

Question 53

One ___________of memory would hold the equivalent of a pickup truck full of books.

Question 54

BIn2007, nearly 2,500 petabytes, or 2.5 ____________ of data had been generated.

Question 55

A BI ____________ tracks users and authorizations.

Question 56

RFM analysis ranks customers by considering the recency, frequency, and ___________of their orders.

A) dollar amount
B) timeliness
C) character
D) capacity
E) volume

Question 57

If you want to classify which customers are most likely to switch to another firm according to the number of years as your customer, you would use a___________ technique.

Question 58

___________data- mining is when analysts do not create a data model or hypothesis before running the analysis.

Question 59

Data can be made coarser by___________ .

A) summing it
B) dividing it
C) sharing it
D) It can't be made coarser.

Question 60

Because they are online, OLAP reports are___________ reports.

A) push
B) static
C) query
D) dynamic
E) pull

Question 61

A ____________ is a subset of a data warehouse that addresses a particular component or functional area of the business.

Question 62

When data sets have missing values or invalid entries it is called data.

Question 63

The term "knowledge discovery in databases (KDD)" is a synonym for ___________.

Question 64

___________refers to the relative level of detail that data represents.

Question 65

To find out what products are sold together most often a data- mining technique called___________analysis is helpful.

Question 66

___________systems are a type of KM system that use If...then...rules in order to capture and distribute organizational knowledge.

Question 67

___________tools are the equivalent of a telescope for data. They help us to search huge amounts of data for patterns and relationships.

Question 68

___________tools share employee knowledge with other employees and customers..

Question 69

Serious ___________arise when we classify people.

Question 70

___________analysis that identifies groups of entities with similar characteristics is a common unsupervised data- mining technique.

Question 71

Information systems that are designed to track lessons learned and best practices are known as ____________ systems.

Question 72

Two ___________ of storage would be equivalent to all the information stored in all of the research libraries in the United States.

Question 73

A decision tree is a useful tool for sorting through data and making ____________ based upon the chosen criteria.

Question 74

Many organizations create a special facility called a___________ by extracting operational data and cleaning it up for more sophisticated data analysis.

Question 75

According to the curse of___________ , the more attributes there are, the easier it is to build a model that fits the data, but which is worthless as a predictor.

Question 76

BI tools for reporting focus mainly on ___________.

Question 77

Data about what customers are doing on a company Web site is called___________ data.

Question 78

In some cases, organizations use decision trees to help select the ____________ that will be inputs into other types of data- mining applications.

Question 79

___________is the process of creating value from intellectual capital and sharing that with employees, suppliers, and customers who might need it.

Question 80

When data miners develop a model or hypothesis and then use statistical techniques to test it in the sample data set, they are using a ___________data- mining technique.