Test Bank Chapter 12 Business Intelligence And Analytics

Chapter 12

Business intelligence and Analytics

Question type: True/False

1) The IDC is a linear process.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

2) Unstructured problems are fuzzy, complex problems for which there are no cut-and-dried solutions.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

3) A manager’s primary function is strategic planning.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

4) Decision-making is harder now than it was 20 years ago.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

5) The ratio between organizational inputs and outputs is an indication of the organization’s productivity.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

6) Modern information systems support all three managerial roles.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

7) In the choice phase of the decision-making process, managers construct a model that simplifies the problem.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

8) In the implementation phase of the decision-making process, managers set criteria for the evaluation of alternative potential solutions.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

9) The number of alternatives to be considered in decisions today is increasing.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

10) Structured decisions address routine, repetitive problems for which standard solutions exist.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

11) Human intuition often plays a role in making unstructured decisions.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

12) Unstructured decisions require a combination of standard solution procedures and individual judgement.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

13) Management control is the acquisition and efficient use of resources in accomplishing organizational tasks.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

14) The use of BI is limited to large corporations.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

15) Business intelligence (BI) is a broad category of applications, technologies, and processes for gathering, storing, accessing, and analyzing data to help business users make better decisions.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

16) BI only works in large organizations.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

17) BI can be used to transform the entire business.

Difficulty: Medium

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Comprehension

18) Sensitivity analysis studies the impact that changing outputs has on given inputs.

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

19) Targeted marketing is a good example of the discovery of previously unknown or hidden patterns.

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

20) Decision-support systems support only lower- and middle-level managers.

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

21) Goal-seeking analysis attempts to find the value of the inputs necessary to achieve a desired level of output.

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

22) With goal-seeking analysis, you have to know what you want as a result.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

23) A decision support system (DSS) is an interactive, computer-based system that facilitates finding solutions to semi-structured and unstructured problems.

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

24) Reality mining allows analysts to extract information from social networking sites.

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

25) CSFs are specific measures of KPIs.

Difficulty: Hard

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

26) An executive dashboard is very user-friendly, supported by graphics, provides exception reporting and drill down, and provides information related to critical success factors.

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

27) Executive dashboards provide support primarily to line managers.

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

28) Geographic Information Systems (GIS) are computer-based systems for capturing, integrating, manipulating, and displaying data using digitized maps.

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

29) KPI stands for key process information.

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

30) CSFs are qualitative while KPIs are quantitative.

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

31) Corporate performance management is involved with monitoring and managing an organization’s performance according to key performance indicators.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

32) Corporate performance management (CPM) is involved with monitoring and managing an organization’s performance according to its budget.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

33) BI can support organizational transformation.

Difficulty: Easy

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Knowledge

Question type: Multiple Choice

34) ConocoPhillips uses ________ to monitor _________ data.

a) dashboards; historical

b) dashboards; real-time

c) data warehouses; historical

d) data warehouses; real-time

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: Case 12.2 ConocoPhillips Uses Business Intelligence to Produce More Oil and Gas

AACSB: Information Technology

Bloomcode: Knowledge

35) ____________ is the process by which organizational goals are achieved through the use of organizational resources.

a) Organizational decision making

b) Operations

c) Organizational strategy

d) Organizational productivity

e) Management

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

36) Which of the following is not a basic role of managers?

a) Interpersonal

b) Entrepreneurial

c) Informational

d) Decisional

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

37) In the definition of management, the organization’s goals are considered _________.

a) input

b) process

c) output

d) none of the above

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

38) A monitor is an example of which managerial role?

a) Decisional

b) Informational

c) Interpersonal

d) Management

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

39) Decision makers construct a model for the situation in the ________ stage of the decision-making process.

a) choice

b) design

c) implementation

d) intelligence

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

40) _________ control involves decisions concerning acquiring and using resources efficiently in accomplishing organizational goals.

a) Management

b) Operational

c) Organizational

d) Strategic planning

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

41) Being a figurehead and leader is part of the ________ managerial role.

a) interpersonal

b) entrepreneurial

c) informational

d) decisional

e) confrontational

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

42) Being an entrepreneur, a disturbance handler, and a negotiator is part of the _________ managerial role.

a) interpersonal

b) entrepreneurial

c) informational

d) decisional

e) confrontational

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

43) In the _________ phase of the decision-making process, managers examine a situation and identify and define the problem.

a) implementation

b) choice

c) design

d) intelligence

e) consideration

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

44) In the ________ phase of the decision-making process, managers construct a model that simplifies the problem.

