- 1. Data Modeling
- 2. Reporting
- 3. Data Extraction
- 4. Authorization
- 5. Performance Tuning & Process Chain
1. Data Modeling
- Architecture of SAP NetWeaver BI
- Benefits and use of the business content
- Overview of the most important objects
- Info objects
- Info Providers
- Properties
- Data Source – type and properties
- DSO- types and properties
- Info cube – types and properties
- Multi provider
- Info set
- Transformation – types and rules type
- Developing a BI data model
- Modeling data marts
- Enhancing/changing the data model
- Remodeling aspects of an Enterprise Data Warehouse architecture
- Open Hub Service
- Introduction to administration of BI data targets
2. Reporting
- Architecture and functions of the SAP BI analysis tools
- Navigation in SAP BI reports
- Creating query definitions with the BEx Query Designer and the BEx Web Analyzer
- Integrating key figures, characteristics, hierarchies, variables, properties, exceptions, and conditions in the query definitions
- Using the BEx information broadcaster to distribute reports
- Integrating documents in reports
- Configuring report-report interfaces
- Presenting reports in MS Excel or HTML
- Using predefined reports from the SAP Business Content
- Report layout
- Using different web items to create demanding web applications
- Creating formatted reports that are optimized for presentation and printing
- Using GIS functions to display data on maps
- Advanced options and settings options in the BEx Information Broadcaster
- Using the advanced options in MS Excel
- Introduction to modelling analytical applications using the Visual Composer
3. Data Extraction
- Data acquisition
- Data flow in BI
- Transformations
- Delta management
- Enhancement of Business Content Data-Sources
- Process of extracting data from SAP source systems
- Data staging via different interfaces
- Real-time data acquisition
- Direct access
- Unit of measure conversion
- LO Cockpit
- UD Connect
- DB Connect
4. Authorization
- User management & authorizations
- Architecture and strategies for a BI authorization concept
- Security requests in SAP BI
- Creating authorizations for reporting
- Administrative tasks
- Source systems
- Planning environment
5. Performance Tuning & Process Chain
- Aggregates, Rollup and Compression etc.
- Basics for optimizing query performance
- BI accelerator
- Details about Process chains