CHAPTER 9

ENABLING THE ORGANIZATION - DECISION MAKING

 

 

DECISION MAKING 

• Model – a simplified representation or abstraction of reality
• IT systems in an enterprise

 

 

TRANSACTION PROCESSING SYSTEMS

 

 

 

• Moving up through the organizational pyramid users move from requiring transactional information to analytical information

 

DECISION SUPPORT SYSTEMS

 

 

• What-if analysis

 

• Goal-seeking analysis



• Interaction between a TPS and a DSS



 

EXECUTIVE INFORMATION SYSTEMS

 

 

• Interaction between a TPS and an EIS



 

• Digital dashboard – integrates information from multiple components and presents it in a unified display

 

 



 

ARTIFICIAL INTELLIGENCE (AI)

• The ultimate goal of AI is the ability to build a system that can mimic human intelligence

 

DATA MINING

• Data-mining software includes many forms of AI such as neural networks and expert systems

 

 

CLUSTER ANALYSIS



 

ASSOCIATION DETECTION

 

STATISTICAL ANALYSIS

 







CHAPTER 8

ACCESSING ORGANIZATIONAL INFORMATION - DATA WAREHOUSE

HISTORY OF DATA WAREHOUSING

DATA WAREHOUSE FUNDAMENTALS

MULTIDIMENSIONAL ANALYSIS AND DATA MINING

nCube – common term for the representation of multidimensional information

INFORMATION CLEANSING OR SCRUBBING

nContact information in an operational system

nStandardizing Customer name from Operational Systems

nInformation cleansing activities

nAccurate and complete information

BUSINESS INTELLIGENCE

CHAPTER 7

STORING ORGANIZATIONAL INFORMATION - DATABASE

RELATIONAL DATABASE FUNDAMENTAL

ENTITIES AND ATTRIBUTES

KEYS AND RELATIONSHIPS

—Potential relational database for Coca-Cola

RELATIONAL DATABASE ADVANTAGES

1. INCREASED FLEXIBILITY

2. INCREASED SCALABILITY AND PERFORMANCE

3. REDUCED INFORMATION REDUNDANCY

4. INCREASED INFORMATION INTEGRITY (QUALITY)

5. INCREASED INFORMATION SECURITY

DATABASE MANAGEMENT SYSTEMS

DATA-DRIVEN WEB SITES

DATA-DRIVEN WEB SITES BUSINESS ADVANTAGES

DATA-DRIVEN BUSINESS INTELLIGENCE

—BI in a data-driven Web site

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES

—Forward integration

—Backward integration

—Building a central repository specifically for integrated information