ISM 4011 EXAM 3 (CH 9-12) VERIFIED STUDY GUIDE
Business Intelligence (BI) Systems - Answers - Are information systems that process
operational and other data to analyze past performance to make predictions
Business Intelligence (BI) - Answers - The patterns, relationships, and trends identified
by BI systems
Typical uses for BI: - Answers - - Identifying changes in purchasing patterns
- Entertainment: buyers will say they want one thing but purchase something else
- Predictive policy: analytical techniques in law enforcement to identify potential criminal
activity
Types of data and how it is acquired: - Answers - - Informing
- Decision-making
- Problem-solving
- Project mangement
3 primary activities in the BI process: - Answers - 1) Data acquisition
2) BI analysis
3) Publish results
Data acquisition - Answers - The process of obtaining, cleaning, organizing, relating,
and cataloging source data ; what needs to be done?
BI analysis - Answers - The process of creating business intelligence: Reporting, data
mining, BigData ; how is it made useful?
Publish results - Answers - The process of delivering business intelligence to the
knowledge workers who need it: Print, web servers, report servers, automation ; how is
it given to users?
Push publishing - Answers - Delivers business intelligence to users without any request
from the users
Pull publishing - Answers - Requires the user to request BI results
Data warehouse - Answers - A facility for managing an organization's BI data ;
"distributor"
Functions of a Data Warehouse: - Answers - - Obtain data: extract data from
operational, internal and external databases
- Cleanse data
, - Organize, relate data warehouse
- Catalog data using metadata
Data mart - Answers - Is a data collection, smaller than the data warehouse, that
addresses the needs of a particular department or functional area of the business ;
"retail store for the distributor"
Problems with source data: - Answers - - Dirty data: problematic data
- Missing values/elements
- Inconsistent data
- Data not integrated
- Wrong granularity (too fine, not fine enough)
- Too much data (too many attributes, too many data points)
BigData - Answers - A term used to describe data collections that are characterized by
huge volume, rapid velocity, and great variety
ETL - Answers - - Extraction: get the data
- Transformation: make it useable
- Loading: save it to the warehouse
3 techniques for processing BI data: - Answers - 1. Reporting: create information about
past performance
2. Data mining: classify and predict
3. BigData: characterize the volume, velocity, and variety of data collections
"Dirty data" - Answers - Inaccurate, incomplete or inconsistent data, especially in a
computer system or database
2 Functions of BI server: - Answers - 1. Management: maintains metadata about the
authorized allocation of BI results to users
2. Delivery
Systems development - Answers - The process of creating and maintaining information
systems
Challenges in system development: - Answers - - The difficulty of determining
requirements
- Changes in requirements
- Difficulties involving scheduling and budgeting
- Changing technology
- Diseconomies of scale
Brooke's Law - Answers - "Adding more people to a late project makes the project
later."
Business Intelligence (BI) Systems - Answers - Are information systems that process
operational and other data to analyze past performance to make predictions
Business Intelligence (BI) - Answers - The patterns, relationships, and trends identified
by BI systems
Typical uses for BI: - Answers - - Identifying changes in purchasing patterns
- Entertainment: buyers will say they want one thing but purchase something else
- Predictive policy: analytical techniques in law enforcement to identify potential criminal
activity
Types of data and how it is acquired: - Answers - - Informing
- Decision-making
- Problem-solving
- Project mangement
3 primary activities in the BI process: - Answers - 1) Data acquisition
2) BI analysis
3) Publish results
Data acquisition - Answers - The process of obtaining, cleaning, organizing, relating,
and cataloging source data ; what needs to be done?
BI analysis - Answers - The process of creating business intelligence: Reporting, data
mining, BigData ; how is it made useful?
Publish results - Answers - The process of delivering business intelligence to the
knowledge workers who need it: Print, web servers, report servers, automation ; how is
it given to users?
Push publishing - Answers - Delivers business intelligence to users without any request
from the users
Pull publishing - Answers - Requires the user to request BI results
Data warehouse - Answers - A facility for managing an organization's BI data ;
"distributor"
Functions of a Data Warehouse: - Answers - - Obtain data: extract data from
operational, internal and external databases
- Cleanse data
, - Organize, relate data warehouse
- Catalog data using metadata
Data mart - Answers - Is a data collection, smaller than the data warehouse, that
addresses the needs of a particular department or functional area of the business ;
"retail store for the distributor"
Problems with source data: - Answers - - Dirty data: problematic data
- Missing values/elements
- Inconsistent data
- Data not integrated
- Wrong granularity (too fine, not fine enough)
- Too much data (too many attributes, too many data points)
BigData - Answers - A term used to describe data collections that are characterized by
huge volume, rapid velocity, and great variety
ETL - Answers - - Extraction: get the data
- Transformation: make it useable
- Loading: save it to the warehouse
3 techniques for processing BI data: - Answers - 1. Reporting: create information about
past performance
2. Data mining: classify and predict
3. BigData: characterize the volume, velocity, and variety of data collections
"Dirty data" - Answers - Inaccurate, incomplete or inconsistent data, especially in a
computer system or database
2 Functions of BI server: - Answers - 1. Management: maintains metadata about the
authorized allocation of BI results to users
2. Delivery
Systems development - Answers - The process of creating and maintaining information
systems
Challenges in system development: - Answers - - The difficulty of determining
requirements
- Changes in requirements
- Difficulties involving scheduling and budgeting
- Changing technology
- Diseconomies of scale
Brooke's Law - Answers - "Adding more people to a late project makes the project
later."