a) implementation

b) choice

c) design

d) intelligence

e) consideration

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

45) Success in the __________ phase of the decision-making process results in resolving the original problem, and failure leads to a return to previous phases.

a) implementation

b) choice

c) design

d) intelligence

e) consideration

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

46) In the _________ phase of the decision-making process, managers select a course of action that seems best suited to resolve the problem.

a) implementation

b) choice

c) design

d) intelligence

e) consideration

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

47) Which of the following is not a reason why managers need IT support?

a) The number of alternatives is decreasing.

b) Decisions must typically be made under time pressure.

c) Decisions are becoming more complex.

d) There is a growing need to access remote information sources.

e) Decision makers are often based in different locations.

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

48) Decisions today are becoming _______ complex, due to _______ uncertainty in the decision environment.

a) less, decreased

b) more, decreased

c) less, increased

d) more, increased

e) neither more nor less, decreased

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

49) Which of the following is not a characteristic of a structured decision?

a) It is routine.

b) It is repetitive.

c) Human intuition is not involved.

d) The first three phases of the decision-making process need not occur in any particular sequence.

e) Standard solutions exist.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

50) The type of decision that can be made by following a definite procedure is called a(n) ______ decision.

a) structured

b) unstructured

c) undocumented

d) semistructured

e) procedural

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

51) ________ decisions are more common at lower organizational levels.

a) Structured

b) Unstructured

c) Undocumented

d) Semistructured

e) Procedural

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

52) Rank-and-file employees tend to make more _________ decisions.

a) structured

b) unstructured

c) undocumented

d) semistructured

e) procedural

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

53) Calculating gross pay for hourly workers is an example of _________ decision making.

a) structured

b) unstructured

c) undocumented

d) semistructured

e) procedural

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

54) Which of the following is not a characteristic of unstructured decisions?

a) They are complex.

b) They typically are fuzzy and unclear.

c) Standard solutions exist.

d) Human intuition is involved.

e) The first three phases of the decision-making process occur in no particular sequence.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

55) When there is no well-understood or agreed-on procedure for making a decision, the decision is said to be:

a) undocumented

b) structured

c) unstructured

d) semistructured

e) documented

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

56) A large foreign automobile manufacturer is considering where to build a new manufacturing plant in Canada. The company is making which type of decision?

a) structured

b) semistructured

c) unstructured

d) informational

e) wisdom

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

57) Which type of decision requires a combination of standard solution procedures and individual judgement?

a) structured

b) semistructured

c) unstructured

d) informational

e) wisdom

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

58) A company’s annual employee evaluation best fits which type of decision?

a) unstructured

b) structured

c) semistructured

d) confrontational

e) wisdom

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

59) ___________ is the efficient and effective execution of specific tasks.

a) Operational control

b) Management control

c) Strategic planning

d) Expertise

e) Wisdom

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

60) ___________ is the acquisition and efficient use of resources in accomplishing organizational goals.

a) Operational control

b) Management control

c) Strategic planning

d) Expertise

e) Wisdom

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

61) Computer support is greatest for which of the following problems?

a) semistructured and strategic planning

b) unstructured and operational control

c) structured and operational control

d) semistructured and management control

e) structured and management control

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

62) Computer support is least for which of the following problems?

a) Semistructured and strategic planning

b) Unstructured and strategic planning

c) Semistructured and management control

d) Unstructured and operational control

e) Structured and strategic planning

Difficulty: Easy

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Knowledge

63) Elena is trying to decide whether she should expand her ice cream shop to a bigger space. She decides to be very methodical about it and follow the phases of the decision-making process she learned in university. Which of the following statements is true?

a) During the intelligence phrase, Elena will build a model using assumptions about the business.

b) During the design phrase, Elena will define the opportunity.

c) During the choice phase, Elena will lay out her options.

d) During the implementation phase, Elena will implement two of her solutions.

e) Elena will use test data to validate her model.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

64) _________ is an independent application for a specific functional area.

a) Business intelligence

b) A data mart

c) An enterprise data warehouse

d) An ERP

Difficulty: Medium

Learning Objective: Describe and provide examples of different ways in which organizations use business intelligence (BI).

Section Reference: 12.2 What Is Business Intelligence?

AACSB: Information Technology

Bloomcode: Comprehension

65) Multidimensional analysis is also called _____.

a) DSS

b) ERP

c) OLAP

d) OLTP

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

66) Environmental Systems Research Institute is an international supplier of ______.

a) AI

