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.

Register

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.

Register

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.

Register

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.

 

 

 

Stay in the loop

Keep yourself informed on the latest news in the analytics space by following us on LinkedIn.

For any enquires, email us at edu@cubewise.com or contact an office near you (link).