<< VIEW FULL COURSE LIST

IBM Cognos 10.2 & V11 - Transformer

OLAP Modeling

COURSE DESCRIPTION

OLAP Modeling with IBM Cognos Transformer is a two-day, instructor-led, online course. Students will design and implement a multidimensional model, explore advanced features of IBM Cognos Transformer and build, customize and deploy PowerCubes.

This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student's computer screen and offer guidance. A full set of course materials is included and hard copies are sent prior to the class.

APPLICABLE SOFTWARE VERSIONS

Techniques learned in this course are relevant to all versions of IBM Cognos BI version 10 and IBM Cognos Analytics, v11. Read details about similarities and differences between Cognos v10.x and v11

Class Length

Two Days

Cost

$1295

Suggested Attendees

Modelers: individuals creating OLAP models (multidimensional OLAP using PowerCubes)

Class Goals
  1. Transformer Fundamentals
  2. Discuss Basics of OLAP Analysis
  3. Discuss Importance of Business Requirements
  4. Review PowerPlay Components
  5. Review Cognos 10 BI Components
  6. Define a Model
  7. Discuss the Transformer development Process
    1. Describe the purpose of a Transformer model plan
    2. Match business requirements to the model
    3. Discuss an approach for creating a Transformer model plan
    4. Review the relation of the model plan to the Transformer model
  8. Data Sources in Transformer
    1. Identify source data
    2. Discuss the types of data used by Transformer
    3. Create data source files
    4. Connect the data source to the model
    5. Define the data source and column properties in the model
    6. Preview source data and SQL
    7. Maintain and synchronize data sources with the model
  9. Build a Model
    1. Create model structures using manual techniques and auto design
    2. Modify property sheets for dimensions, levels and categories
    3. Confirm the data source origin
    4. Generate categories to populate the Transformer model
    5. Modify the model using the dimension diagram
    6. Verify the model
    7. Create a default PowerCube
  10. Elements of a Time Dimension
    1. Discuss the purpose of a time dimension
    2. Identify the specific properties of a time column
    3. Define a regular time dimension
    4. Discuss a nonstandard time dimension
  11. Relative Time
    1. Compare trends over time
    2. Set the current period
    3. Create relative time categories
    4. Customize relative time categories
  12. Use Multiple Data Sources
    1. Discuss the use of multiple data sources
    2. Plan the data source
    3. Define data source types
    4. Identify and resolve conflicts between data sources
    5. Validate a multiple data source model
    6. Discuss a unique move
  13. Working with Measures
    1. Discuss the purpose and uses of measures
    2. Describe the differences between regular and calculated measures
    3. Set measure properties
    4. Compare rollup options
    5. Create calculations before or after rollups
    6. Create a category count
Course Content
  1. The Transformer Development Process
    1. Describe the purpose of a Transformer model plan
    2. Match business requirements to the model
    3. Discuss an approach for creating a Transformer model plan
    4. Review the relation of the model plan to the Transformer model
  2. Data Sources in Transformer
    1. Identify source data
    2. Discuss the types of data used by Transformer
    3. Create data source files
    4. Connect the data source to the model
    5. Define the data source and column properties in the model
    6. Preview source data and SQL
    7. Maintain and synchronize data sources with the model
  3. Build a Model
    1. Create model structures using manual techniques and AutoDesign
    2. Modify property sheets for dimensions, levels and categories
    3. Confirm the data source origin
    4. Generate categories to populate the Transformer model
    5. Modify the model using the dimension diagram
    6. Verify the model
    7. Create a default PowerCube
  4. The Time Dimension
    1. Discuss the purpose of a time dimension
    2. Identify the specific properties of a time column
    3. Define a regular time dimension
    4. Discuss a nonstandard time dimension
  5. Relative Time
    1. Compare trends over time
    2. Set the current period
    3. Create relative time categories
    4. Customize relative time categories
  6. Use Multiple Data Sources
    1. Discuss the use of multiple data sources
    2. Plan the data source
    3. Define data source types
    4. Identify and resolve conflicts between data sources
    5. Validate a multiple data source model
    6. Discuss a unique move
  7. Working with Measures
    1. Discuss the purpose and uses of measures
    2. Describe the differences between regular and calculated measures
    3. Set measure properties
    4. Compare rollup options
    5. Create calculations before or after rollups
    6. Create a category count
Registration Details

  • Senturus accepts payment by credit card, purchase order and invoice.
  • Paying party will receive a payment confirmation email upon payment receipt.
  • Each registered student will receive an email with the course confirmation and details on how to access the online classroom.
  • A full, hard copy set of course materials is shipped to each United States based student a few days prior to the start of class.
  • *International students will receive electronic copies of the course guide in place of a hard copy. These students may print one hard copy of the guide for their own personal use during the course. The course materials are copyrighted and any other reproduction or distribution of these materials is strictly prohibited.

We recommend that all attendees have two displays (monitors) so they can see the training presentation and their hands-on class work simultaneously.

Audio for attendees is via VoIP and a PC Headset is highly recommended. Audio is also available via teleconference using a TOLL number.

For this course, attendees will need to connect to the demonstration environment via Remote Desktop. Instructions will be provided in the registration confirmation.

Cancellations made ten or more calendar days prior to the first day of the course receive a 100% refund.

Cancellations made between five and nine calendar days prior to the first day of the course, receive a 50% refund.

Registrants will be charged 100% of the enrollment fee if a cancellation request is not received at least five calendar days prior to the first day of the course.

OPEN