SAP BI Training
The Online BI Training COURSE CONTENT includes following
Part I: Data warehousing
Data warehouse concepts and Overview
- OLTP Vs OLAP
- ETL
- Star Schema
Business Warehouse Concepts and Overview
- Business Warehouse Architecture
- Extended Star Schema
- Data Storage
- Data Acquisition
- Reporting and Analysis Tools
Part II: Data Modeling
Info Objects of Business Warehouse
- InfoArea
- Info Object
- InfoObject Catalog
- Info Object Definitions
- Characteristics
- Key Figures
- Time and Unit
Data Storage of Business Warehouse
- InfoObject as Infoprovider
- DataStore Object (DSO) Types
- Standard Infocube and Remote cube
- Info provider’s: MulitProvider and Infoset.
- Open Hub Destination
- Analysis Process Designer
- Remodeling
Understanding Business Content
- Business Content
- How to install BI contents
Part III: Extraction, Transformation and Loading
ETL Overview
- R/3 Data ETL Process
- Flat File ETL Process
- Monitor
- Source System
Master Data Process
- Master Data (Attributes, Texts and Hierarchies)
- Transformations
- Info Package
- Creation of Data Transfer Process (DTP)
Transaction Data Process
- R3 / Flat File Data
- Delta Extraction
- Standard BC Datasource
- Custom Table Extraction
- Enhancement of Datasource
- Creation of Data Transfer Process (DTP)
- Info Package
- Process Chain
Part IV: Reports and Analysis Tools
BEx Query Designer and Analyzer
- Query Properties
- Variables: variable wizard, variable types and processing types.
- Restricted Key Figures
- Calculated Key Figures
- Cell Definition
- Conditions and Exceptions
- Filters
Part V: House Keeping Principles and Performance of Query and BI system
Delete PSA, Change log and Process chain Logs.
- DB Statistics
- Rollup, Aggregates
- Compression
- Archiving
Part VI: Overview of Transportation, Supporting and Implementation.
Part VII: Overview of BI 7.3 Topics