b) DSS

c) ERP

d) GIS

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: IT’s About Business 12.3 Geographic Information Systems Have Many Uses

AACSB: Information Technology

Bloomcode: Knowledge

67) Reality mining is a type of _____________.

a) dashboard

b) database

c) data mining

d) data visualization technology

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

68) Searching for valuable business information in a database, data warehouse, or data mart is referred to as ______________.

a) structured queries

b) database queries

c) data mining

d) query by example

e) expert system queries

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

69) __________ provides users with a view of what is happening, whereas __________ addresses why it is happening.

a) Multidimensional data analysis, structured query language

b) Data mining, multidimensional data analysis

c) Data mining, expert system

d) Multidimensional data analysis, neural networks

e) Multidimensional data analysis, data mining

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

70) Credit card companies would most likely use which of the following to check for fraudulent credit card use?

a) Data mining

b) Expert systems

c) Neural networks

d) Multidimensional data analysis

e) Structured query language

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

71) A company wants to use data from past promotional mailings to identify people who would likely respond favourably to future mailings. This company would most likely use:

a) Structured query language

b) Multidimensional data analysis

c) Neural networks

d) Expert systems

e) Data mining

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

72) ______ involves “slicing and dicing” data stored in a dimensional format, drilling down in the data to greater detail, and aggregating the data.

a) ERP

b) OLAP

c) OLTP

d) XML

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

73) _______ identifies what happened, whereas _______ explains why.

a) BI, data mining

b) BI, data warehousing

c) Data mining, BI

d) Data warehousing, BI

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

74) _________ analysis is the study of the impact of a change in the assumptions on the proposed solution.

a) Assumption

b) Goal-seeking

c) Sensitivity

d) What-if

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

75) The goal of ________ analysis is to see what you can get by changing some criteria.

a) assumption

b) goal-seeking

c) sensitivity

d) what-if

Difficulty: Hard

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

76) Which of the following is not a characteristic of DSSs?

a) They support only lower- and middle-level managers.

b) They are easy to use and construct.

c) They can adapt to changing conditions.

d) They usually utilize quantitative models.

e) They support all phases of the decision-making process.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

77) At the end of a semester, a student knows that she must achieve a grade of 81 or higher on her final exam to get an A in the course. She has just performed what kind of analysis?

a) What-if

b) Qualitative

c) Sensitivity

d) Goal-seeking

e) Simulation

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

78) ___________ attempts to find the value of the inputs necessary to achieve a desired level of output.

a) What-if analysis

b) Qualitative analysis

c) Sensitivity analysis

d) Goal-seeking analysis

e) Simulation

Difficulty: Easy

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Knowledge

79) Which of the following is not a characteristic of organizational decision support systems?

a) They affect multiple organizational units or corporate issues.

b) They cut across organizational functions or hierarchical layers.

c) They involve computer-based technologies.

d) They are standalone systems.

e) They involve communications technologies.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

80) The colour _______ in the Management Cockpit represents performance of internal processes and employees.

a) black

b) blue

c) red

d) white

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

81) Sally is working for her uncle for the summer in the marketing department of Proctor & Gamble. She tells you she does data mining all day long. Which of the following statements is false?

a) Data mining can be used to prove assumptions.

b) Data mining is used to identify unknown patterns.

c) Data mining can explain why things happened.

d) Data mining can predict what will happen.

e) Data mining can be used to identify customers.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

82) Shawn is doing some budgeting for his new start-up business. He has developed a budget in Excel using formulas, as he was taught to do in university. Which of the following statements is true?

a) If Shawn changes one of his assumptions, Excel will automatically recalculate the budget numbers.

b) Shawn would use sensitivity analysis to check the impact of changing his price.

c) Shawn would use roll-up to review his summary numbers.

d) Shawn would use what-if analysis to check the impact of changing his price and the commission he pays his sales people.

e) Shawn would use goal-seeking analysis to examine the impact of changing his forecast of units sold.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

83) A(n) ____________ provides rapid access to timely information and direct access to management reports.

a) decision support system

b) expert system

c) neural network

d) digital dashboard

e) data warehouse

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

84) Dashboards are typically targeted at _________.

a) middle managers

b) operational managers

c) tactical managers

d) top executives

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

85) ____________ is one feature of dashboards that enables users to get details, and details of details, of information.

a) Consolidation

b) Detailed

c) Drill-down

d) Status access

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

86) Which capability of digital dashboards enables users to obtain the latest data available on key performance indicators or some other metric, ideally in real time?

