Training offering

IBM Cognos 8 BI Data Manager: Build Datamarts with Enterprise Data (version 8.4)                                                                                                                        

Description

IBM Cognos 8 BI Data Manager: Build Datamarts with Enterprise Data (V8.4) is a five-day, instructor-led course that teaches participants how to move, merge, consolidate, and transform data from a range of data sources to build and maintain subject-area data marts. In the process, students will create a catalog and add connections to data sources and targets. They will also deliver fact and dimension data to a data mart through the use of builds and the dimensional framework. In addition, students will learn how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures.

Objectives

Please refer to Course Overview for description information.

Participants

This is an expert course for Developers.

Prerequisite(s)

Experience using basic Windows functionality

Knowledge of database concepts

Knowledge of dimensional analysis concepts

Working knowledge of SQL

Programme

Examine the Cognos approach to data warehousing and the role of Data Manager

Create and administer catalogs

Connect to source and target data

Build and customize the dimensional framework

Create builds to deliver data to a data mart

Create conformed dimensions and manage dimensional history

Aggregate, merge, and partition fact data

Automate functionality using JobStreams and commands

Resolve common data quality issues

Create business intelligence from data mart data using Cognos 8