Deck 9: Business Intelligence

Question 1

The key to the quick responsiveness of OLAP processing is the pre-aggregation of detailed data into useful summaries of data in anticipation of questions that might be raised.

Answer 1

True

Question 2

Data repository creation begins with an ETL process to create an appropriate set of data to support the data mining technique to be used.

Answer 2

True

Question 3

Data marts must be designed from scratch as a complete,individual,miniature data warehouse.

Answer 3

False

Question 4

Some organizations have multiple data marts,each designed to meet the needs of a different organizational business unit.

Question 5

Organizations increasingly are prohibiting or at least limiting the amount and kinds of critical data that is stored on laptops to prevent the loss of secret and important information.

Question 6

Data cubes are restricted to three dimensions.

Question 7

If the data within a data cube has been summarized at a given level,it is possible to use that data cube to answer questions at a more detailed level.

Question 8

Many companies update their data warehouse on a yearly basis.

Question 9

In the Balanced Scorecard,the customer perspective defines those internal business processes that indicate how well the business is running and whether its products and services are meeting customer requirements.

Question 10

In the Balanced Scorecard,the learning and growth perspective identifies what must be done from the customer's perspective in order to meet organizational objectives using measures such as percent of on-time deliveries.

Question 11

The data in a data warehouse typically comes from numerous operational systems and external data sources.

Question 12

An effective ETL process is essential to ensure data warehouse success.

Question 13

Many of the reporting and querying tools enable end users to make their own data requests and format the results without the need for additional help from the IT organization.

Question 14

The process of data mining consists of two primary processes: data repository creation and deployment.

Question 15

The most widely used BI software comes from Jasper,Pentaho,and Microsoft.

Question 16

The data used in BI is often pulled one centralized database and is internally generated.

Question 17

The ETL process is generally run once per day.

Question 18

Sometimes a data mart is simply created by extracting,transforming,and loading a portion of the data in a data warehouse.

Question 19

Organizations must be extremely careful to protect the data they use in their BI applications.

Question 20

In the Balanced Scorecard,the financial perspective defines the long-term strategic objectives of the organization in traditional financial terms using measures such as revenue growth,costs,profit margins,cash flow,and net operating income.

Question 21

Data warehouses frequently hold a huge amount of data-often containing ____ years or more of data.

A) three
B) four
C) five
D) six

Question 22

A wide range of options for displaying results in a dashboard include maps,gauges,bar charts,trend lines,scatter diagrams,and other representations.

Question 23

The ____ is responsible for administering U.S.election laws regarding campaign funding.

A) Federal Trade Commission (FTC)
B) Federal Commerce Commission (FCC)
C) Federal Funding Association (FFA)
D) Federal Election Commission (FEC)

Question 24

End users can even employ tools such as the ____ to find the optimal solution to a problem with multiple constraints.

A) Excel scenario manager
B) Excel Solver
C) Excel Resolver
D) Excel Analyzer

Question 25

A(n)____ process is used to pull data from these disparate data sources to populate and maintain the data warehouse.

A) transform-load-extract
B) extract-load-transform
C) transform-extract-load
D) extract-transform-load

Question 26

____ involves the interactive examination of high level,summary data in increasing detail to gain insight into certain elements-sort of like slowly peeling off the layers of an onion to reach the core.

A) Drill-through analysis
B) Drill-down analysis
C) Drill analysis
D) Drill-up analysis

Question 27

End users can even employ tools such as the ____ to perform "what if" analysis to evaluate various alternatives.

A) Excel scenario manager
B) Excel data manager
C) Excel scenario analyzer
D) Excel scenario migration

Question 28

The Federal Transportation Security Administration (TSA)implemented a BI system called the ____ to manage more effectively and schedule its workers.

A) Performance Management System (PMS)
B) Performance Information Management System (PIMS)
C) Performance Indicator Management System (PIMS)
D) Performance System Manager (PSM)

Question 29

Data _____ can be built to summarize unit sales of a specific item on a specific day for a specific store.

A) marts
B) squares
C) matrices
D) cubes

Question 30

Organizations often employ ____ to make predictions about future conditions and then make adjustments in staffing,purchasing,financing,and other operational areas to better meet forecasted needs.

A) BI
B) BE
C) DI
D) CI

Question 31

A data ____ is a database that stores large amounts of historical data in a form that readily supports analysis and management decision making.

A) warehouse
B) storehouse
C) store
D) analytics repository

Question 32

Dashboards are simple tools used to provide entry level personnel of the organization the information they need to make decisions.

Question 33

The ____ step in the ETL process updates the existing data warehouse with the data that have passed through the extract and transform steps.

A) extract
B) transform
C) load
D) log

Question 34

Effective use of a Balanced Scorecard can provide greater customer satisfaction,improved financial results,more effective information systems and business processes,and more motivated and better educated employees.

Question 35

Insight designer BPM software typically employs an intuitive,easy-to-use graphical user interface for business users to apply to design the process.

Question 36

Reporting and insight BPM software provides a wide range of BI capabilities such as trend analysis and drill-down analysis for users to gain complete visibility across all of an organization's business processes.

