1. Understanding IBM Planning Analytics data
- Understanding models
- Understanding cubes
- Understanding dimensions
- Understanding views
- Understanding sets
2. Creating books
- Creating books
- Adding content
- Creating new sheets
- Saving, closing, and opening views
3. Creating and saving views
- Compare two views of the same cube
- Create new views
- Save a view
4. 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
5. 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
6. Adding calculations to views
- Add summary calculations
- Add member calculations
- Remove and rename calculations
7. Highlighting exceptions by using conditional formatting
- Apply conditional formatting
- Add an additional condition
8. 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
9. Experimenting with data by using sandboxes
- Creating sandboxes
- Comparing sandboxes
- Committing data and deleting sandboxes
10. Working with spreadsheets online by using websheets
- Find and add websheets to your book
- Explore websheets
11. Formatting for reporting
- Creating a new view
- Formatting the view for reporting
12. Exploring data by using visualizations
- Examine different visualizations
- Customize a visualization
13. 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
14. Examining performance by using scorecards
- Reading scorecards
- Adding scorecards to a book
15. Exporting data
- Exporting a view to Microsoft Excel
16. Introduction to IBM Planning Analytics for Microsoft Excel
17. 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
18. 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
19. Expanding and formatting members by using Dynamic Reports
- Create and explore a Dynamic Report
- Formatting the Dynamic Report
- Rebuild the Dynamic Report
20. 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
21. Creating Custom Reports
- Create two custom reports
- Combine the two reports
22. 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
23. 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
24. Creating websheets
- Publish a websheet
- Manage websheets
- Add the websheet to a Planning Analytics Workspace book