Trust Your IT Training |

Oracle University Awards ExitCertified Corporation with North American Partner of the Year.

IBM Cognos Planning Analyst: Build Models (V10.1) (P8101)

Category: Training

Cognos

Format: Instructor-Led Classroom

Other Formats:

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.




	Skills Gained
	Please refer to course overview.




	Who Can Benefit
	This intermediate course is intended for Modelers.




	Prerequisites
	You should have: Knowledge of your organization's data and structure Knowledge of Microsoft Excel




	Abstract
	null

This course is taught by Certified IBM instructors.

As your Authorized Training partner, ExitCertified can put you in any class in North America.

There is a difference. Learn More

Code:	P8101
Format:	Instructor-Led Classroom

Length:	5 days
Certified By:	IBM

Tuition (USD): $3,500

TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011


Denver, CO	Jul.9 - Jul.13.2012

1 Dates Offered

IBM Cognos Planning Analyst: Build Models (V10.1) (P8101) Content Details

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)

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.com/ibm-training/P8101.html

Message:


	When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience. There is a difference. Learn from the source.

Training Provided Across North America


Atlanta Training Austin Training Boston Training Chicago Training Dallas Training	Denver Training Hampton Training Houston Training Indianapolis Training Kansas City Training	Los Angeles Training Las Vegas Training New York Training Philadelphia Training Phoenix Training	Sacramento Training San Francisco Training San Jose Training Tampa Training Washington Training
View All US Training Centers
Worldwide and All US Cities: 408.288.3948		Trust your IT training™ If you have any questions email us and we'll get back to you within 1 business day.

ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:

Sun Training	Oracle Training	Symantec Training	IBM Training	Red Hat - Linux Training
Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training	PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite, MySQL Training,	Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training	DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class	SUSE Training, RedHat Training , JBoss Training

Cisco Training	Apple Training	Hitachi - HDS Training	Project Management PMI Training	VMware Training
Routing and Switching Training, Unified Communications Training, Network Security Training, Data Center Training	Apple Course, Leopard Training, Xsan Training

View All Course Categories

IBM Cognos Planning Analyst: Build Models (V10.1) (P8101)

Skills Gained

Who Can Benefit

Prerequisites

Abstract

IBM Training (2375 courses)

Cognos Training (131 courses)

PM - Cognos Planning (version 10.1) Training (12 courses)

IBM Cognos Planning Analyst: Build Models (V10.1) (P8101) Content Details