Chapter 12 Sections Q1-Q4: Business Intelligence

Chapter 12 Sections Q1-Q4: Business Intelligence
Chapter 13 Sections Q2-Q4: Knowledge Mgmt
Chapter 14 All Sections: Database Marketing
Chapter 15 Sections Q1 & Q4: OLAP
Business
Intelligence
Expert
Systems
Reporting
Knowledge
Management
Data Mining

Define business intelligence systems.

Know the characteristics of reporting systems.

Know the purpose and role of data warehouses and
data marts.

Understand fundamental data-mining techniques.

Know the purpose, features, and functions of
knowledge management systems.


Q1: How Big is an Exatype?
Q3: What Problems do Operational Data
Pose?

software that searches vast amounts of data
to derive information for improved decision
making

Reporting

Data Mining

Knowledge Management

Expert Systems

software that reads data

processes data by:
◦
◦
◦
◦

filtering
sorting
grouping
simple calculations
produces formatted summaries of data

On-Line Analytical Processing
◦ Drill-Down
◦ Consolidation
◦ Slicing and Dicing
Report A
Report B

Large Database

Subject-Oriented

Integrated

Time-Variant

Nonvolatile

User-Friendly Interface
Reporting
Operational
DB
External
DB
Data
Warehouse
Data
Mining
KM
Other
DB
Expert



Mini data warehouses
Hold subsets of data from the data
warehouse
Data focuses on a specific aspect of the
company

software that searches through data

uses complex statistical calculations

outputs
◦
◦
◦
◦
Trends
Patterns
Correlations
Exceptions

Nestle processes Social Media
http://uk.reuters.com/article/video/idUKBRE89P07Q
20121026?videoId=238680321



Process
Creating Value from
Intellectual Property
Sharing Knowledge
with Others
http://answers.vt.edu/kb/entry/3354/

Knowledge captured as rules.
www.lpa.co.uk/wfs_dem6.htm

Poor data quality

Context

User resistance
`