ibm logo cognos

IBM Planning Analytics Courses

Business Analytics enables organisations to understand, anticipate and adapt; to drive better business outcomes, such as more top line growth or improved cost control. This is achieved by enabling the delivery of key data to key stakeholders, in a timely, automated and controlled manner; for effective business planning, forecasting, analysis and reporting.

 

View   IBM Cognos Training Course Schedule for March 2019 - June 2019

 

        Course Duration         Price    

Course Guide   

IBM Planning Analytics/Cognos TM1 - Design and Build Models

3 days

£1425

BSG Training - delivering ICT Training Solutions for you

This course has been designed to give maximum learning and development capabilities to Administrators of the IBM Planning Analytics/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.

This training was developed using IBM Cognos TM1 10.2.2 but is applicable to both IBM Cognos TM1 v10.2 and IBM Planning Analytics.

  Course Outline:
  • Introduction to IBM Planning Analytics/Cognos TM1 Architect & its components
  • Build a Profit and Loss Model
  • Understand and create Servers, Dimensions, Cubes, Links, Processes and Chores
Performance Modeler
  • Introduction to IBM Cognos Performance Modeler
  • Dimension Functions
  • Links and Cube Calculations
  • Load and Maintain Data
  • Modelling Time and Averages
  • Data Spreading
  • Dynamic and Static Subsets
  • Adding Dimensions to Cubes in Performance Modeler
  • Understand and create Rules, SKIPCHECK and FEEDERS
  • Create rules for Advanced Modelling
  • ETL Functionality use and understand Turbo Integrator (TI’s)
  • IBM Cognos Security
  • Automating Processes
  • Best Practice Naming Conventions
TM1 Applications on the Web
  • Application Types
  • Creating the IBM Cognos TM1 Application
  • Application Navigation
  • Application Workflow States
  • Applying Security
Integrate with IBM Cognos Analytics (BI)
 
 

Course Guide   

IBM Planning Analytics Workspace(PAW)

1 day

£475

BSG Training - delivering ICT Training Solutions for you

In this course, you will learn about the individual components of PAW before implementing them in the design of a series of highly visual, dynamic dashboards.

  Course Outline:
Navigate the IBM Planning Analytics welcome portal
  • Access Help
  • Search for content
  • Rename, Move, Delete content
  • Create a New Folder
  • Access Shared and Personal content
  • Filter & Sort your content
  • Create new Book / Open from Book Template
Explore the workspace portal
  • Toggle the Edit / Run mode
  • Refresh workspace
  • Save content
  • Undo
  • Share content
  • Add and rename a Tab
  • Explore and navigate data stored in TM1 Servers in the Data pane
  • Amend Tree Settings in the Data pane
  • Explore Bookmarks & Recently Visited content
Manipulating a Cube View in a workspace
  • Rearrange an existing view / create a new view
  • Explore options in Set Editor to narrow the list of members
  • Quickly import content with What do you want to assemble? feature
  • Explore the widget actions
Insert other content on a workspace
  • Learn how to insert various objects into your workspace
Properties
  • Explore objects properties to amend colour palettes and abbreviate values
  • General Properties
  • Widget Properties
Filtering data
  • Add as Selector Widget
  • Convert to a slider / list
Assemble Workspaces
  • Import Cube Views and Websheetsv
  • Use Collections feature to reuse content
  • Create Selector Widgets
  • Enhance a workspace with Visualizations such as Maps and Word Clouds
Share
  • Share your content with other users

close

Course Guide   

IBM Planning Analytics for Excel (PAx) Share and Analyse Data

1 day

£475

BSG Training - delivering ICT Training Solutions for you

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:
Planning Analytics for Excel (PAx)
  • Introduction to the TM1 Solutions
  • Getting to know the TM1 user Interfaces
  • Connect to TM1
  • Explore the Task Pane
  • Compare TM1 Perspectives and PAx
  • Cube views and data
  • Create and understand Subsets
  • Search metadata
  • Utilise Levels / Members
  • Spread data
  • Create Explorations
  • Report types: Quick, Custom, List, Dynamic
  • Convert reports
  • Explore Edit MDX option
  • Multiple hierarchy reporting
  • Utilise an Action Button
  • Run a process
  • TM1 formulas in Microsoft Excel
  • Sandboxing
  • Publish content to TM1 server
TM1 Web
  • Overview of TM1 Web
  • Create views and subsets
  • Charting
TM1 Applications
  • Discuss application types
  • User, roles and workflow states
  • Data entry and shortcut keys
  • Data spreading
  • Submit and Reject
IBM Cognos Insight
  • Import a spreadsheet
  • Create a dashboard from a TM1 server
  • Filter data
  • Arrange widgets
  • Chart palettes
 
 
 

 

 Book a Course