1 of 14

Experiencing M I S

Ninth Edition

Chapter 3

Business Intelligence Systems

Slides in this presentation contain hyperlinks. JAWS users should be able to get a list of links by using INSERT+F7

2 of 14

What is a Business Intelligence System?

3-1 How do organizations use business intelligence (B I) systems?

Business Intelligence Systems (BI) are information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals and other knowledge workers

Decision Support Systems is a synonym for decision-making BI systems.

3 of 14

Components of Business Intelligence (B I) Systems

3-1 How do organizations use business intelligence (B I) systems?

Figure 3-1 Structure of a Business Intelligence System

4 of 14

What are Typical Uses for B I?

3-1 How do organizations use business intelligence (B I) systems?

Typical Uses of BI Systems Include:

Changes in Purchasing Patterns (for marketing purposes)
BI for Entertainment – Ex: Spotify processes data on customers’ listening habits to determine locations where popular songs are heard most
Just-in-time Medical Reporting – Analyze records as they are entered

5 of 14

Three Primary Activities in the B I Process

Figure 3-3 Three Primary Activities in the B I Process

Push Publishing – Delivers BI to users without request

Pull Publishing – Requires user to request BI results

6 of 14

Using Data Warehouses and Data Marts to Acquire Data

3-3 How do organizations use data warehouses and data marts to acquire data?

Data Warehouse is a facility for managing an organizations BI data
Functions of a data warehouse include:

Obtain data from operational, internal, and external databases.
Cleanse data.
Organize and relate data.
Catalog data using metadata.

Data Mart is a smaller data collection for a department or functional area

7 of 14

Components of a Data Warehouse

3-3 How do organizations use data warehouses and data marts to acquire data?

Figure 3-8 Components of a Data Warehouse

8 of 14

Data Warehouses Versus Data Marts

3-3 How do organizations use data warehouses and data marts to acquire data?

Figure 3-11 Data Mart Examples

9 of 14

Types of B I Analysis