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

81,719

Students who have taken Live Online Training

15,642

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.40

Students rated our trainers 9.40 out of 10 based on 4,753 reviews

I wasn't sure what to expect, but this class was absolutely worth the money. Great course for a beginner!

Tina Quinn, Dr Pepper Snapple Group
Plano TX

The core concepts I learned in class apply in my real world work setting, which is good for job security and for my employer to grow and prosper!

Aaron Anderson, Widener University
Chester PA

As someone who uses PowerPoint but never had the time to really learn how valuable this resource can be, I was able to take this class and walk away feeling very confident in my abilities in PowerPoint. The instructor was an incredible teacher and great resource! The time she took to make sure I understood everything was fantastic and we went at a pace that was quick enough for us to cover all the material but also slow enough that I was able to retain it! My only fear is now that everyone in my company will be leaning on me to help them do their Power Point presentations!!! Thank you again for a superb course!

Chris Deigan, Cord Blood Registry
westwood NJ

My instructor was terrific and able to answer all of my questions.

Patrice Hallenberg, Zurich NA
Schaumburg IL

Contact Us or call 1-877-932-8228