IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.2)

Schedule

Start End Duration Location Details

Course Details

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.2)

Course Code: B5280G

Duration: 5 days

Prerequisite:

You should have:

  • a knowledge of basic Windows functionality, database and dimensional analysis concepts, as well as a working knowledge of SQL

Course Description:

IBM Cognos Data Manager: Build Data Marts with Enterprise Data (V10.2) is a five-day 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.

Intended Audience:

This course is intended for Developers.

Course Outlines:

  • Getting Started
  • Create a Catalog
  • Create Hierarchies
  • Create Basic Builds
  • Create Derivations
  • Create Conformed Dimensions
  • Customize Reference Structures
  • Process Dimensional History and Late Arriving Facts
  • Transform Data Using Lookups and Derived Dimensions
  • Customize Data Delivery
  • Customize Fact Data Processing
  • Aggregate, Filter, and Partition Fact Data
  • Implement Job Control
  • Automate Functionality Using Commands
  • Customize Functionality with User-Defined Functions and Variables
  • Process Unbalanced Hierarchical Data
  • Pivot Fact Data
  • Resolve Data Quality Issues
  • Troubleshoot and Tune the Data Manager Environment
  • Organize and Package Data Manager Components
  • Integrate with IBM Cognos BI
  • End-to-End Workshop
  • Entity-Relationship Model of the GO_Demo Database (Optional)
  • Work in a Multi-Developer Environment (Optional)
  • Standardizing Dimensions and Facts Exercise (Optional)
  • Review of Data Manager Essentials (Optional)
  • Work with SAP R/3 Data (Optional)