End User (Excel)
Prerequisites: No Prerequisites
Difficulty: Beginner
Training course on how to use IBM Planning Analytics with Excel as end user. Choose from either Perspectives or Planning Analytics for Excel (PA for Excel).
Modules:
– Learn how to get around the interface
– Learn how to explore and analyse data
– Learn how to use the subsets for exploration
– Learn how to create Excel reports
– Learn how to use data spreading for planning
– Learn how to use sandbox for planning
– Learn to use TM1 on the web with TM1Web
Table of Contents for Perspectives:
– Introduction to TM1
– Log into TM1
– TM1 Overview
– Cubes and the Cube Viewer
– Dimensions and the Subset Editor
– Slicing and Snapshotting from the Cube Viewer
– Building TM1 Excel Reports
– Active Forms
– Data Spreading
– Sandboxing
– TM1Web
Table of Contents for PA for Excel:
– Introduction to Planning Analytics for Excel
– How to log into PA for Excel
– Planning Analytics for Excel Overview
– Cubes and the Viewer
– Dimensions and the Set Editor
– View Types
– Exploration
– Quick Report
– Dynamic Report
– Custom Report
– Best practice principles for building reports
– List
– Action Button
– Publish
– TM1 Web
– Data Spreading
– Sandboxing
Choose the training style that suits you:
Classroom
How it is taught
Trainer led with up to
8 students
Duration
1 Day
Occurrence
Once a month in Sydney
Once bi-monthly in other locations
Tools Provided
Printed Material and
Training Server
Learning Style
Learn better with a tutor.
Can dedicate a day to the course.
Self-Paced
How it is taught
Self taught with 1-hour
of mentoring
Duration
7 Days
Occurrence
Start on any date
Tools Provided
Printed Material and
Training Server
Learning Style
Fit in learning with work.
Learn anywhere and anytime.
Online Classroom
How it is taught
Self taught with 1-hour
of mentoring
Duration
7 Days
Occurrence
Start on any date
Tools Provided
Printed Material and
Training Server
Learning Style
Fit in learning with work.
Learn anywhere and anytime.
How it is taught
Trainer led with up to
8 students
Self taught with 1-hour
of mentoring per course
Trainer led
Duration
1 Day per course
7 Days per course
Two half days, over two consecutive days per course
Occurrence
Once a month in Sydney
Once bi-monthly in other locations
Start on any date
Once a month
Tools Provided
Online Material
and Training Server
Online Material
and Training Server
Online Material
and Training Server
Learning Style
Learn better with a tutor.
Can dedicate a day to the course.
Fit in learning with work.
Learn anywhere and anytime.
Learn better with a tutor.
Learn anywhere and anytime.