• What is Analysis for Microsoft Office

• Connection

• Menu Bar

• How to insert datasource in AO

Workshop 1: Create AO Report

• Design panel

Workshop 2: Design Panel



• Filtering

Workshop 3: Use FILTER option

3.1 Use Filter by Measure

3.2 Use Filter by Member

3.3 Use Background Filter



Workshop 4: Upload filter value via file Sorting



Workshop 5: Use SORT option

5.1 Sort member

5.2 Sort measure Hierarchies



Workshop 6: Grouping members Display options



Workshop 7: Display Option

7.1 Display option for Dimension

7.2 Display option for Measure



Workshop 8: Renaming Dimensions, Measure



Assignment Part 1

• Conditional Formatting

Workshop 9: Formatting

9.1 Use table design feature

9.2 Define and Edit condition format Customer style set



Workshop 10: Custom Style Set

10.1 Define Custom Style Set

10.2 Change Formats Sequence

10.3 Export Style Set

10.4 Import Style Set Design rule



Workshop 11: Design Rule

11.1 Create a new line and formula

11.2 Fill cell with data

11.3 Add Price restriction Insert component



Workshop 12: Insert Component

12.1 Insert Dynamic Calculation

12.2 Insert Dynamic Chart

12.3 Insert filter component

12.4 Insert Info field

Workshop 13: Other Feature

13.1 Use Linking Dimensions

13.2 Shared Axis



Assignment Part 2