ISDS 415 Midterm Study Guide

What are the four major components of a Business Intelligence (BI) system?

1. A data warehouse, with its source data 2. Business analytics, a collection of tools for manipulating, mining, and analyzing the data in the data warehouse 3. Business performance management (BPM) for monitoring and analyzing performance 4. A user interface (e.g., a dashboard)

Fundamental reasons for investing in BI must be ____________ with the company's business strategy.

Aligned

________ is an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies.

Business Intelligence

The user interface of a BI system is often referred to as a(n) ________________.

Dashboard

A(n) _____________ is a major component of a Business Intelligence (BI) system that holds source data.

Data warehouse

T/F - Business intelligence (BI) is a specific term that describes architectures and tools only.

False

T/F - Major commercial business intelligence (BI) products and services were well established in the early 1970s.

False

T/F - Successful BI is a tool for the information systems department, but is not exposed to the larger organization.

False

T/F - The growth in hardware, software, and network capacities has had little impact on modern BI innovations.

False

T/F - Traditional BI systems use a large volume of static data that has been extracted, cleansed, and loaded into a data warehouse to produce reports and analyses.

True

An(n) _______ is a major component of Business Intelligence (BI) system is often browser based and often presents a portal or dashboard.

User Interface

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically a. an integral subsystem of an online analytical processing (OLAP) system. b. a distinct system that provides storage for data that will be made use of in analysis. c. the end result of BI processes and operations. d. a repository of actionable intelligence obtained from a data mart.

a distinct system that provides storage for data that will be made use of in analysis.

The very design that makes an OLTP system efficient for transaction processing makes it inefficient for a. the collection of reputable sources of intelligence. b. transactions such as ATM withdrawals, where we need to reduce a bank balance accordingly. c. transaction processing systems that constantly update operational databases. d. end-user ad hoc reports, queries, and analysis. d. end-user ad hoc reports, queries, and analysis.

end-user ad hoc reports, queries, and analysis.

T/F - BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives.

false

The competitive imperatives for BI include all of the following EXCEPT: a. right time b. right information c. right place d. right user

right user