IBM Cognos 10 Creating Data Models with Transformer

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.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

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.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

I liked the technology of working online. The instructor was very knowledgeable and greatly expanded upon the course material.
Todd Rozelle
Seabrook Nuclear Power Plant
While I wasn't expecting to be an expert coming out of this class, I do feel that I was provided with a sufficient overview of WordPress with just enough depth to be able to master it for the task I have to tackle at work.
Patrick O'Shea
Tribune Media Group
The experience was excellent and I would highly recommend it to others. Looking forward to taking another course in the near future.
Scott Braun
Tangible Solutions, Inc.
Loved the class, it was clear and concise and a fit for my everyday work-life.
Nicole Jenkins
Admiral Insurance Company

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

63,175

Students who have taken Instructor-led Training

11,876

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,679 reviews

Contact Us or call 1-877-932-8228