SAP BW/ BI Training

Share course

Introduction to SAP

  • Introduction to SAP Net weaver and  Architecture
  • BW Versions
  • Importance of BI
  • Types of Data
  • Introduction to SAP R/3 or ECC
  • Introduction to Data Warehousing
  • Introduction to SAP BI
  • Difference between SAP R/3 and SAP BI
  • Flow diagram for SAP BI
  • Entity Relationship Model and Multi dimensional Modeling

BI Modeling

  • Info Area
  • Info Object Catalog
  • Introduction to Objects
  • Types of Objects
  • Characteristic
  • Attributes
  • Types of Attributes
  • KPIs
  • Time Characteristics
  • Units
  • Developing of Info Objects
  • Creation of Attributes
  • Making of Info Objects as Targets

Introduction to Business Content

Difference between Info providers and Data Targets

Introduction to Source systems

Types of Source Systems

Introduction to App Comp

Introduction to Data Sources

Types of Data Sources

  • Creation of Data Sources
  • Managing of Data Sources

Introduction PSA

Master Data Loading


  • Field Mapping
  • Transformation Rules
  • Field Routine
  • Start Routine
  • End Routine
  • Expert Routine

Info package

  • Info package Settings
  • Filters in Info package
  • Routine in Info package
  • Info Package Monitoring
  • Manage of Data Source/PSA
  • Types of Info packages


  • DTP Monitoring
  • DTP Settings
  • Routine in DTP
  • Filters in DTP
  • Types of DTPs
  • Error DTP
  • Debugging of Routines
  • Semantic Group

Text Data Loading

Hier Data Loading

Data Loading from Work Station

Data Loading from Server

Data Loading using Logical File

Logical File Creation

Loading Data from Different Sources  to one Target

Loading Data from one Source to Many Targets

Manage of Master Data

Activation of Master Data

Introduction Transaction Data Targets

Data Store Objects

  • Types of DSOs
  • Development of DSO
  • Settings in DSOs
  • Data loading to DSOs
  • Data Activation for DSO
  • Tables in DSOs
  • DSO Manage
  • Administration of DSO
  • Data mart Status checking
  • Activation logs checking
  • Delta process in Std. DSOs
  • Analysis Process Designer
  • Loading Data from One Target to another Target
  • Data deletion from DSO

Introduction to Info Cube

  • Multi Dimensional Modeling
  • Introduction to Ext. Star Schema
  • Difference between Star and Ext. Star Schema
  • Different Types of Info cubes
  • Modeling/Designing of Info cube
  • Loading data to Info cube
  • Management of Info cube
  • Different tables in Info cube
  • Indexes
  • Compression
  • Roll up
  • Statistics
  • Aggregates
  • Partitioning
  • Re-Modeling
  • Re-Partitioning
  • BI Accelerator
  • Loading Performance
  • DSO to DSO Loading
  • DSO to Cube loading
  • Data Acquisition
  • Data deletion from Info cube

Difference between DSO and Info Cube

Virtual Info providers

Multi Providers

  • Display Data from MP





  • Different Types Joins in Infoset
  • Display Data From Infoset

Difference between MP and Infoset

Process Chains

  • Designing of PCs
  • Types PCs
  • Managing of PCs
  • Process Types in PC
  • Logs in PCs
  • Monitoring of PCs
  • Automation of PCs

Info spoke

Open Hub Destination

  • Open Hub Destination to Work Station(File)
  • Open Hub Destination to Server(File)
  • Open Hub Destination using Log File

 Business Content

  • Introduction
  • Installation of BC
  • Activation BC objects
  • Enhancement of BC object


  • Introduction to Transport Connection
  • Collection of objects to Transport
  • Package Creation
  • Creation of Transport Request
  • Existing TR usage
  • Importing of TR
  • Searching and Unlocking of TRs

Data Archiving

Integrated Planning

Data Extraction from R/3 Source

  • Introduction to Extractions
  • Business Content Extractors
  • Installation of BC Data Sources
  • LO Cockpit
  • Types of Structures
  • Delta mechanism & Administration
  • Setup tables
  • Deletion and Filling process
  • Full Loads
  • Delta Loads
  • Delta Initialization
  • Repair Full Load
  • Update Methods
  • V3 Job
  • Generic Extraction
  • FI-Extraction
  • CO-PA
  • MM Extraction
  • Data Source Enhancement

BEx Reporting

  • Introduction to Reporting
  • Components in Reporting tool
  • Query Analyzer
  • Filter
  • Rows
  • Columns
  • Free Chars
  • Selections
  • Formulas
  • Restricted KF
  • Calculated KF
  • Structures
  • Conditions
  • Exceptions
  • Variables
  • Types of Variables
  • Processing Types
  • Writing of Customer Exit
  • Offset
  • Cell Editor
  • Hierarchy uasge
  • Reporting on different Info providers
  • BEx. Analyzer
  • BEx Browser
  • RRI
  • Query Analysis
  • Query Performance
  • BEx Broadcaste
  • Web Application Designer
  • Work books

Maintaining of Authorizations

BW/BI Related ABAP

  • Basic ABAP
  • Data Dictionary
  • ABAP Code writing
  • Debugging Techniques
  • Internal Tables
  • Function Modules

BW 3.x ver

  • Data flow
  • Loading process
  • Migration of 3.x ver to 7 ver

Function Modules Overview

  • SD Overview
  • MM Overview
  • FICO Overview

Project Course Contents

  • Landscape
  • Implementation Projects
  • Support Projects
  • Issues
  • Roll out upgrade and migration projects
  • Documentation
  • Technical Specifications
  • Functional Specifications
  • Ticketing tools
  • Resume Preparation
  • Interview Oriented Guidance

Web Application Designer

  • Web Items
  • Web Report using BEx Report
  • Scripting in WAD

DB Connection Flow

BO Overview

  • Crystal Report
  • WEBI tool

HANA Overview


Key Highlights


  • Makemyclass is a leading online training provider across the globe. Our online training team is highly qualified, experienced and skilled with real time      industry experience.

Makemyclass highlights:


  • Instructor Led Online Courses  with 24x7 On-Demand Support
  • World Class Trainers with +12 years Industry Experience. Instructors are not just trainers they are Consultants
  • We provide  24/7 Server access to help our trainees practice exercises
  • Teaching Material Prepared by Experts from Makemyclass who have real time experience
  • Hands on Lab Assignments
  • 100% Placement Assistance
  • Project Based learning to get hands-on experience on a real life application!
  • Providing high quality interactive and cost effective online Training
  • Live Interactive classes by industry experts.

Trainer Information:


  • Having 10  years of  IT Industry Experience
  • 6  years  of SAP BW/ BI Experience
  • Having  3 yrs experience  as an online trainer for SAP BW/ BI
  • Held up to 70+ batches in past 3 years
  • Trainer has an excellent practical & industrial knowledge