Chapter 9 Flashcards

1
Q

Business intelligence systems

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

business intelligence

A

the patterns, relationships, and trends identified by BI systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

BI application

A

the software component of a BI system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Example of BI (project management)

A

create a partnership program between clients and employees

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Example of BI (problem solving)

A

How can we increase revenue?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Example of BI (deciding)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Example of BI (informing)

A

How do our sales compare to our sales forecast?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Typical uses of BI

A
  1. identifying changes in consumer purchasing patterns
  2. entertainment (Amazon, Netflix, Spotify)
  3. Predictive policing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

predictive policing

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data aquisition

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

BI analysis

A

process of creating BI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Push publishing

A

delivers BI to users without any request from the users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Pull publishing

A

requires the user to request BI results

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

data warehouse

A

a facility for managing an organization’s BI data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

functions of a data warehouse

A
  • obtain data
  • cleanse data
  • organize and relate data
  • catalog data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

YES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are some problems with operational data?

A
  • dirty data
  • missing values
  • inconsistent data
  • too much data
  • wrong granularity
18
Q

granularity

A

the level of detail represented by the data

19
Q

data mart

A

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

20
Q

data mart v. data warehouse

A

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

21
Q

Three types of BI Analysis

A

reporting
data mining
BigData

22
Q

reporting analysis

A

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

23
Q

structured data

A

data in the form of rows and columns

24
Q

exception reports

A

reports produced when something out of the predefined bounds occurs

25
Q

goal of BI analysis - reporting

A

create information about the past

26
Q

goal of BI analysis - data mining

A

classify and predict

27
Q

goal of BI analysis - BigData

A

find patterns and relationships in BIgData

28
Q

characteristics of reporting

A

process structured data by sorting, grouping, etc.

29
Q

characteristics of data mining

A

use sophisticated statistical techniques to find patterns and relationships

30
Q

characteristics of BigData

A

volume, velocity, and variety force

31
Q

data mining

A

application of statistical techniques to find patterns and relationships among data

32
Q

unsupervised data mining

A

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

33
Q

cluster analysis

A

identify groups of data with similar characteristics

34
Q

supervised data mining

A

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

35
Q

regression analysis

A

measures the impact of a set of variables on another variable

36
Q

MapReduce

A

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

37
Q

Hadoop

A

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

38
Q

static reports

A

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

39
Q

dynamic reports

A

BI documents that are update at the time they are requested

40
Q

BI server

A

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

41
Q

example of BI server

A

Microsoft SQL Server Report manager

42
Q

Two major functions of BI server

A

management

delivery