Web Based Training

IBM Cognos Planning Analyst: Build Models (V10.1) - SPVC - J1101G

This is the self paced training version of ''IBM Cognos Planning Analyst: Build Models (V10.1)'' classroom course. IBM Cognos Planning Analyst: Build Models (V10.1) is a five-day, self paced course that teaches modelers how to design and build models for business planning. You 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.

Fortgeschritten Englisch
quofox Qualitätssiegel

463,39 €

inkl. 19% MwSt

389,40 € netto

In Warenkorb legen

Beschreibung

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

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

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)

Ziel

Please refer to Course Overview for description information.

Anforderungen an die Teilnehmer

You should have:

Knowledge of your organization's data and structure
Knowledge of Microsoft Excel

Teilnehmer

This intermediate course is for Modelers.


Das könnte Dich auch interessieren

Problem melden


Danke

für Ihr Interesse an diesem Produkt.

Wir setzen uns umgehend mit dem Anbieter in Verbindung und werden in Kürze neue Termine anbieten.
Spätestens in 14 Tagen werden wir Sie über die neuen Termine informieren.

Solange finden Sie das Produkt in Ihrer Wunschliste wieder.