This training program shows professionals how to manufacture a total model in IBM Planning Analytics utilizing the Architect device. Through a progression of talks and hands-on works out, understudies will figure out how to set up and check measurements, shapes, and perspectives, physically enter information into these structures, and characterize the information that clients can see. Understudies will likewise figure out how to move information into the IBM Planning Analytics model, including the utilization of TurboIntegrator contents to perform information move. Furthermore, the course plots how to modify drill ways, convert monetary forms, model for various financial necessities, and convey IBM Planning Analytics applications to the web.


Radiant Techlearning offers IBM Planning Analytics: Design and Develop Models in Architect (v2.0) training program in Classroom & Virtual Instructor Led/Online Mode.



Duration: 40 hours


In order to benefit from this course, professionals should have prior:

  • Understanding of the metrics and drivers of your business
  • Significant experience with Microsoft Excel spreadsheets 
  • Basic knowledge of OLAP and IBM Planning Analytics


Audience Profile

  • Modelers

Course Details

Course Outline

Module 1 Overview of IBM Planning Analytics

  • Review financial performance management
  • Recognise the IBM Planning Analytics position in a performance management system
  • Explain the IBM Planning Analytics components and architecture
  • Explain TM1 server fundamentals
  • Explain fundamental modeling concepts


Module 2 Create dimensions

  • Explain cubes and dimensions
  • Create dimensions manually
  • Edit dimensions
  • Create dimensions using TurboIntegrator


Module 3 Build cubes and views

  • Explain cubes and data points
  • Create cubes
  • Construct views of data in cubes
  • Create and use a pick list


Module 4 Load and maintain data

  • Recognise data sources
  • Create processes to load data
  • Create processes to delete data in a cube
  • Create processes to update and maintain the model


Module 5 Add business rules

  • Explain a rule
  • Construct rules for elements or consolidations
  • Use functions in rules
  • Optimize rule performance
  • Explain rules in a rule worksheet


Module 6 Optimize rule performance

  • Explain consolidations and sparsity
  • Enhance consolidation performance using SKIPCHECK
  • Use FEEDERS to optimize aggregations
  • Check the accuracy of rules and feeders


Module 7 Transfer data into the model

  • Explain the Advanced tabs in TurboIntegrator
  • Load custom data into a cube
  • Add a subset to a dimension
  • Use logic in scripts
  • Export data to ASCII
  • Move data between versions
  • Construct chores


Module 8 Customize drill paths

  • View related data
  • Create a drill process
  • Create a drill assignment rule
  • Edit a drill process


Module 9 Using rules for advanced modeling

  • Explain virtual cubes
  • List uses for lookup cubes
  • Create and use a spread profiles cube
  • Implement moving balances in a cube


Module 10 Convert currencies

  • Explain currency challenges
  • Create a currency dimension
  • Create a currency cube
  • Create rules for currency conversion


Module 11 Model for different fiscal requirements

  • Recognise time considerations
  • Use discrete time dimensions
  • Implement a continuous time dimension model


Module 12 Deploy IBM Planning Analytics applications

  • Explain the application types
  • Access an IBM Planning Analytics application
  • Create a new application
  • Set the available clients
  • Apply security in the application
  • Activate and deactivate an application
  • Appendix A: Optimize and tune models
  • Recognise characteristics of large models
  • Explain strategies to improve model performance
  • Appendix B: Recognise common data structures
  • Recognise characteristics of operational and reporting databases
  • Discuss Online Analytical Processing (OLAP)
  • Examine core model design principles
  • Recognise the basic tasks required to create an IBM Planning Analytics model and deploy it




Q: What is IBM Planning Analytics?


A: It is a planning, budgeting, forecasting and analysis solution, available for deployment on premise or in the cloud. It is built on the technology of IBM Cognos TM1, IBM Planning Analytics helps organizations automate manual, spreadsheet-based processes and link financial plans to operational tactics. It features a customizable workspace that can be deployed to cost center owners and business managers. It also offers a Microsoft Excel interface.  


