Chapter 9 Flashcards
Business intelligence systems
information systems that process operational and other data to analyze past performance and to make predictions
business intelligence
the patterns, relationships, and trends identified by BI systems
BI application
the software component of a BI system
Example of BI (project management)
create a partnership program between clients and employees
Example of BI (problem solving)
How can we increase revenue?
Example of BI (deciding)
Which product creates the most revenue? decide to produce more of that product
Example of BI (informing)
How do our sales compare to our sales forecast?
Typical uses of BI
- identifying changes in consumer purchasing patterns
- entertainment (Amazon, Netflix, Spotify)
- Predictive policing
predictive policing
analyzing data on past crimes to predict where crimes are likely to occur in the future
Data aquisition
process of obtaining, cleaning, organizing, relating, and cataloging source data
BI analysis
process of creating BI
Push publishing
delivers BI to users without any request from the users
Pull publishing
requires the user to request BI results
data warehouse
a facility for managing an organization’s BI data
functions of a data warehouse
- obtain data
- cleanse data
- organize and relate data
- catalog data
Can a company use a different DBMS for organizational and data warehouse databases?
YES
What are some problems with operational data?
- dirty data
- missing values
- inconsistent data
- too much data
- wrong granularity
granularity
the level of detail represented by the data
data mart
a data collection, smaller than a data warehouse, that addresses the needs of a particular department or functional area of the business
data mart v. data warehouse
A data warehouse acts as a distributor in the supply chain. The data mart acts as a retail store in the supply chain
Three types of BI Analysis
reporting
data mining
BigData
reporting analysis
process of sorting, grouping, summing, filtering, and formatting structured data
structured data
data in the form of rows and columns
exception reports
reports produced when something out of the predefined bounds occurs
goal of BI analysis - reporting
create information about the past
goal of BI analysis - data mining
classify and predict
goal of BI analysis - BigData
find patterns and relationships in BIgData
characteristics of reporting
process structured data by sorting, grouping, etc.
characteristics of data mining
use sophisticated statistical techniques to find patterns and relationships
characteristics of BigData
volume, velocity, and variety force
data mining
application of statistical techniques to find patterns and relationships among data
unsupervised data mining
analysts do not create a model or hypothesis before running the analysis
cluster analysis
identify groups of data with similar characteristics
supervised data mining
data miners develop a model prior to the analysis of the data
regression analysis
measures the impact of a set of variables on another variable
MapReduce
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
Hadoop
an open source program supported by the Apache Function that manages thousands of computers and that implements the MapReduce
static reports
BI documents that are fixed at a time and do not change
dynamic reports
BI documents that are update at the time they are requested
BI server
a web server application that is purpose-built for the publishing of business intelligence
example of BI server
Microsoft SQL Server Report manager
Two major functions of BI server
management
delivery
