How This Course Is Organised

The Cognos PowerPlay Transformer: OLAP Modelling course provides step-by-step instructions on how to perform a variety of Cognos PowerPaly Transformer Modelling tasks for activities based on real-life work scenarios.

This course is designed to give learners the comprehensive skills needed to plan, analyse, Create, manage and deploy Transformer Models in both Relational and Multi-dimensional OLAP environments. PowerPlay Transformer OLAP Modelling is a hands-on step-by-step self-study course designed to provide PowerPlay Modellers an in-depth understanding of the fundamental and advanced skills involved in designing PowerPlay applications and using Transformer to build and maintain a variety of PowerCubes.

Duration 

N/A

Audience

The target audience for this course is Cognos Transformer Modellers and Developers.

Prerequisites

Knowledge of PowerPlay Explorer, Excel, Relational Databases and or SQL.

Certification applicability 

This course is designed for students preparing for the Cognos BI certification and as a hands-on job-reference guide.

Course Topics

Course Overview        

Business Scenario        

Reporting and Analysis with Cognos 8 BI         

Cognos 8 BI Architecture Overview    

Introduction and Key Concepts           

Business Intelligence and OLAP Concepts       

The Query and Analysis Continuum      

Transformer and PowerPlay Concepts 

Planning your PowerPlay Project

Approach to PowerPlay Projects         

Tactical versus Strategic Solution         

Understanding Rapid Implementation Method - RIM    

Understanding JAD     

Introducing Multi-Dimensional Modelling

Building a Business Dimension Model   

Analysing Data Elements from your Model       

Business Dimension Model Design Issues         

Identifying Source Data elements for the Model

Data Modelling in Cognos Environments

Transformer Fundamentals       

Understanding PowerPlay Data Sources          

Starting and Navigating Transformer     

Importing your source Data      

Creating your PowerCube       

Building the Time Dimension    

Create the Time Dimension      

Set Up Fiscal Year      

Building a Model         

Design Considerations for PowerPlay   

Performance Considerations    

Build Model with AutoDesign  

Modify Property sheets for Dimensions, Levels and Categories 

Build Model without AutoDesign          

Create New Dimensions from Source Data      

Creating Exception Dimensions from Source Data

Enhancing Your Model

Creating Sub-Dimensions         

Creating Alternate Drill Paths   

Structuring your Models Manually        

Creating Special Categories     

Creating Calculated Categories

Creating Relative Time Categories        

Creating Relative Time Groups 

Creating PowerCubes based on one Measure  

Creating Custom Views           

Working with Measures           

Creating Calculated Measures  

Creating Calculated Columns   

Creating Column Ranges          

Create a Measure that Counts Categories        

Creating Multiple Query PowerCubes  

Adding a Query to Existing Model       

View Scope of a Data Source  

Creating a Multiple Query Model         

Currency Conversions 

Indentify Measures that use Currency Conversion

Advanced Features of PowerPlay - Allocating Measures          

Allocate Values to  Measures at Lower Levels 

Allocate Measures to Dimensions         

Model Multiple Allocations      

Security           

Adding Cube Password Protection

Drill Through   

Drill Through to an Impromptu .imr Report file  

Drill Through to a PowerCube

What is a CBT?

CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.

Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

NOTE: WebLearning Publishing CBT and Training Guides products are now delivered with FULL LICENCE KEY.

The WebLearning unique Methodology

All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. You need to register your product to qualify for FREE UPGRADES.

FACT:

·        Material retention with CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·             CBT’S are self pacing, interactive and simulate the actual software being studied