Compendium Centrum Edukacyjne

Understanding IBM Planning Analytics data
• Understanding models
• Understanding cubes
• Understanding dimensions
• Understanding views
• Understanding sets

Creating books
• Creating books
• Adding content
• Creating new sheets
• Saving, closing, and opening views

Creating and saving views
• Compare two views of the same cube
• Create new views
• Save a view

Changing the way data is displayed
• Move and filter dimensions
• Show different levels of detail
• Create an asymmetric view
• Display cells as percentages
• Add top or bottom filters
• Show attributes for dimension members

Displaying specific members by using sets
• Display existing sets
• Add, remove, and reorganize members in a set
• Find members by using searches and filters
• View attributes
• Save sets
• Edit a set

Adding calculations to views
• Add summary calculations
• Add member calculations
• Remove and rename calculations

Highlighting exceptions by using conditional formatting
• Apply conditional formatting
• Add an additional condition

Entering data
• Distribute data to multiple cells by using data spreading
• Enter and hold data using quick commands
• Copy and paste and use calculations
• Add a comment to a cell

Experimenting with data by using sandboxes
• Creating sandboxes
• Comparing sandboxes
• Committing data and deleting sandboxes

Working with spreadsheets online by using websheets
• Find and add websheets to your book
• Explore websheets

Formatting for reporting
• Creating a new view
• Formatting the view for reporting

Exploring data by using visualizations
• Examine different visualizations
• Customize a visualization

Creating dashboards
• Adding and reusing objects
• Synchronizing objects
• Navigating the book and perform tasks by using buttons
• Changing the appearance of a view
• Hiding information
• Proven Practices for Dashboards

Examining performance by using scorecards
• Reading scorecards
• Adding scorecards to a book

Exporting data
• Exporting a view to Microsoft Excel

Introduction to IBM Planning Analytics for Microsoft Excel
• Examining report types

Exploring data in Planning Analytics for Microsoft Excel
• Connect to a system, and add an Exploration
• Display different dimension members
• Modify and save the view

Create reports easily by using Quick Reports
• Convert an Exploration to a Quick Report
• Drag a view to add a Quick Report
• Synchronize reports by using cell referencing
• Change members on rows or columns
• Add columns or rows and apply styles
• Apply custom formatting

Expanding and formatting members by using Dynamic Reports
• Create and explore a Dynamic Report
• Formatting the Dynamic Report
• Rebuild the Dynamic Report

Exploring TM1 functions
• Examine the TM1 functions in a Dynamic Report
• Derive rows based on saved sets
• Derive rows based on MDX
• Create custom format definitions
• Create custom columns
• Add new sections and multiple Dynamic Reports to a single sheet

Creating Custom Reports
• Create two custom reports
• Combine the two reports

Entering Data in Planning Analytics for Microsoft Excel
• Entering data in cube viewer
• Entering data in Dynamic Reports
• Entering data in Explorations and Quick Reports
• Using Sandboxes to experiment with data

Simplify tasks by using action buttons
• Enable action buttons
• Add an action button to navigate to another worksheet
• Edit an action button
• Create an action button that rebuilds a worksheet

Creating websheets
• Publish a websheet
• Manage websheets
• Add the websheet to a Planning Analytics Workspace book