IBM Cognos 10 Creating Data Models with Transformer

Customized Onsite Training

2
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors
Overview

This IBM Cognos 10 Creating Data Models with Transformer training class introduces data modeling techniques with IBM Cognos’ Transformer. Topics include IBM Cognos overview, planning and designing models, creating data sources for Transformer, creating single query and multi-query models, building dimension maps and measures, designing advanced dimensions, building multi-cube models and more. The course format includes lecture, instructor-led exercises and independent workshops.

This course is for developers and other users, who will create, maintain, and build models and cubes using Transformer.

Goals
  1. Understand Transformer’s role in modeling.
  2. Design a dimension map and model based on business rules.
  3. Import data source in a model.
  4. Create a dimension map and measures.
  5. Define and resolve uniqueness.
  6. Build a date dimension and add relative time categories.
  7. Allocate measures.
  8. Create alternate drill paths.
  9. Build and publish cubes and sub cubes.
  10. Maintain models and cubes.
Outline
  1. Overview of IBM Cognos 10
    1. Overview of IBM Cognos 10
    2. Overview of Studios
    3. New Studios and Features in IBM Cognos 10
  2. Overview of Cubes, Models and Transformer
    1. Define Cubes and Dimensional Models
    2. Define Dimensions and Measures
    3. Understand the Differences between Dimensional Models and Cubes
    4. Introduce Framework Manager and Transformer
  3. Planning Your Model
    1. Define Models
    2. Introduce Dimension Maps
    3. Create a Model Plan
  4. Create a Simple Transformer Model
    1. Introduce the Transformer Interface
    2. Build and Compare Data Sources
    3. Single and Multi-Query Models
    4. Understand Model Formats
  5. Create Dimensions
    1. Create a Dimension Map
    2. Understand Levels, Categories and their Properties
    3. Generate Categories and View Dimension Diagrams
  6. Measures
    1. Define Measures Types
    2. Create Regular and Calculated Measures
    3. Understand Measure Properties
    4. Define and Use Measure Rollups
    5. Allocate Measures
  7. Time and Relative Time
    1. Use the Date Wizard
    2. Models with Multiple Date Dimensions
    3. Set the Current Period
    4. Create Relative Time Categories
  8. Advanced Dimensions
    1. Create Alternate Drill Paths
    2. Understand Convergence Levels
    3. Build Subdimensions
  9. Build and Deploy Cubes
    1. Build a Cube
    2. Build Multiple Cubes in the Same Model
    3. Cube Groups
    4. Dimension Views
    5. Exclude Measures
    6. Understand Packages and Data Sources
    7. Deploy Cubes
    8. Understand Partitions
  10. Custom Views and Security
    1. Introduce Custom Views
    2. Understand Model and Cube Security
  11. Model Maintenance
    1. Evaluate Model Changes
    2. Update Cubes with Scripts
    3. Incremental Updates
  12. Summary
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Cognos class:

  • A basic knowledge of IBM Cognos 10, IBM Cognos 10 Analysis Studio or PowerPlay Studio, Windows, Internet Explorer, and browser techniques is recommended.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

74,839

Students who have taken Live Online Training

15,233

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.41

Students rated our trainers 9.41 out of 10 based on 5,189 reviews

Contact Us or call 1-877-932-8228