SAP BI Online Training

We are providing excellent online training on SAP BI by the real time experts at affordable price.

Here is SAP BI Online Training Course Contents:

Introduction to SAP BI

Business Information Warehouse

OLTP Vs OLAP Systems

Architecture of BW and BI

Discussion about SAP R/3 Master and Transaction Tables

Discussion about Sap Applications

Data Warehousing Workbench

Discussion about Info Area, Sub Info Area, Different

Types of Info Catalogs

Types of Info Objects(Characteristic, Key figure, Time, Unit and Technical Info Objects)

Creating Attributes(Display and Navigational Attributes)

Hierarchy and Types of Hierarchies

Data Modeling

Star Schema and Extended Star Schema Discussion

SAP Data Modeling – ERM Modeling and MDM Modeling

Creating Basic Info Cubes

Discussion about Business Content and its advantages

Grouping Type and Activation procedure for

Standard Objects

Meta Data Repository – Activated and Standard Business  Content Objects

Loading of Master Data

Discussion about Data Source, types of Data Sources and PSA

Creating Master Data Sources for attributes and text for flat file

Discussion about transformation and creating transformation

Discussion about DTP , Info Package and Data Monitoring

Loading of transaction data from FLAT file

Data Flow for loading transaction data

Discussion about transformation, types of transformation rules and transformation groups.

Discussion about Start Routine, End Routine and Expert Routine

Discussion about error DTP and Reloading of cleansed data

Currency conversion types and applying currency conversion in Transformation rules

Aggregates and BI accelerator

Discussion about aggregates and BI Accelerator

Creating Aggregates, roll up

Attribute change run and compression of Aggregates

Day-8

Multi Providers and info sets

Data store object

Discussion about DSO and its architecture (Activation queue, change log and active data table)

DSO benefits and types of DSO

Creating standard DSO and creating Transformation and DTP to cube and load delta data form DSO to Cube

DSO delta Management

Deleting  request from change log and selective deletion

Activation of application component hierarchy in R/3

Activation of standard business content data sources

Creating generic data sources in R/3 system for master data and transaction data

Replication of data sources

Loading master and transaction data from Sap R/3 system

LO Cockpit

LO Cockpit overview and LO data flow

Setting up of statistical data setup and loading historical data and load init run  .

Update methods, delta extraction with v3 update

Project ,logistics and sales data extractions using LO

Discussion about enhancement of data sources using customer exit

Transportation

System landscape –Dev, QA and Production

Discussion about development class, transport request and transportation.

Practical on releasing objects and transportation

Analysis and reporting in BI

Introduction to BW reporting

Bex query designer, applying selections, filters creating new queries, changing and deletion

Query context menu, drill down, drill across, sorting

Restricted and calculated key figures , exceptions and conditions

Variables ,characteristic variables ,text variables, formula variables ,hierarchy variables and hierarchy Node variables

Integrating hierarchies in to reports

Analysis toolbar and design toolbar

Variables processing type-Replacement  path ,customer exit and sap exit

Document integration in reports and report to report interface

Bex web application designer ,web template ,web items properties

Report designer