SAP BI/BW(Business Information Warehouse)CONTENT Online Training

ExpertSoft Training's provides SAP BI/BW Online Training with certified experienced IT professionals who has more then 10+ Years of real time experience. Our trainers has good training's experience so that best quality output will be delivered. Our faculty is dedicated so that we can complete your course as per the schedule given Daily/Weekly at your convenience. We also allow you to record the classes from your end so that you can refer the classes once again when ever is required. We provide the Latest Version System Access with very good speed and 24*7 Support as well.

We provide classes through online by using Gotomeeting and Webex Systems. We also give Interview support & Technical support. We satisfied 1000's of Customers from different location USA, UK, SINGAPORE, INDIA, SOUTH AFRICA, AUSTRALIA, NEW ZEALAND, DUBAI. We trouble shoot your problems while you are working we address yours questions during the Online SAP BI/BW Training even after the course completion.

After completion of your courses we will help you to clear your interviews and also assist you to get certified on SAP BI/BW. We will give you 100% Satisfaction and We provide the best quality real time online training.


Overview and Concepts

  • Over view of SAP R/3
  • Necessity of SAP BW
  • Versions of SAP BW
  • Over view of SAP BW
  • OLAP and OLTP
  • Data Ware Housing Concepts
  • Landscape of SAP BW
  • Homogeneous + Heterogeneous
  • Integration of BW system with different systems
  • ERM + MDM + Star Schema
  • Extended Star Schema

Architecture of SAP BWb

Objects in SAP BW

  • Info Area + Info Objects Catalogs
  • Characteristics
  • Key Figures-Cumulative and Non Cumulative
  • PSA + Transfer Structure/Data Source
  • Transfer Rules
  • Info Sources/Communication Structure
  • ODS + Info Cubes
  • Types of Info Cubes + Update Rules

Data loading using flat files

  • Master data + Attributes data
  • Texts data + Hierarchies’ data
  • Transactions data + Delta data loading

Data filtration techniques

  • Transfer rules level
  • Update rules level
  • Start routines

SAP BI 7.0

Business Intelligence Concepts and Overview

Modeling: Data warehousing workbench
  • Components of Data Warehousing workbench
  • InfoObjects + DataSources
  • Types of DSOs + DataSources Repository
  • Migration of 3.*DataSources and recovery of 3.*


  • Differences between ODS(Operational Data Store) and DSO
  • Data Loading: Master Data
  • Attributes Datas Loading using flat files in BI 7.0
  • Texts Datas Loading using flat files in BI 7.0
  • Hierarchies Data Loading in 3.*
  • Concepts on Transformations
  • Controlling the Data flow with Info Packages

Data Transfer Process(DTPs)

  • Data flow concepts in SAP BI 7.0
  • Transactions Data Loading in BI 7.0
  • Flat files data loading to Info Cubes
  • Flat files data loading to DSO
  • Delta loading to Info Cube Via DSO


  • Standard + Direct
  • Write Optimized


  • Creating Transformations
  • Types of Transformations

Routines at Transactions

  • Field Level Routines + Start Routines
  • End Routines + Expert Routines

BEx Query Desinger

  • Introduction to BEx Query designer
  • Filters in the query
  • Characteristic Restrictions
  • Rows and Columns
  • Free Characteristics
  • Formulas –Calculated KeyFigures
  • New Selection-Restricted KeyFigures
  • Structure + Hierarchies
  • Attributes + Navigational Attributes
  • Variables + Text Variables
  • Characteristics Variables
  • Different Types of Variables
  • Conditions + Exceptions
  • Cell Definitions
  • Report to Report Interface(RRI)
  • How to use replacement path and customer exit


  • Customer exit Programs
  • Properties of the Components

Web Application Desingner

  • Creating Web Template
  • Web Items
  • Properties of Web Template
  • Table + Text Elements
  • Generic Navigation Block
  • Drop down boxes
  • Radio Buttons and Check boxes
  • Filters + List of Exceptions
  • Conditions + Integrating with the charts
  • Ad-hoc Query designer

Business Explorer Analyzer

  • Introduction to BEx Analyzer
  • Filters in BEx Analyzer
  • Drag and Drop Function
  • Various functions used in Analyzer
  • Creating New Workbook

Demo project

Types of Project

  • Project Preparation + Blue print phase
  • Requirements Gathering
  • Functional Spec design
  • Technical Spec Design
  • AS IS Process
  • Unit testing
  • Integration Testing
  • Final preparation
  • Cutover activities

Up-gradation Project

  • Up-gradation check list
  • Activities to be performed during up-gradation

Enhancement to the existing Implementation

  • Activities in enhancement to existing

Implementation project

Support Project

  • Various support activities
  • Handling Tickets
  • Support issues/errors
  • Resolving support issues

Advanced Topics in BI 7.0

  • Modeling/Remodeling
  • Partitioning/Repartitioning
  • Data Mart
  • Open Hub Destinations
  • SAP-BO

Why Choose Us

  • Empower your SAP end users with SAP training courses.
  • Provides centralized managerial and administrative support services.
  • Professional training accomplished the past 12 years
  • Training courses are designed as per the current industry standards
  • After training complication candidate can go for certification exams
  • Trainers are certified professionals with 10+ years of experience