Chapter 9

Question 1

Business intelligence systems

Answer 1

information systems that process operational and other data to analyze past performance and to make predictions

Question 2

business intelligence

Answer 2

the patterns, relationships, and trends identified by BI systems

Question 3

BI application

Answer 3

the software component of a BI system

Question 4

Example of BI (project management)

Answer 4

create a partnership program between clients and employees

Question 5

Example of BI (problem solving)

Answer 5

How can we increase revenue?

Question 6

Example of BI (deciding)

Answer 6

Which product creates the most revenue? decide to produce more of that product

Question 7

Example of BI (informing)

Answer 7

How do our sales compare to our sales forecast?

Question 8

Typical uses of BI

Answer 8

1. identifying changes in consumer purchasing patterns
2. entertainment (Amazon, Netflix, Spotify)
3. Predictive policing

Question 9

predictive policing

Answer 9

analyzing data on past crimes to predict where crimes are likely to occur in the future

Question 10

Data aquisition

Answer 10

process of obtaining, cleaning, organizing, relating, and cataloging source data

Question 11

BI analysis

Answer 11

process of creating BI

Question 12

Push publishing

Answer 12

delivers BI to users without any request from the users

Question 13

Pull publishing

Answer 13

requires the user to request BI results

Question 14

data warehouse

Answer 14

a facility for managing an organization’s BI data

Question 15

functions of a data warehouse

Answer 15

• obtain data
• cleanse data
• organize and relate data
• catalog data

Question 16

Can a company use a different DBMS for organizational and data warehouse databases?

Answer 16

YES

Question 17

What are some problems with operational data?

Answer 17

• dirty data
• missing values
• inconsistent data
• too much data
• wrong granularity

Question 18

granularity

Answer 18

the level of detail represented by the data

Question 19

data mart

Answer 19

a data collection, smaller than a data warehouse, that addresses the needs of a particular department or functional area of the business

Question 20

data mart v. data warehouse

Answer 20

A data warehouse acts as a distributor in the supply chain. The data mart acts as a retail store in the supply chain

Question 21

Three types of BI Analysis

Answer 21

reporting
data mining
BigData

Question 22

reporting analysis

Answer 22

process of sorting, grouping, summing, filtering, and formatting structured data

Question 23

structured data

Answer 23

data in the form of rows and columns

Question 24

exception reports

Answer 24

reports produced when something out of the predefined bounds occurs

Question 25

goal of BI analysis - reporting

Answer 25

create information about the past

Question 26

goal of BI analysis - data mining

Answer 26

classify and predict

Question 27

goal of BI analysis - BigData

Answer 27

find patterns and relationships in BIgData

Question 28

characteristics of reporting

Answer 28

process structured data by sorting, grouping, etc.

Question 29

characteristics of data mining

Answer 29

use sophisticated statistical techniques to find patterns and relationships

Question 30

characteristics of BigData

Answer 30

volume, velocity, and variety force

Question 31

data mining

Answer 31

application of statistical techniques to find patterns and relationships among data

Question 32

unsupervised data mining

Answer 32

analysts do not create a model or hypothesis before running the analysis

Question 33

cluster analysis

Answer 33

identify groups of data with similar characteristics

Question 34

supervised data mining

Answer 34

data miners develop a model prior to the analysis of the data

Question 35

regression analysis

Answer 35

measures the impact of a set of variables on another variable

Question 36

MapReduce

Answer 36

Map - BigData is broken into pieces, and hundreds of thousands of independent processors search these pieces for something of interest Reduce - the results from the mapping phase combined

Question 37

Hadoop

Answer 37

an open source program supported by the Apache Function that manages thousands of computers and that implements the MapReduce

Question 38

static reports

Answer 38

BI documents that are fixed at a time and do not change

Question 39

dynamic reports

Answer 39

BI documents that are update at the time they are requested

Question 40

BI server

Answer 40

a web server application that is purpose-built for the publishing of business intelligence

Question 41

example of BI server

Answer 41

Microsoft SQL Server Report manager

Question 42

Two major functions of BI server

Answer 42

management | delivery