Course Duration in Hours
60
60
SAP BW COURSE CONTENT
INTRODUCTION
Why SAP BW Important - with real time scenarios
In which scenario we can use - with real time scenarios
What is SAP BW with real time scenarios
DATA BASE usage and how Data base useful in SAP BW system
Standard naming conventions in SAP BI - with real time scenarios
Landscapes - with real time scenarios
Part 1: Business Warehouse
Data warehouse concepts and over view
OLTP Vs OLAP With Real time scenario
ETL
Extended Star schema: 1. Why star schema required, 2. How schema will use in real time, 3. How schema will work in back end, (all these are with real time scenarios)
Data warehouse data model design technics and Data mart (with real time scenarios) Business warehouse architecture
What is master data & What is transaction data (with real time scenarios)
Over view of complete BW objects, BEX designer, process chains
Creating Dimensions, and key figures: What is the perfect way to create Characteristic and Key Figure (With real time scenarios)
Hierarchies level: 1. In Real time scenario how Hierarchies will create, 2. In ECC how user will create hierarchies, 3. in BW how we can create Hierarchies apart from flat file
How we can create master data with flat files & what are the types of attributes and how can we use (with real time examples)
Complete details about Character properties and Key figure properties
Part 2:
What is Data source
Types of Extractors
How Data Source Mechanism will work in Real time
What is Delta
Types of Delta and how we can use Delta mechanism in real time
What is LO EXTRACTORS
Before LO extractors, how SAP BW handled Delta loads.
How business content Data source will work in real time
How Business content data source delta will work in real time
Few examples of real time
Part 3:
Overview of Info package
How data source properties will effect on Info package
Info package data selection fixed
Info package data selection dynamic
DSO Introduction:
How Data source will work in real time
How data load will happened in real time
Importance of New table, Active Table, Changelog table
DSO creation setting properties
Managing DSO
DATA MART
Types of DSOs and how they will work in real time
Scenarios of Performance improvement in real time
INFOCUBE
Types of Info cube
Over view of Info cubes with real time examples
How to create each info cubes and explanation about each one
Few of them Real time examples
Line Item dimension with real time example and how Line item will effect in real time
MULTI PROVIDER
What is Multi provider
How it will work in real time with some examples
How to create Multi provider
DTP SETTINGS
Introduction of DTP
Explanation of each TAB in DTP
What error handling and how it will work in real time with few examples
Few real time scenarios
TRANSFORMATIONS
Types of Transformations
Introduction
Start Routine
End Routine
Individual field level rules
Expert Routine
Important points to be noted
BEX QUERY DESIGNER
Introduction
How Bex will effect in real time
Details about each and every options with real time examples
Calculated Key figure, Restricted key figures, Filters, new formula,
Variables with examples
Query properties
Char properties
Key figure properties
RRI
Reporting tools how will effect in real time
PROCESS CHAINS
Introduction
How process chain will works in real time
How to create process chains
Scheduling in back ground
Real time examples.
Transportation
Introduction
How transportation process will work in Real time
Few real time examples
Performance improvement technics
Apart from the above Course:
Introduction about 3rd party tools
How 3rd party tools will work in real time
How loads will schedule in real time
Few real time example
Ticketing tools
Types of tickets
How to handle the tickets based on situation
Client handling technics
How to manage the activities when your in projects
Interview questions and how to answer those questions
Some techniques real time
Will Cover SAP HANA Basics as well (Including SLT and HANA STUDIO)
SVT TECHNOLIGY (SAP BW REAL TIME SUBJECT), Ameerpet (Hyderabad),Hyderabad,IN