Training Courses
Are you new to IBM Planning Analytics? Start your journey here with the End User (Excel) course and complete the pathway with End User (PAW) to learn how to proficiently utilise IBM PA in Excel and Workspace.
End User Pathway
Introduction to IBM Planning Analytics
In this course, you will learn the value and benefit of TM1 to empower your understanding of how it works and its flexibility to provide analytics capabilities to optimise any part of the organisation’s functions.
End User (Excel)
You will learn how to use the interface efficiently and its integration with Excel to build spreadsheet reports utilising data stored in IBM PA.
Advanced Reporting (Excel)
This course is a deep dive into the most formative reporting type in IBM Planning Analytics, Dynamic Report. You will learn to take advantage of Dynamic Report’s consolidation expandability and automated format definitions, essential features you need to know.
End User (PAW)
PAW (Planning Analytics Workspace) is a web-based application that provides data visualisation capabilities and advanced planning functionalities. In this course, you will learn important end-user features covering data interrogation, data manipulation, importing data and building a dashboard from scratch.
End User MDX (PAW)
When retrieving a list of members in a dimension or analysing cube data, IBM Planning Analytics utilises the language Multidimensional Expressions (MDX) to query the TM1 Server. There is an advantage in understanding how to read and write MDX for end users, as it will provide extra controls to enhance report building in Excel and dashboards in Workspace.
End User (Slice)
Slice is an Excel add-in that allows you to display and update values from a TM1 database using cell-based functions. This course will give you the fundamentals to begin utilising Slice.
Developer Pathway
Complete the End User Pathway
Before commencing the Developer Pathway, you must complete the End User Pathway that teaches how to utilise the IBM Planning Analytics’s interface for Excel and Workspace.
Developer Fundamentals
This is the first course for those who want to be a Developer. The Developer Fundamentals course will teach the tools needed for dimension building, cube design, data loading and writing business logic. This course will also benefit end users who want to understand the logic used to develop the model for transparency and integrity.
Advanced Rules
This course is a deep dive into writing Rules, a formula-driven language that applies business logic to Cubes. By the end of this course, you will gain more confidence in writing arithmetic formulas to formulas with multi-cube logic. You will also learn why the TM1 Server is appreciated for its ability to handle data sparsity and how to manage this powerful feature.
Advanced TurboIntegrator
This course is a deep dive into utilising the TurboIntegrator (TI), a tool for importing data, manipulating objects like dimensions and modifying data to apply business logic. By the end of this course, you will gain more confidence in utilising TI on the TM1 Server.
Advanced MDX
This course is a deep dive into MDX (MultiDimension eXpression), a language used to query the TM1 Server for extracting data and structure. Understanding how to read and write MDX will enable you to enhance Excel reports beyond the standard Dynamic Report export. It would also put you on the right step to learning TM1py since understanding MDX is fundamental.
TM1py Fundamentals
TM1py helps to bridge external systems to IBM Planning Analytics (PA) through the power of Python. Python has an ever-growing package collection that can be used to enhance IBM PA, like infusing AI and forecasting algorithms into the planning cycle to reduce time and costs. This course will equip you with the fundamentals to take advantage of Python using TM1py.
Pulse Fundamentals
Pulse is an application lifecycle management software for IBM Planning Analytics with many features to monitor the TM1 Server. To ensure you get the most out of Pulse, this course will teach you the most advanced features to keep your server in peak condition.
Apliqo UX – Apliqo Certified Professional
Apliqo UX is a platform that transforms IBM Planning Analytics into a visual masterpiece and allows you to collaborate efficiently through notifications. UX has sophisticated templates for reporting, planning, and analysis to visualize information dynamically and communicate the results to all stakeholders, regardless of device.
Apliqo UPM – Apliqo Certified Professional
Apliqo UPM (Unified Performance Management) is a suite of software solutions that offers functional excellence in strategic performance, financial performance, operational performance and financial consolidation while providing sophisticated integrations that allow for true holistic business planning and performance management. This certification focuses on the proficiency of Apliqo C&C and Apliqo FPM.