Question 37

____ is a BI tool used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

A) Data mining
B) Data polling
C) Data analyzing
D) Data managing

Question 38

____ is a method to analyze multidimensional data from many different perspectives.

A) Online transaction processing
B) Online database processing
C) Online analytical processing
D) Online transaction analysis

Question 39

____ includes a wide range of applications,practices,and technologies for the extraction,translation,integration,analysis,and presentation of data to support improved decision making.

A) Data intelligence
B) Data warehousing
C) Business intelligence
D) Business data

Question 40

In the retail industry,____ is used to help firms to predict better customer demand and maximize sales.

A) OLAP
B) OLTP
C) OLPA
D) OLPT

Question 41

The ____________________ step in the ETL process is designed to access the various sources of data and pull from each source the data desired to update the data warehouse.

Question 42

In the ___________________ step in the ETL process,the data that will be used to update the data warehouse is edited and,if necessary,converted to a compatible format.

Question 43

When using the Plan-Do-Check-Act process,the problem-solving team selects the problem to be analyzed,clearly defines the problem,sets a measurable goal for the problem-solving effort,and gathers further data related to the problem in the ____ step.

A) Plan
B) Do
C) Check
D) Act

Question 44

________________________________________ can be used to model work processes and predict future performance under various what-if scenarios.

Question 45

When using the Plan-Do-Check-Act process,the problem-solving team establishes criteria for selecting a solution,generates solution alternatives,selects a solution,and plans how to implement the solution in the ____ step.

A) Plan
B) Do
C) Check
D) Act

Question 46

A data ___________________ is a smaller version of a data warehouse-scaled down to meet the specific needs of a business unit.

Question 47

Often the data analyzed by BI software comes from the vast amount of operational information captured by a company's ____________________ systems.

Question 48

____________________ mining is the study of human interaction based on data gathered from mobile phones and other portable communicating devices.

Question 49

____ is an application of BI that enables the continuous and real-time analysis of operational data to measure actual performance and forecast future performance.

A) Business performance monitoring
B) Business performance analysis
C) Business performance management
D) Business performance observation

Question 50

Most organizations have invested in some ___________________ tools to help their employees get the data they need to solve a problem or identify an opportunity.

Question 51

____ BPM software gather data from a business process and provide reports and dashboards to create actionable information.

A) Process efficiency monitoring
B) Reporting and design
C) Reporting and insight
D) Workflow designer

Question 52

BI tools frequently operate on data stored in a data warehouse or data ____________________.

Question 53

In the Balanced Scorecard,the ____ perspective describes the employee training and corporate cultural attitudes required for both individual and corporate self-improvement.

A) Financial
B) Customer
C) Business Process
D) Learning and Growth

Question 54

When using the Plan-Do-Check-Act process,the problem-solving team identifies systemic changes and training needs to ensure a full,successful implementation of the solution in the ____ step.

A) Plan
B) Do
C) Check
D) Act

Question 55

____ involves trying various models and selecting the best one based on its ability to explain the variability in the existing data.

A) Pattern management
B) Pattern observation
C) Pattern recognition
D) Pattern identification

Question 56

____ BPM software provides built-in application programming interfaces to connect with each of the systems that a company uses to support a particular process and then monitors the process to identify bottlenecks and inefficiencies.

A) Process efficiency monitoring
B) Reporting and design
C) Reporting and insight
D) Workflow designer

Question 57

Business managers often import data into a(n)____________________ program,which then can perform operations on the data based on formulas created by the end user.

Question 58

Databases built to support OLAP processing consist of data ____________________ that contain numeric facts called measures.

Question 59

____ creates improved feedback loops for the critical processes of the organization so that problems can be identified and eliminated before they become serious.

A) Business performance management
B) Business performance monitoring
C) Business performance analysis
D) Business performance observation

Question 60

The ____ is a performance management tool used to track performance over time,communicate and drive organizational strategy,identify strategic initiatives,and conduct periodic performance reviews to assess if goals are being met.

A) Scorecard
B) Balanced Scorecard
C) Business Scorecard
D) Management Scorecard

Question 61

What is online analytical processing (OLAP)?

Question 62

Measures are ___________________ that track progress in executing chosen strategies to attain organizational objectives and goals.

Question 63

List and discuss the steps in an effective process for applying BMP.

Question 64

Identify some privacy concerns associated with data mining.

Question 65

When using the Plan-Do-Check-Act process,data is gathered to see if the implemented solution has solved the problem and achieved the desired goal in the ___________________ step.

Question 66

Why are spreadsheets useful?

Question 67

____________________ designer BPM software enables business managers and analysts to design a business process complete with all of the associated forms,business rules,role definitions,and integration to other systems involved in the process.

Question 68

A key idea behind the Balanced ___________________ is that financial measures tend to be lag measures,which are difficult to influence directly without addressing issues in the other three perspectives.

Question 69

Digital ____________________ present a set of key performance indicators about the state of a process at a specific point in time.

Question 70

Discuss business performance management.