SAP BW/BI ONLINE TRAIINING

Introduction 
BW overview and navigation
BW Data Modeling
BW Data Extraction
BW Reporting
BW Performance

Data warehousing
Unit 1: Data warehouse concepts and Overview
Architecture of DWH
OLTP Vs OLAP
ETL
ERM Model
Star Schema
Snow Flake Schema
Fact Constellation Schema
Measures, Dimensions and Facts

Unit 2: Business Warehouse Concepts and Overview
BW / BI Introduction
SAP Landscape
Standard Naming convention in SAP- BI
Extended Star Schema
DIM / SID Tables
Data Storage
Data Acquisition
Reporting and Analysis Tools

Data Modeling
Unit 3: Objects of Business Warehouse
Info Area ,Info Object ,Info Object Catalog
Info Object Definitions : Characteristics , Key Figures, Time and Unit
Transfer rules and Update Rules.
Dimension / Key Figures

Unit 4: Data Storage of Business Warehouse
Basic Cube / Transactional Cube
Virtual/Remote Cube
Multi-Provider
ODS / Data Store Object ( DSO )
PSA

Unit 5: Understanding Business Content
Business Content, How to install BI contents.

Extraction, Transformation and Loading
Unit 6: ETL Overview
R/3 Data ETL Process
Flat File ETL Process

Unit 7: Extraction Methods
Master data Loading from Flat File
Transaction Data Loading from Flat File to Infocube and DSO.
Logistics Extraction
Generic Extraction
Enhancing Standard Data Sources
Delta Mechanism
COPA Extraction
Loading data from ODS to CUBE, CUBE to CUBE.
Open Hub Destination

Unit 8: Performance Tuning: Data Loading Performance, Query Performance
Creating the first aggregate for an InfoCube
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

Unit 9: Process Chain
Defining Process chain
Creating Process chains

Scheduling and Monitoring
Checking process chain runs
Monitor for extraction processes and data transfer processes

Unit 10: Enterprise Reporting, Query and Analysis
Introduction to BI Enterprise reporting
Navigation in reports
First steps in the Bex query designer and Analyzer
Query designer
Infoprovider in the Bex query designer and Analyzer.
Key figures
Restricted Keyfigures
Calculated keyfigures
Properties of Keyfigures
Structures and cells
Properties and attributes of characteristic
Variables
Exception and conditions
Report –report interface

SAP Netweaver Business Intelligence (BI) overview

Overview on Difference between SAP BW to SAP BI.
1. Data Acquisition and Transformation from SAP Source Systems
Data Flow: Overview
Loading Master Datasource from an SAP source System
Loading Transaction Datasource from an SAP source System

2. Creation of:
Info Area, Infoobject Catalog, Infoobjects,
DataSource, Data Store Objects (DSO), Infocube, Infoset, Multiproviders.
Creating Infopackage, Creating Data Transfer Process and Transformations.

3. Data Acquisition from other systems
Extraction from Non sap systems: Overview
Flat file Loading
Transfer of Business content
Extraction from sap systems
Master data Loading from Flat File
Transaction Data Loading from Flat File to Infocube and DSO.
Logistic data acquisition
Generic data acquisition
Enhancement of BI content data source
Open Hub Destination
Loading data from ODS to CUBE, CUBE to CUBE.

4. Other Info providers
Data store objects
Virtual providers and Real time data acquisition
Multiprovider and BI Infoset
5. Reports Designer and Analyzer
New queries, Restricting Characteristics, Formulas and Exception Cells
Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures
Creating Re-usable structures

Brief about Web Reporting and Report Designer

6. Advance Topics in SAP BI
Remodeling
Repartioning
Real Time data acquisition.
Analysis Process Designer
DTP Types
Standard DTP
Direct DTP
Error Stack DTP
Real Time data acquisition DTP

7. Process Chain
Defining Process chain
Creating Process chains
8. Migration Data Flow from SAP BW 3.5 to SAP BI

Real Time Scenarios for Hands On Experience
Discussion on Error in Support Project and Implementation Projects
Discussing the challenges in SAP BI projects.
Discussing ASAP Methodology.
Documents as softcopy
Resume Preparation and Guidance on how to Face Interviews
Sample Interview questions