Standard

Posted: 09/12/07

R State Standard         £ Institutionally Developed          College: n/a

CIS 2176 - DB2 Business Intelligence  

 

Course Description

This course teaches you to apply Business Intelligence techniques in the context of an incremental process, suitable for constructing a data warehouse and business intelligence solution from a departmental or functional workgroup perspective. Students will also learn how the process can further be extended for the construction of consistent, corporate-wide data warehouses. Students apply the techniques learned in several exercises which are part of a non-trivial case study. Students also participate in several hands-on machine exercises exposing you to several products useful for Datawarehousing and Business Intelligence enablement. Prepares student to take IBM Certification tests 700 and 705. Topics include:  business intelligence terminology, functions, and differentiators, determining business intelligence requirements, business intelligence data sourcing and movement, business intelligence solution architecture.


 

Competency Areas

Hours

Understanding business intelligence terminology, functions, and differentiators

Class

4

Determining business intelligence requirements,

D. Lab

6

Determining business intelligence data sourcing and movement

P. Lab/O.B.I.

0

Designing and implementing business intelligence solution architecture

Credit

7

 

Prerequisite:

CIS 2174

Corequisite:

 

 

Course Guide

 

Competency

After completing this section, the student will be able to:

Hours

Class

D.Lab

P.Lab/

O.B.I.

UNDERSTANDING BUSINESS INTELLIGENCE TERMINOLOGY, FUNCTIONS, AND DIFFERENTIATORS

10

15

 

 

Define Business Intelligence terms

 

 

 

 

Differentiate characteristics and purpose of data marts from those of a data warehouse

 

 

 

 

Articulate the benefits of business intelligence (e.g., timely information, extending the ability of query tools, to extend the ability to understand your business, provide historical view of operational business data

 

 

 

 

Explain scheduling options (time/event/function)

 

 

 

 

Illustrate how network communications impacts Business Intelligence architecture

 

 

 

 

Differentiate multi-dimensional database versus relational database warehouse

 

 

 

 

Differentiate between Operational data store and data warehouse

 

 

 

 

Given BI data and customer requirement criteria, select appropriate tools to perform transformation, extraction, data modeling, data cleansing, loading, and propagation

 

 

 

 

Define and distinguish metadata and describe metadata management techniques and processes

 

 

 

 

Given BI data and customer needs, implement metadata strategy and given BI data, determine appropriate analysis techniques (query, cluster, trend, discovery, predictive, explanatory, visualization)

 

 

 

 

Given BI data and customer requirement criteria, select appropriate visualization and presentation techniques (charts, maps, reports, tables, agent-driven, messaging)

 

 

 

 

Given customer requirement criteria, select appropriate front-end features based on criteria such as presentation, level of interactivity, web-versus-FAT client, static versus dynamic, and user skill level

 

 

 

 

 

 

 

 

GATHER BUSINESS INTELLIGENCE SYSTEM REQUIREMENTS

10

15

 

 

Identify business requirements of the customer as relates to a Business Define the business goals and objectives of the customer

 

 

 

 

Determine number of users, types of queries, number of queries, user work tables

 

 

 

 

Evaluate existing hardware and software environment

 

 

 

 

Identify problem constraints ( timing, technical, competition, legacy issues, customer skill level, etc.)

 

 

 

 

Determine customer growth requirements

 

 

 

 

Identify geographical constraints (human language issues, computer language issues, currency issues, etc.)

 

 

 

 

Identify critical success factors and how to validate them

 

 

 

 

Determine availability and recovery requirements (user uptime, maintenance windows, system maintenance, data mart, and data warehouse for update/refresh situations, disaster recovery, hardware/software failures, aggregation for data marts

 

 

 

 

Prepare for a production environment from a test environment

 

 

 

 

 

 

 

 

BUSINESS INTELLIGENCE DATA SOURCING/MOVEMENT

10

15

 

 

Identify sources of data (operational, non-operational within the company, external to the company)

 

 

 

 

Identify methods for data extraction, transformation, cleansing

 

 

 

 

Differentiate between full differential capturing and snapshot capturing

 

 

 

 

Define methods for data moving (differential, full-refreshed, incremental)

 

 

 

 

Define methods for scheduling

 

 

 

 

Define methods for error detection and handling

 

 

 

 

Describe data modeling techniques and processes

 

 

 

 

Identify methods for work load balancing

 

 

 

 

 

 

 

 

BUSINESS INTELLIGENCE SOLUTION ARCHITECTURE

10

15

 

 

Describe data warehouse management techniques and processes (conversion of data model to the data warehouse; creation & loading of Enterprise Relational Data Warehouse; extraction & management of metadata; creation & loading of data marts from the data warehouse

 

 

 

 

Describe and communicate the infrastructure and organization necessary to support a data warehouse

 

 

 

 

Given source data tables, identify measures, attributes, and dimension

 

 

 

 

Given a BI scoped project, build logical data models (create fact tables, identify dimension, associate the attributes with dimensions)

 

 

 

 

Given a BI business requirement, determine data that is applicable to the business question

 

 

 

 

Given a BI business requirement, transform it into a solution based on requirements such as functionality, performance, security, size, availability, interface with front-end or other systems, connectivity, communications, etc.

 

 

 

 

Given a BI business requirement, select appropriate tools to build the solution (e.g., data extraction, scrubbing, transporting, transforming, data modeling, querying, business process modeling)

 

 

 

 

Given a BI business requirement, select appropriate middleware tools for diverse information integration to the data warehouse

 

 

 

 

Given a BI business requirement, make a presentation based on complexity of data, sophistication of tools, complexity of the data model, user skills, level of interactivity, deployment & accessibility, level of detail needed and level of summarization needed

 

 

 

 

Given an architecture for a BI solution, determine the feasibility of the design based on performance expectations, growth requirements, and scalability factors

 

 

 

 

Given a Business Intelligence project, develop an education strategy for users

 

 

 

 

Determine a solution for producing a searchable meta data repository for business users

 

 

 

 

Suggested Resources

 

Biere, M. (June 2003).  Business Intelligence for the Enterprise, IBM Press, 1st edition. ISBN: 0131413031

Gonzales, M. (Jan 2003). IBM Data Warehousing: With Business Intelligence Tools, Wiley, 1st edition. ISBN:  0-47-113305-1

http://www.ibm.com/certify/  -  Tutorials, IBM Redbooks on Business Intelligence