name :
P8101G
title :
IBM Cognos Planning Analyst: Build Models (V10.1)
category :
Analytics
vendor :
IBM
classroomDeliveryMethod :
Classroom IBM
descriptions :
description :
OverviewIBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, instructor led course that 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.AudienceThis course is intended for Modelers.PrerequisitesYou should have:
  • Knowledge of your organization's data and structure
  • Knowledge of Microsoft Excel
ObjectivePlease refer to course overview.Course OutlineIntroduction 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
Create D-Lists and D-Cubes
  • Manually create D-Lists
  • Import D-List items from external sources
  • Modify D-Lists
  • Build D-Cubes
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
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
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
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
Forecast Data
  • Examine the Forecast Built-in Function
  • Build a revised rolling forecast
  • Use various methods to forecast data
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
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
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
Examine Advanced Concepts
  • Discuss calculation precedence
  • Restructure D Cubes
  • Transfer data within a D Cube
  • Examine cascading allocations
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
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
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
End-to-End Workshop (Optional) Use IBM Cognos Planning Analyst with IBM Cognos Planning Contributor (Optional) Use IBM Cognos Planning Analyst with IBM Cognos Finance (Optional)
overview :
[IBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, instructor led course that 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.]
abstract :
IBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, instructor led course that 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.
prerequisits :
objective :
Overview IBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, instructor led course that 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. Audience This course is intended for Modelers. Prerequisites You should have:
  • Knowledge of your organization's data and structure
  • Knowledge of Microsoft Excel
Objective Please refer to course overview.
topic :
Course OutlineIntroduction 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
Create D-Lists and D-Cubes
  • Manually create D-Lists
  • Import D-List items from external sources
  • Modify D-Lists
  • Build D-Cubes
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
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
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
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
Forecast Data
  • Examine the Forecast Built-in Function
  • Build a revised rolling forecast
  • Use various methods to forecast data
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
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
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
Examine Advanced Concepts
  • Discuss calculation precedence
  • Restructure D Cubes
  • Transfer data within a D Cube
  • Examine cascading allocations
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
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
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
End-to-End Workshop (Optional) Use IBM Cognos Planning Analyst with IBM Cognos Planning Contributor (Optional) Use IBM Cognos Planning Analyst with IBM Cognos Finance (Optional)
startDate :
2018-11-13T18:19:50Z
endDate :
2021-04-14T00:00:00Z
lastModified :
2018-11-13T08:00:53Z
created :
2014-05-03T19:10:28Z
duration :
5
durationUnit :
DAYS
listPrice :
currency :

Enquire about this course: