This certificate builds on the basic knowledge gained by a BI Consultant and preferably refined by practical experience within a BI team and the Consultant can implement this knowledge of the specialist areas practically in projects.
Introduction & DW Concepts
- What is SAP?
- DW concepts
- OLTP and OLAP concepts
- Star Schema
- Extended star Schema
Modeling
- Info Objects
- Info Cubes and DSO
- Overview of BI 7.3 Dataflow
- Transformation in BI 7.3(ETL)
- Routines (start, end and expert)
- Rule types
- DTP (Data Transfer Process)
Data acquisition from flat files
- Loading Transaction Data from Flat file to BI system ( Infocube, DSO)
- Loading Master Data from Flat File to BI system ( InfoCube, DSO)
Extraction
- CO-PA Extractions
- LO-COCK PIT Extractions (LOGISTICS)
- FI-SL Extractions (Financial special purpose ledger)
- Database Table
- View
- Classical Info sets
- Functional Module
- Delta Management
- Datasource Enhancement
Advanced Modeling
- Types of Infocube
- Types of DSO’s
- Multiprovider
- Infoset
- Virtual provider
- Hybrid provider
- Semantically portioned Object
Performance Tuning
- Compression
- Index
- Partition
- Line Item dimension
- High Cardinality
- Aggregates
- Rollup
- InfoProvider administration
Scheduling, Monitoring and Transports
- Process Chain
- Real time data Acquisition
- Transports and transport Errors
- Analysis Process Designer
- Open hub destination
Reporting
- Introduction to BI Enterprise Reporting.
- Navigating in Reports
- First Steps in Query Designer
- Query Designer
- Info providers in query Designer
- Exceptions
- Conditions
- New selection
- New formula
- Restricted Key Figures
- Calculated Key Figures
- Properties of Key Figures
- Structures and cell restriction
- Integrating attributes and hierarchies in reports
- Variables
- Characteristic Variables
- Hierarchy variables
- Hierarchy Node variables
- Formula Variables
- Text variables
- Variable Processing types
Advanced Reporting Topics
- Report to Report interface(RRI)
- Bex Analyzer
- Bex Web Analyzer
- Overview of Information Broadcaster
- Web Reporting using new Web Application Designer
Integration of BI tools with BW
- SAP Business Intelligence Platform Overview
- Working in BI Launch Pad
- UDT and IDT
Overview of BI reporting tools
- SAP BusinessObjects Web Intelligence
- Introduction to SAP BusinessObjects Web Intelligence
- Advanced Functions
- Web Intelligence and SAP NetWeaver BW DataSources
- SAP Crystal Reports
- Introduction to SAP Crystal Reports
- SAP Crystal Reports and SAP Data Sources
- SAP Crystal Reports for Enterprise and SAP BW as DataSource
- SAP BusinessObjects Dashboards
- Introduction
- Integration of SAP BusinessObjects Dashboards with SAP BW
Integrated Planning
- Overview of Integrated planning