<< 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.

A fully interactive experience, our online classroom offers a unique opportunity to learn from and work with a subject matter expert. Participants get practice performing the skills and can ask questions of the instructor in real time.

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

CLASS MATERIALS

Students receive a comprehensive set of learning materials, including all course notes and class examples.

Cost

$1295

Suggested Attendees

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

Class Goals
  • Transformer fundamentals
  • Discuss basics of OLAP analysis
  • Discuss importance of business requirements
  • Review PowerPlay components
  • Review Cognos 10 BI components
  • Define a model
  • Discuss the Transformer development process
    • Describe the purpose of a Transformer model plan
    • Match business requirements to the model
    • Discuss an approach for creating a Transformer model plan
    • Review the relation of the model plan to the Transformer model
  • Data sources in Transformer
    • Identify source data
    • Discuss the types of data used by Transformer
    • Create data source files
    • Connect the data source to the model
    • Define the data source and column properties in the model
    • Preview source data and SQL
    • Maintain and synchronize data sources with the model
  • Build a model
    • Create model structures using manual techniques and auto design
    • Modify property sheets for dimensions, levels and categories
    • Confirm the data source origin
    • Generate categories to populate the Transformer model
    • Modify the model using the dimension diagram
    • Verify the model
    • Create a default PowerCube
  • Elements of a time dimension
    • Discuss the purpose of a time dimension
    • Identify the specific properties of a time column
    • Define a regular time dimension
    • Discuss a nonstandard time dimension
  • Relative time
    • Compare trends over time
    • Set the current period
    • Create relative time categories
    • Customize relative time categories
  • Use multiple data sources
    • Discuss the use of multiple data sources
    • Plan the data source
    • Define data source types
    • Identify and resolve conflicts between data sources
    • Validate a multiple data source model
    • Discuss a unique move
  • Working with measures
    • Discuss the purpose and uses of measures
    • Describe the differences between regular and calculated measures
    • Set measure properties
    • Compare rollup options
    • Create calculations before or after rollups
    • Create a category count
Course Content
  • The Transformer Development Process
    • Describe the purpose of a Transformer model plan
    • Match business requirements to the model
    • Discuss an approach for creating a Transformer model plan
    • Review the relation of the model plan to the Transformer model
  • Data Sources in Transformer
    • Identify source data
    • Discuss the types of data used by Transformer
    • Create data source files
    • Connect the data source to the model
    • Define the data source and column properties in the model
    • Preview source data and SQL
    • Maintain and synchronize data sources with the model
  • Build a Model
    • Create model structures using manual techniques and AutoDesign
    • Modify property sheets for dimensions, levels and categories
    • Confirm the data source origin
    • Generate categories to populate the Transformer model
    • Modify the model using the dimension diagram
    • Verify the model
    • Create a default PowerCube
  • The Time Dimension
    • Discuss the purpose of a time dimension
    • Identify the specific properties of a time column
    • Define a regular time dimension
    • Discuss a nonstandard time dimension
  • Relative Time
    • Compare trends over time
    • Set the current period
    • Create relative time categories
    • Customize relative time categories
  • Use Multiple Data Sources
    • Discuss the use of multiple data sources
    • Plan the data source
    • Define data source types
    • Identify and resolve conflicts between data sources
    • Validate a multiple data source model
    • Discuss a unique move
  • Working with Measures
    • Discuss the purpose and uses of measures
    • Describe the differences between regular and calculated measures
    • Set measure properties
    • Compare rollup options
    • Create calculations before or after rollups
    • 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.
  • Students will receive electronic copies of the course materials and may print one hard copy for their personal use. 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.

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.