Q: What is skipcheck in TM1?


A: It forces the TM1 engine to “skip the checking” of empty cells in a cube. It is a part of the Sparse Consolidation engine that makes TM1 so extraordinarily fast.


Q: What is TM1 Turbo Integrator?


A: It is an ETL tool. It can extract data from various data sources and load into TM1 cubes. Capabilities of TI make it an integral part of TM1 offering, like: 

  • Create dimensions and cubes
  • Run other TI processes
  • Do data spreading
  • Apply security
  • Do almost anything that you do manually, using TI.


Q: What is IBM Cognos TM1?


A: It is an enterprise planning software platform which can transform your whole planning cycle, from target setting and budgeting to reporting, scorecarding, analysis and forecasting. Available as an on-premise or on-cloud solution, and with extensive mobile capabilities, Cognos TM1 allows you to collaborate on plans, budgets and forecasts. You can also analyze data, and create models – including profitability models – to reflect a constantly evolving business environment. 


Q: What is OLAP?


A: Online analytic processing (OLAP). It is an approach to swiftly answer multi-dimensional analytical queries. It uses a multi-dimensional data model to build a relational database (ROLAP) or is directly based on a multi-dimensional cube (MOLAP). This tool refers to the category of software tools that provides analysis of data and can include either a ROLAP or MOLAP.


Q: What are the prerequisites for this course?


A: The prerequisites for this course include:

  • Understanding of the metrics and drivers of your business
  • Significant experience with Microsoft Excel spreadsheets 
  • Basic knowledge of OLAP and IBM Planning Analytics


Q: Where is Radiant Techlearning Located?


A: Radiant Techlearning is headquartered in Electronic city & technology hub of Northern India, Noida, which is surrounded by several large multinational, medium & small Software companies. 

We have our offices located all across the country and partners across the globe.  


Q: What is the benefit of doing training from Radiant Techlearning?


A: Radiant Techlearning is receptive to new ideas and always believes in a creative approach that makes learning easy and effective. We stand strong with highly qualified & certified technology Consultants, trainers and developers who believe in amalgamation of practical and creative training to groom the technical skills.

Our training programs are practical oriented with 70% – 80% hands on the training technology tool. Our training program focuses on one-on-one interaction with each participant, latest content in curriculum, real time projects and case studies during the training program. 

Our experts will also share best practices & will give you guidance to score high & perform better in your certification exams. 

To ensure your success, we provide support session even after the training program. 

You would also be awarded with a course completion certificate recognized by the industry after completion of the course & the assignment.


Q: How do you ensure the quality of training program?


A: Radiant has highly intensive selection criteria for Technology Trainers & Consultants, who deliver you training programs. Our trainers & consultants undergo rigorous technical and behavioral interview and assessment process before they are on boarded in the company. 

Our Technology experts / trainers & consultant carry deep dive knowledge in the technical subject & are certified from the OEM.

Our training programs are practical oriented with 70% – 80% hands on the training technology tool.  Our training program focuses on one-on-one interaction with each participant, latest content in curriculum, real time projects and case studies during the training program. 

Our faculty will provide you the knowledge of each course from fundamental level in an easy way and you are free to ask your doubts any time from your respective faculty.

Our trainers have patience and ability to explain difficult concepts in simplistic way with depth and width of knowledge.

To ensure quality learning, we provide support session even after the training program. 


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the email to answer your technical queries, even after the training program.

We also conduct a 3 – 4 hours online session after 2 weeks of the training program, to respond on your queries & project assigned to you.  


Q: If I face technical difficulty during the class what should I do?


A: Technical issues are unpredictable and might occur with you as well. Participants have to ensure that they have the system with required configuration with good internet speed to access online labs.  

If the problem still persists or you face any challenge during the class then you can report to us or your trainer. In that case Radiant would provide you the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use. 


Categories: , ,

Unble To Find a Batch..?

Request a Batch