a) Drill-down

b) Key performance indicators

c) Status access

d) Trend analysis

e) Exception reporting

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

87) Which of the following information systems are very user-friendly, supported by graphics, and provide exception reporting and drill down?

a) Decision support systems

b) Digital dashboards

c) Functional area information systems

d) Group decision support systems

e) Expert systems

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

88) Digital dashboards provide all of the following capabilities except:

a) Drill-down

b) Transaction processing

c) Status access

d) Key performance indicators

e) Exception reporting

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

89) The Management Cockpit best exemplifies which type of system?

a) Decision support system

b) Expert system

c) Digital dashboard

d) Functional area information system

e) Group decision support system

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

90) The primary distinguishing characteristic of geographical information systems is:

a) Every record or digital object has a unique identifier.

b) Every record or digital object is visible to the user.

c) Every record or digital object must be accessed by programmers.

d) Every record or digital object has an identified geographical location.

e) Every record or digital object is encrypted.

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

91) Geocoding involves:

a) Integrating maps with spatially oriented databases and other databases

b) Encrypting spatial information

c) Accessing geographical information

d) Integrating organizational transactions with spatially oriented databases

e) Programming spatially oriented databases

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

92) Today, geographical information systems are being combined with __________ to form geospatial technologies.

a) dashboards

b) global positioning systems

c) decision support systems

d) expert systems

e) neural networks

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

93) Tony is working for the CEO of a small company. She asks him to develop a dashboard. Tony starts thinking about the questions he needs to ask. Which of the following questions is not on his list?

a) How many levels do you wish to drill down?

b) What are your key performance indicators?

c) Do you need real-time data?

d) Do you want graphs and charts or text?

e) Should it run on your iPhone?

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these technologies.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

94) Which of the following is an example of a CSF?

a) Average customer spending

b) Creating high quality products

c) Number of product returns

d) Turnover rates of employees

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

95) Which of the following is an example of a KPI?

a) Create high-quality products

b) Number of new customers

c) Reduce product costs

d) Retain competitive advantages

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

96) ___________ is the short-, medium-, and long-term trends of metrics, which is projected using forecasting methods.

a) CSF

b) Drill-down

c) KPI

d) Trend analysis

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

97) Status access is the latest data available on ________, often in real time.

a) CRM

b) CSF

c) ERP

d) KPI

Difficulty: Easy

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Knowledge

Question type: Essay

98) Describe the three major roles of managers.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

99) Explain why managers need IT support.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

100) Discuss the information technologies that are available to support managers.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

101) Describe the phases in the decision-making process.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

102) Describe OLAP, and explain what a data cube is.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

103) Explain data mining, using examples.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

104) Explain how what-if analysis is employed, using examples.

Difficulty: Medium

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

105) Explain what data visualization technologies are, using examples.

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

106) Describe how your university could use a decision support system in its admissions process.

Difficulty: Hard

Learning Objective: Specify the BI applications available to users for data analysis, and provide examples of how each application can be used to solve a business problem at your university.

Section Reference: 12.3 Business Intelligence Applications for Data Analysis

AACSB: Information Technology

Bloomcode: Comprehension

107) Discuss the structure of problems, the nature of decisions, and the framework for computerized decision analysis.

Difficulty: Medium

Learning Objective: Identify the phases in the decision-making process, and use a decision support framework to demonstrate how technology supports managerial decision making.

Section Reference: 12.1 Managers and Decision Making

AACSB: Information Technology

Bloomcode: Comprehension

108) Describe how your university could use a geographical information system in its admissions process. What value could your university gain from using such a system?

Difficulty: Hard

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

109) List and describe the capabilities of dashboards. Assuming you are the CEO of your campus bookstore, draw a dashboard that you would like to see. HINT: Think about what kind of information you would want to see to make decisions as a CEO.

Difficulty: Medium

Learning Objective: Describe three BI applications that present the results of data analyses to users, and offer examples of how businesses and government agencies can use each of these applications.

Section Reference: 12.4 Business Intelligence Applications for Presenting Results

AACSB: Information Technology

Bloomcode: Comprehension

Legal Notice

Copyright © 2016 by John Wiley & Sons Canada, Ltd. or related companies. All rights reserved.

The data contained in these files are protected by copyright. This manual is furnished under licence and may be used only in accordance with the terms of such licence.

The material provided herein may not be downloaded, reproduced, stored in a retrieval system, modified, made available on a network, used to create derivative works, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise without the prior written permission of John Wiley & Sons Canada, Ltd.