EncartaLabs

IBM Cognos Planning Analyst - Build Models

( Duration: 5 Days )

The IBM Cognos Planning Analyst - Build Models training course teaches modelers how to design and build models for business planning. Participants will learn the data modeling process and participate in hands-on demos and workshops that illustrate good model design and best practice techniques while learning how to use the product.

  • Knowledge of organization’s data and structure
  • Knowledge of Microsoft Excel

This course is intended for Modelers

COURSE AGENDA

1

Introduction to IBM Cognos Planning Analyst

  • Examine the components of the IBM Cognos Planning solution
  • Discuss libraries, D-Lists, D-Cubes, and D-Links
  • Create libraries
2

Create D-Lists and D-Cubes

  • Manually create D-Lists
  • Import D-List items from external sources
  • Modify D-Lists
  • Build D-Cubes
3

Load Data

  • Determine what can be used as source data
  • Create file maps to assist in loading data
  • Load data from an external source into a D-Cube
  • Load data from one D-Cube to another
4

Enhance D-Lists and D-Cubes

  • Prevent calculations on a D-List item
  • Control user input using a formatted D-List
  • Use Built-in Functions (BiFs) to calculate data
  • Use time averages in a D-List
  • Use weighted averages in a D-List
  • Apply conditional formulas to a D-List
5

Distribute Data

  • Use a D Cube to allocate data
  • Summarize D Cube data with Accumulation D Links
  • Populate a D Cube based on text in the target D Cube using Lookup D Links
6

Create and Distribute an Income Statement

  • Determine the requirements for building and populating an income statement
  • Discuss various methods of depreciation
  • Calculate depreciation using a Built-in Function
  • Export income statement data
7

Forecast Data

  • Examine the Forecast Built-in Function
  • Build a revised rolling forecast
  • Use various methods to forecast data
8

Automate Processes

  • Use D List and D Cube update links to update structure and data
  • Create macros to automate the update process
  • Enhance macros functionality
  • Record a macro to perform repetitive tasks
9

Object Maintenance and Administration

  • Examine IBM Cognos security
  • Add and maintain libraries
  • Apply security to a library or object
  • Add, remove, and modify objects
  • Create copies of objects and libraries
  • Discuss features that affect performance
10

Use Complex Calculations

  • Move values through periods using the FeedParam Built-in Function
  • Round values using TRound Built-in Function
  • Examine Tier calculations
  • Calculate balances based on profiles
11

Examine Advanced Concepts

  • Discuss calculation precedence
  • Restructure D Cubes
  • Transfer data within a D Cube
  • Examine cascading allocations
12

Design for Reporting

  • Explore the tools available for reporting on Planning Analyst data
  • Design a model for reporting purposes
  • Publish objects for external reporting
  • Make published data available for reporting in IBM Cognos
  • Create a report based on Planning Analyst published data
  • Populate a D-Cube using IBM Cognos as a datasource
13

Enhance Functionality Using the IBM Cognos Planning Analyst Add-in for Microsoft Excel

  • Examine the IBM Cognos Planning Analyst Add-in for Microsoft Excel
  • Build views
  • Update views
  • Create and use templates for data entry
  • Format and customize Microsoft Excel spreadsheets
  • Update reports
  • Examine batch printing
14

Illustrate the Model Using IBM Cognos Planning Manager

  • Design reports
  • Create a flowchart
  • Link the flowchart to objects in IBM Cognos Planning Analyst
  • Create tables
15

Use IBM Cognos Planning Analyst with IBM Cognos Planning Contributor

16

Use IBM Cognos Planning Analyst with IBM Cognos Finance

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top