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