IBM Planning Analytics/Cognos TM1

Plan, Model and forecast with ease with our comprehensive range of courses. 

  • IBM Cognos TM1 10 Design & Build Models

    Duration: 3 Days

    This course has been designed to give maximum learning and development capabilities to Administrators of the IBM Cognos TM1 10.2. This three-day course is based on a Profit & Loss case study enabling trainees to gain great understanding of fundamental building blocks, best practices and techniques which they can then relate back to in their own business environment.

     

    Course Outline:

    • Introduction to IBM Cognos TM1
    • Performance Modeler & its components
    • Build a Profit and Loss Model
    • Understand and create Servers, Dimensions, Cubes, Links, Processes and Chores
    • Create and use Pick Lists
    • Understand and Build Timescale Dimensions
    • Weighted and Time Averages
    • Understand and create Rules, SKIPCHECK and FEEDERS
    • Basic and Advanced Link Types
    • Automating Processes
    • Update and Maintain Models
    • IBM Cognos Security
    • Data Flow Diagrams
    • Integrated Scorecards
    • Best Practice Naming Conventions
    • Creating, basic, advanced and complex calculations
    • Dimension Functions
    • Dimension Formatting
    • Dynamic and Static Subsets
    • Guided Imports from External Data Sources
    • Data Spreading
    • Cube Calculations

    TM1 Applications

    • Application Types
    • Creating the IBM Cognos TM1 Application
    • Application Navigation
    • Application Workflow States
    • Applying Security
  • IBM Cognos TM1 10 Design & Build Models in Architect

    Duration: 3 Days

    This course has been designed to give maximum learning and development capabilities to Administrators of IBM Cognos TM1 10.2.2 Architect. This three-day course is based on a Profit & Loss case study enabling trainees to gain great understanding of fundamental building blocks, best practices and techniques which they can then relate back to in their own business environment. The course will also introduce to the Administrator the power of IBM Cognos TM1 Performance Modeler and TM1 Applications.

    Course Outline:

    • Introduction to IBM Cognos TM1 Architect & its components
    • Dynamic and Static Subsets
    • Understand and create Rules, SKIPCHECK and FEEDERS
    • Best Practice Naming Conventions
    • Rule Functions
    • Modelling Time
    • Automating Processes
    • Update and Maintain Models
    • IBM Cognos Security
    • Data Spreading
    • ETL Functionality using Turbo Integrator
    • Understand and create Servers, Dimensions, Cubes, TI Processes and Chores
    • Build a Profit and Loss Model

    Performance Modeler

    • Introduction to IBM Cognos TM1 Performance Modeler
    • Links and Cube Calculations
    • Adding Dimensions to Cubes in Performance Modeler

    TM1 Applications

    • Application Types
    • Creating the IBM Cognos TM1 Application
    • Application Navigation
    • Application Workflow States
    • Applying Security
  • IBM Cognos TM1 10 Share and Analyse Data

    Duration: 2 Days

    Working on a pre-built IBM Cognos TM1 model you will learn how to analyse and enter data in TM1. Create and customise reports and templates and Contribute to plans. Enter and review data in Microsoft Excel and on the Web. Communicate with TM1 to create reports and forms in Microsoft Excel.

    Prerequisites: Good understanding of Excel. An understanding of your Business Requirements, metrics and drivers.

    Course Outline:

    • Introduction to the TM1 Solutions
    • Getting to know the TM1 User Interfaces
    • TM1 Perspectives
    • Cube Views and Data
    • Create and Understand Dimension Subsets
    • Data Spreading
    • Snapshot to Microsoft Excel
    • Slice to Microsoft Excel
    • Sandboxing
    • Printing Wizard
    • Action Buttons
    • Charts
    • Overview of TM1 Web
    • Dynamic Reports and Active Forms
    • TM1 Formulas in Microsoft Excel

    TM1 Applications

    • Different Application Types
    • User, Roles and Workflow States
    • Data Entry and Shortcut keys
    • Data Spreading
    • Submit and Reject
    • Populate an application using data from IBM Cognos Insight

    IBM Cognos Insight

    • Different Application Types
    • User, Roles and Workflow States
    • Data Entry and Shortcut keys
    • Data Spreading
    • Submitting and Reject Data
    • Populate an application using data from IBM Cognos Insight
  • IBM Cognos TM1 9.5.2 Design & Build Models

    Duration: 3 days

    This course has been designed to give maximum learning and development capabilities to Administrators of the IBM Cognos TM1 9.5.2. This three-day course is based on a Profit & Loss case study enabling trainees to gain great understanding of fundamental building blocks, best practices and techniques which they can then relate back to in their own business environment.

    Prerequisites: Good understanding of Excel, knowledge of TM1 or OLAP would be advantageous. An understanding of your Business Requirement's, metrics and drivers.

    Course Outline:

    • Introduction to IBM Cognos TM1 Performance Modeler & its components
    • Build a Profit and Loss Model
    • Understand and create Servers, Dimensions, Cubes, Links, Processes and Chores
    • Dynamic and Static Subsets
    • Understand and create Rules, SKIPCHECK and FEEDERS
    • Best Practice Naming Conventions
    • Rule Functions

     

    • Modelling Time
    • Automating Processes
    • Update and Maintain Models
    • IBM Cognos Security
    • Data Spreading
    • ETL Functionality using Turbo Integrator
  • IBM Cognos TM1 9.5.2 Share and Analyse Data

    Duration: 1 Day

    Working on a pre-built IBM Cognos TM1 model you will learn how to analyse and enter data in TM1. Create and customise reports and templates and Contribute to plans. Enter and review data in Microsoft Excel and on the Web. Communicate with TM1 to create reports and forms in Microsoft Excel.

    Prerequisites: Good understanding of Excel. An understanding of your Business Requirements, metrics and drivers.

    Course Outline:

    • Introduction to the TM1 Solutions
    • Getting to know the TM1 User Interfaces
    • TM1 Perspectives
    • Cube Views and Data
    • Create and Understand Dimension Subsets
    • Data Spreading
    • Snapshot to Microsoft Excel
    • Slice to Microsoft Excel

     

    • Sandboxing
    • Printing Wizard
    • Action Buttons
    • Charts
    • Overview of TM1 Web
    • Dynamic Reports and Active Forms
    • TM1 Formulas in Microsoft Excel