Detailed overview of the Learning Objectives:
- The fundamentals
- Linking to various Data sources
- Understanding Bex queries.
- Understanding aDSOs, Composite providers...
- Understanding HANA calculation views
- Basics on SAP Analytics Cloud
- Creating Connections
- BO connection.
- NW connection.
- SAP Analytics Cloud
- Linking to various Data sources
- Reporting – the basics
- Creating workbooks
- Inserting a crosstab with data from different data sources
- Inserting a dynamic chart
- Inserting an Info Field
- Inserting a filter
- Protecting workbooks
- Saving a workbook
- Saving a view
- Analyzing data
- Opening a workbook
- Analyzing data with the design panel
- The analysis tab
- The information tab
- The components tab
- Different ways of showing members and showing totals
- Repeating members
- Show/hide zeros in rows and columns
- Workbook properties for prompting
- Filtering members
- Filtering measures
- Defining the display of members, measures and totals
- Include dimensions with hierarchies in an analysis
- Display single dimensions as a hierarchy
- Working with Grouping & creating a custom hierarchy
- Learn how to share the axis across multiple reports
- Using restricted measures
- Using advanced calculations
- Working with prompts and filters
- Sorting data
- Working with hierarchies
- Axis Sharing
- Set up Calculations
- Working with conditional formatting
- Commenting a data cell
- Creating Presentations
- Customize the user interface
- Reporting – Advanced
- Working with formulas
- Use the functions included in the add-in to build formulas to include data and meta data of used data sources into your analysis
- Working with API’s combined with VBA
- Working with formulas