This module of SAP covers a number of topics and is taught in a steady manner. Initially learners are provided with a case study. A practical case study is integrated to help a pupil understand the real functionalities of SAP BI.
After students have an understanding of a case study, they are introduced to the various terminologies of OLAP such as Business Content Objects, ERP, ETL, ODS, Multi provider and Cubes.
Thereafter, candidates are taught about system environment so that they have an in-depth knowledge. They get familiar with system backdrop, coding of transaction, metadata repository and business packets.
Course Details
- Title : SAP BW/BI Online Training
- Category : Technical
- Duration : 40 hrs
- Timing : Week Days: 2 hrs per day (OR) Weekends: 3 hrs per day
- Method : Online Training
- Study Material : Would be Shared
- System Access : For 1 Months
Course Content for SAP Business Intelligence
SAP BI - Introduction to SAP Netweaver 2004s (7.0 BI) system
- BI Architecture / BI Platform
- OLAP v OLTP
- Enterprise Data warehousing / Data Modelling
- Enterprise Reporting, Query and Analysis
- Data Acquisition / Data Extraction
Data Modelling
- Objects in the BI DW layer
- Modeling characteristics and key figures
- Modeling ODS/DSO Objects and InfoCubes, Open Hub Service
- Transaction Data Loading
- Master Data Loading Attributes, Texts and Hierarchies
- Administration of Data Targets
- Types of Info provider
- Info cubes
- DSO/ODS Objects
- Info objects as Info providers
- Info sets
- Multi providers
- Virtual Providers
- Star Schema and Extended Star Schema
- Multidimensional Modelling
- Entity Relationship modelling
- Differentiating between BW 3.x version and BI 7.0 version.
- Open Hub Destination
- Write routines in transformations and debugging routines
- Business Content and its Relevance
- Performance Tuning
- Aggregates
- Compression
- Indexing etc.
- Process Chains and other Modelling Features
- Transport Management for BI Objects
Data Acquisition / Data Extraction
- Overview of Data Staging in SAP BI-BW Content
- Data Acquisition & Transformation from SAP Source Systems
- Delta Management
- Flat file Extraction
- Logistics Extraction
- Generic Extraction
- Enhancing Standard Data Sources
- Delta Mechanism
- FI- SL Extraction
- COPA Extraction
- Data Transfer with the service API , DB Connect , UDC and Third party ETL Tools
Enterprise Reporting, Query and Analysis
- Introduction to BEX Query Designer/ BEX Analyser
- Free Characteristic and Filter
- Restricted Key Figures and Calculated Key figures
- Variables and Structures
- Exceptions, Conditions, RRI
- Information Broadcasting and other Reporting Features
- Performance Tuning of Query
- Brief about Web Reporting and Report Designer
Performance
- Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent BW Statistics: Query Analysis Tools, Performance Tables Reporting Performance: Effective query
- design, Line-Item, Compression, Partitioning
- Aggregates: Creating Aggregates, Finding effective aggregates
- Data Load Performance: Parallelism, Impact of Aggregates
- Partitioning: Logical Partitioning, Table Partitioning