OTM ch 7
basic reporting operations
1. Sorting 2. Filtering 3. Grouping 4. Calculating 5. Formatting
business intelligence systems have 5 standard components
1. hardware 2. softwarw 3. data 4. procedures 5. people
Content Management System (CMS)
A document management system that includes images, multimedia files, and other content in addition to conventional documents.
unsupervised data mining
Analysts do not create a model or hypothesis before running the analysis.
data warehouse DBMS
Extracts and provides data to BI applications
BI analysis
The process of creating business intelligence. The four fundamental categories of BI analysis are reporting, data mining, BigData, and knowledge management.
reporting application
a BI application that inputs data from one or more sources and applies reporting operations to that data to produce business intelligence
decision tree
a hierarchical arrangement of criteria that predict a classification or a value
rfm analysis
a way of analyzing and ranking customers according to their purchasing patterns
OLAP (online analytical processing)
ability to sum count average and perform simple numeric/arithmetic operations on groups of data
3 primary activities in the bi process
acquire data, perform analysis, publish results
market basket analysis
an unsupervised data mining technique for determining sales patterns; ex categorizing customers using their co-purchase behavior and recommending appropriate products
difference between bi users and knowledge workers
bi users are generally specialists in data analysis, knowledge workers are often non specialist uses of bi results
dimension
characteristic of a measure
data mart
contains a subset of data warehouse information
Metadata
data about data, it's source, it's format, it's assumptions and constraints and other facts about the data kept in a data warehouse metadata database
measure
data item of interest
supervised data mining
data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model
neural networks
data mining application used to predict values and make classifications such as "good prospect" or "poor prospect" customers
push publishing
delivers business intelligence to users without any request from the users
problems w operational data
dirty data, missing data, inconsistent data, data is not integrated, wrong granularity, too much data
how Knowledge Management (KM) benefits organizations
improve process quality, increase team strength
business intelligence systems
information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals and knowledge worked
functions of a data warehouse
obtain data, cleanse data, organize and relate data, catalog data
knowledgement management
process of creating value from intellectual capital and sharing that knowledge w employees, managers, suppliers, customers, and others who need capital
pull publishing
requires the user to request BI results
expert systems
rule-based systems that encode human knowledge in the form of if/then rules
cluster analysis
statistical techniques identify groups of entities that have similar characteristics (unsupervised)
regression analysis
supervised technique
data mining
the application of statistical techniques to find patterns and relationships among data for classification and prediction
business intelligence
the patterns, relationships, and trends identified by BI systems
publish results
the process of delivering business intelligence to the knowledge workers who need it
data acquisition
the process of obtaining, cleaning, organizing, relating, and cataloging source data