Business Intelligence Certification Guide - IBM Redbooks

Business Intelligence Certification Guide

Joerg Reinschmidt, Allison Francoise

International Technical Support Organization

redbooks.

SG24-5747-00

SG24-5747-00

International Technical Support Organization

Business Intelligence Certification Guide

January 2000

Take Note!

Before using this information and the product it supports, be sure to read the general information in

Appendix A, ¡°Special notices¡± on page 131.

First Edition (January 2000)

This edition is intended to be product and operating system independent.

Comments may be addressed to:

IBM Corporation, International Technical Support Organization

Dept. QXXE Building 80-E2

650 Harry Road

San Jose, California 95120-6099

When you send information to IBM, you grant IBM a non-exclusive right to use or distribute the

information in any way it believes appropriate without incurring any obligation to you.

? Copyright International Business Machines Corporation 2000. All rights reserved.

Note to U.S Government Users ¨C Documentation related to restricted rights ¨C Use, duplication or disclosure is

subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corp.

Contents

Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii

Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .ix

Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xi

The team that wrote this redbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi

Comments welcome . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xii

Chapter 1. Business Intelligence ¡ª an introduction . . . . . . . . . . . . .

1.1 Certification test objectives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.2 What is Business Intelligence? . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.3 Business driving forces . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.4 How to identify BI candidates? . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.4.1 Senior executives of a corporation . . . . . . . . . . . . . . . . . . . . . .

1.4.2 IT vice presidents, directors, and managers . . . . . . . . . . . . . . .

1.4.3 CFOs, financial vice presidents, and controllers . . . . . . . . . . . .

1.4.4 Sales VPs, product managers, and customer service directors .

1.4.5 Operations and production management . . . . . . . . . . . . . . . . .

1.5 Main BI terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.1 Operational databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.2 OLTP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.3 Data warehouse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.4 Data mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.5 External data source. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.6 OLAP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.7 OLAP server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.8 Metadata ¡ª a definition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.9 Drill-down . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

1.5.10 Operational versus informational databases . . . . . . . . . . . . . .

1.5.11 Data mining . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. .1

. .1

. .3

. .4

. .5

. .5

. .6

. .7

. .8

. .9

. .9

. 10

. 10

. 10

. 11

. 11

. 12

. 13

. 13

. 13

. 14

. 15

Chapter 2. BI implementations and warehouse concepts

2.1 Different BI implementations . . . . . . . . . . . . . . . . . . . . .

2.1.1 Summary table . . . . . . . . . . . . . . . . . . . . . . . . . . . .

2.1.2 OLTP data at separate server. . . . . . . . . . . . . . . . .

2.1.3 Single data mart . . . . . . . . . . . . . . . . . . . . . . . . . . .

2.2 Data warehouse components . . . . . . . . . . . . . . . . . . . . .

2.2.1 Data sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

2.2.2 Extraction/propagation . . . . . . . . . . . . . . . . . . . . . .

2.2.3 Transformation/cleansing . . . . . . . . . . . . . . . . . . . .

2.2.4 Data refining . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. 17

. 17

. 17

. 18

. 19

. 22

. 23

. 23

. 23

. 24

? Copyright IBM Corp. 2000

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

..

..

..

..

..

..

..

..

..

..

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

.

iii

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download