1 |
End User |
End User (Excel) |
Learn to explore data to be a proficient analyser and get to know all the reporting possibilities in Excel. |
IBM Planning Analytics or Perspectives |
8 hours |
Beginner |
No prerequisite |
1. How to use the interface 2. How to analyse Cube data 3. How to use the Dimension 4. How to use the Subset 5. How to use each report types 6. How to export data to Excel 7. How to use an Action Button 8. How to publish a report 9. An introduction to TM1 Web 10. An introduction to Data Spreading |
Plans |
2 |
End User |
End User (PAW) |
Explore how to analyse data, utilise hierarchies and create dashboards for the web, using Planning Analytics Workspace (PAW). |
IBM Planning Analytics Workspace |
8 hours |
Beginner |
No prerequisite |
1. An overview on the interface
2. How to analyse data
3. How to use hierarchies
4. How to trace the data’s logic
5. How to use drill through
6. How to use data spreading
7. How to use the sandbox for planning
8. How to create a dashboard from scratch
9. How to set up visualisation
10. How to importing data |
Plans |
3 |
End User |
Advanced Reporting (Excel) |
Learn the intricacies required to create dynamic reports in Excel. |
IBM Planning Analytics or Perspectives |
8 hours |
Intermediate |
End User (Excel) |
1. How to build a report from scratch
2. How to manipulate the Dynamic Report
3. How to set up filters
4. How to add charts
5. How to use Action Buttons
6. How to set up dynamic columns
7. Key Excel functions you should know
8. Best practice principles for report building
|
Plans |
5 |
Developer |
Developer Fundamentals |
Learn the fundamentals of dimension building, cube design, data loading, writing Rules and TurboIntegrator processes. |
TM1 Server and Architect |
8 hours |
Intermediate |
End User (Excel) and Advanced Reporting (Excel) |
1. Best practice foundations
2. How to develop Dimensions
3. How to maintaining Dimensions
4. How to create Cubes
5. An introduction on how to write Rules
6. An introduction loading data via TI
7. How to setup user and group security |
Plans |
6 |
Developer |
Advanced TurboIntegrator |
Learn how experts use TurboIntegrator (TI) to write code beyond the restrictions provided by the wizard. |
TM1 Server and Architect |
8 hours |
Expert |
Developer Fundamentals |
1. TI programming principles
2. How to understand Data Sources
3. How to use Variables
4. How to create and destroy objects
5. How to use the Prolog tab
6. How to use Parameters
7. How to build Views and Subsets
8. How to use the Metadata tab
9. How to use the Data tab
10. How to load data
11. How to use Bedrock processes |
Plans |
7 |
Developer |
Advanced Rules |
Learn how to write multi-cube logic and clearly understand how feeders work to ensure an efficient model. |
TM1 Server and Architect |
8 hours |
Expert |
Developer Fundamentals |
1. The fundamentals for writing Rules
2. How to use Feeders
3. How to use operators
4. Key Rule functions you should know
5. How to use strings in a Rule
6. How to feed to and from consolidations
7. How to write advanced Feeders
8. How to reference data in another Cubes
9. How to write a currency translation rule
10. How to write a moving balance rule |
Plans |
8 |
Developer |
Advanced MDX |
Learn how to write advanced MDX within TM1 and client applications such as PAW and Planning Analytics for Excel to control the data received. |
IBM Planning Analytics, Architect and Arc |
8 hours |
Expert |
Developer Fundamentals |
1. MDX syntax explained
2. How to use MDX in the Subset Editor
3. How to use MDX in TurboIntegrator
4. How to use MDX in Excel
5. How to use MDX in Exploration View
6. How to use MDX in Arc
7. How to use MDX logging
8. Key supported expressions
9. How to use MDX to filter Cube data
10. How to use the ‘generate’ function
11. Do’s and don’ts in MDX |
Plans |
9 |
Developer |
TM1py Fundamentals |
The ideal foundation to get you started with developing your own Python and TM1py scripts. |
TM1py and Python |
8 hours |
Intermediate |
Developer Fundamentals and basic Python knowledge (link) |
1. Getting to know the TM1py package: interface and documents
2. How to read TM1 data with Python
3. How to update metadata and synchronize dimensions and hierarchies
4. How to write data to TM1
5. Dot the i’s and cross the t’s: Make your TM1py script production ready |
Plans |
10 |
Developer |
Pulse Fundamentals |
Learn the functionalities that comes with Pulse such as live monitoring, user analytics, Excel analysis, documentation, migration and proactive alerts. |
Pulse v6 |
8 hours |
Beginner |
End User (Excel) and Developer Fundamentals |
1. How to use Pulse’s interface
2. Business cases that you should know
3. How to audit applications
4. How to manage the development process
5. How to report on the server's status
6. How to document the TM1 Server
7. How to administer the TM1 Server |
Plans |
11 |
Developer |
Apliqo UX Fundamentals |
Learn how to create a modern, curated web experience for your IBM Planning Analytics/TM1 users. |
Apliqo UX |
8 hours |
Intermediate |
End User (Excel)
and
Developer Fundamentals |
1. How to understand the architecture
2. How to create a dashboard
3. How to utilise widgets
4. How to set up the display settings
5. How to implement a chart
6. How to use interactivity between widgets
7. How to use pop-ups
8. How to change dashboard settings
9. How to implement views
10. How to utilise advanced table options
11. How to apply formatting to the application
12. How to utilise advanced chart options
13. How to add a wizard
14. How to add a process to the application |
Plans |