Building the Data Warehouse

start > courses and registration > training feature sheet

code.

DW110

length.

4.5 days

type.

Instructor-Led

partner.

IBM

price.

$2,875

IACET credits 3.6

Learn practical methods and techniques for designing and constructing a Data Warehouse (DW) and to provide a comprehensive Business Intelligence (BI) solution architecture. Apply the techniques in the context of an incremental process, suitable for constructing a DW and BI solution from a departmental or functional workgroup perspective. Also, learn how the process can be extended further for the construction of consistent, corporate-wide DWs.

Apply the techniques you learn in several exercises that are part of a non-trivial case study. Also, participate in several hands-on machine exercises exposing you to several products useful for DW and BI enablement.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an intermediate course for data modelers, database designers, database administrators, data architects, technically oriented project leaders, and all other technical professionals with an interest in designing and constructing informational warehouses and for professionals seeking IBM BI Specialist certification.

prerequisites

You should know and have some experience with data modeling and with relational database design and construction techniques in general.

course content details

	Course Content Outline

	Overview of DW and BI terminology and architectures
	Design and construction process and DW and BI architectural reference models
	Corporate-wide DW: how to construct one
	Requirements gathering and informational database modeling
	Database design techniques for informational databases, including temporal modeling and the star schema
	Survey of typical BI uses, including Executive Information Systems (EIS), Online Analytical Processing (OLAP), and Information Mining, and the solution requirements for BI applications
	Static relationships between the informational database and the operational data sources
	Time-dependent relationships between the informational database and the operational sources' populating policies, populating cycles, and so on
	Techniques and tools for acquiring, transforming, enhancing, and aggregating data within a DW
	Metadata within DW and BI solutions
	Optimization techniques
	DW and BI project methodologies, planning and issues