EncartaLabs

IBM Planning Analytics - Design & Develop Models in Planning Analytics Workspace

( Duration: 5 Days )

The Planning Analytics - Design & Develop Models in Planning Analytics Workspace training course is designed to teach modelers how to build a complete model in IBM Planning Analytics using Planning Analytics Workspace. Through a series of lectures and hands-on exercises, attendees will learn how to set up dimensions and cubes, manually enter data into these structures, and define the data that users can see. Attendees will also learn how to transfer data into the IBM Planning Analytics model, including the use of TurboIntegrator scripts to perform data transfer. In addition, the course outlines how to customize drill paths, convert currencies, and model for different fiscal requirements.

By attending Planning Analytics - Design & Develop Models in Planning Analytics Workspace workshop, attendees will learn to:

  • Overview of IBM Planning Analytics
  • Create dimensions
  • Load and maintain data
  • Add business rules
  • Optimize rule performance
  • Transfer data into your model
  • Customize drill paths
  • Use rules for advanced modeling
  • Convert currencies
  • Model for different fiscal requirements

  • Knowledge of your business requirements
  • Attend Planning Analytics - Design & Develop Models in Planning Analytics Workspace course or equivalent knowledge

This IBM Planning Analytics - Analyze Data and Create Reports class is intended for Modelers.

COURSE AGENDA

1

Overview of IBM Planning Analytics

  • Modeling in IBM Planning Analytics: overview
  • IBM Planning Analytics: data tier
  • In-memory data storage
  • Calculating versus caching data
  • Important files in TM1
2

Create dimensions

  • Create dimensions
  • What is a dimension?
  • What are weights?
  • Time dimensions
  • Member attributes
  • Hierarchies
3

Load and maintain data

  • What is TurboIntegrator?
  • Defining data sources and process parameters in TurboIntegrator
  • Validate and run processes
  • TurboIntegrator chores
4

Add business rules

  • What are rules?
  • How do you create a rule?
  • Review rule processing
  • Use a rule to override aggregation
  • Use a function in a rule
5

Optimize rule performance

  • Understanding consolidations and sparsity
  • Optimize your rules using SKIPCHECK
  • Using feeder statements
  • Inter-cube feeders
  • Feeding string rules
  • Trace cell values and feeders
6

Transfer data into your model

  • Link cubes with different dimensions
  • Review TurboIntegrator
  • Dealing with data
  • Use IBM Planning Analytics as a data source
  • Tips for scripting in TurboIntegrator
7

Customize drill paths

  • View related data
  • Create a drill path
8

Use rules for advanced modeling

  • Describe a virtual cube
  • Utilize a lookup cube
  • Use relative spreading and a spread profiles cube
  • Use attributes in rules
9

Convert currencies

  • Converting currency: overview
  • Review control cubes
10

Model for different fiscal requirements

  • Understanding time
  • Discrete time dimensions
  • Continuous time dimensions
  • Develop a continuous time model

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