SAP BW/BI Online Training
Introduction To Data warehouse:
· Data warehousing/ BW/ BI Introduction
· Overview of SAP R/3
· Importance of SAP BI.
· Versions of SAP BI
· Data Ware Housing Concepts
· SAP System Landscape
· OLTP vs. OLAP
· SAP BI Architecture
· Star Schema Concepts – Star Schema Vs Extended Star Schema
· Enterprise Data Warehouse Modeling:
· Objects in SAP BI
· Info Area, Info Object Catalogs
· InfoObjects: Definitions
· - Types: Characteristics, Key Figures, Time, and Unit
· Data Loading Using Flat files - Master Data & Attributes ,Text Data , Hierarchies Data
· Transaction Data
· PSA, Transformation
· Creation of InfoCubes
BI SUITE: Reporting
· Introduction
· BEx Web Application Designer
· BEx Report Designer
· Rows and Columns
· Free Charsterstic & Filters
· How to create Queries.
· How to Restrict Characteristics,
· Formulas
· Exception Cells
· Query Design:
· Defining Exceptions,
· Conditions,
· Restricted Key Figures
· Calculated KeyFigures
· Variables:
· Variable Types(Characteristic Variable, Text Variable , Formula Variable, Hierarchy Variable & Hierarchy Node and its Processing Types,
· Component Properties:
· Properties of Characteristics, Attributes, KeyFigures Properties, Global Query Properties, Copying queries between Cubes, Deleting Query Elements
ETL: Extraction Transforming & Loading
Generic Extraction -
· Table
· View
· Infoset
· Function Module
LO Data Extraction – Customization & Migration Steps
Non - LO Extraction
Update Types : Direct Delta ,Queued Delta Serialized & unsterilized V3 Update
COPA Extraction
FI-GL, AP, AR, & FI-SL Extraction
Data Source Enhancement for LO & Non LO.
Advanced Modelling Topics in SAP BW/BI
InfoCubes: Definitions - Types: Standards, real time, remote Cube
DataStore Objects (DSO): - Types: Standards, Write optimized DSO, Direct update DSO
InfoSets
MultiProviders: Scenarios to create
Infocube VS DSO
Metadata and Doc Management:
· BI Content: Definitions, how to install BI contents
ABAP for SAP BW/BI Consultant
· Field level Routine
· Start Routine
· End Routine
· Expert Routine
· Info package level Routine
Process Chains
· Introduction of Process Chains , Process Types & Groups .
· Meta Chain
· Direct & Background Job scheduling
· Monitoring Process Chains
· Message Integration – Success, Error Message
· Including Delete, create indexes
· Scheduling & Cancelling Process Chains
· Scheduling Process chain in background
· Process Chain Monitoring Techniques How to Schedule Process Chains daily, weekly, monthly
Transport Connection
· System Landscape: - Collecting Objects, Create Transport request, Releasing transport request, Importing Transport request & Error handling, Project Types
Performance Optimization:
Loading Performance
AggregatesCompressionPartitions,Line Item DimensionIndexes
Query Performance
Modeling ConceptsQuery DesignPartitioningCompressionAggregatesQuery Read Mode
Implementation Project
· Project Plan/ Preparation
· Business Blue Print
· Requirement Gathering (URS & FRS )
· Development
· Production
· Technical & Functional Specs
Support Project
· Monitoring Techniques (Daily, weekly & Monthly jobs)
· Handing Tickets
· Various Support Issues & its resolution
· Standard Naming convention in SAP- BI
· OSS Note & Discussion Groups
SAP BW/BI Certification Guidelines
Guiding for SAP BW/BI Certification - Sample questions and documentation for HANA certification provided.
Guiding Resume Preparation & Tracking Interviews