SAP BI Online Training and Placement

Topic wise SAP BI Training Course Details:
Module SAP BI Course Topic
Introduction to SAP BI
About • SAP Landscape
• BW / BI Introduction
• Standard Naming convention in SAP- BI
• Transaction codes in SAP-BI
Module - 1 Data warehousing
Unit - 1 Data warehouse concepts and Overview
Topics • Basics of Data base
• OLTP Vs OLAP
• ER Model
• Star Schema
• Dimensions and Facts
• Transaction data tables and master data tables
Unit - 2 Business Warehouse Concepts and Overview
Topics • Business Warehouse Architecture
• Extended Star Schema
• DIM / SID Tables
• Introduction to SAP R/3 and BI
• Data Warehousing Work Bench
Module - 2 Data Modeling
Unit - 3 Info Objects of Business Warehouse
Topics • Info Object Catalog
• Info Area
• Creating Info Objects: Characteristics
• Creating Info Objects: Key Figures
• Info Object Definitions: Characteristics, Key Figures, Time and Unit
• Dimension / Key Figures
Unit - 4 Data Storage of Business Warehouse
Topics • Creation of Cubes
• Types of Cubes: Basic Cube / Transactional Cube, Virtual/Remote Cube Creation of DSO
• Types of DSO: Standard DSO, Transactional DSO and Write Optimized DSO
• Types of tables in DSO: Change Log, Active Table and New Table
• PSA
• Source Systems
• Transformation
• Data Transfer Process (DTP)
• Communication Structure
• Info Package
• Transfer Rules
• Update Rules
Unit - 5 Understanding Business Content
Topics • Business Content
• How to install BI contents
Module - 3 Extraction, Transformation and Loading
Unit - 6 Extraction from Different Sources System
Topics • Flat file loading
• SAP(R/3) Data Sources
• Non SAP (From ETL).
• Using the data mart interface.
• Master data loading (Attributes, Texts and Hierarchies)
Unit - 7 Transaction Data Process
Topics • R3 / Flat File Data
• From ETL
• Non SAP (From ETL).
• Full load .
• Initial Delta load
• Delta load
Unit - 8 Monitoring
Topics • Creating process chains
• Creation of Meta Chain
• Event Creation
• Checking process chain runs
• Jobs Scheduling
• Monitor for extraction processes and data transfer processes
• Important T codes for -Monitoring

Module - 4 Advance Data Modeling
Unit - 9 Data Transformation and Loading
Topics • Multi-Provider
• Aggregates
• Line-Item
• Info Sets
• Compression
• Indexes and Partition
• Info spoke and Open Hub service
Module - 5 Reports and Analysis Tools (Business Explorer)
Unit - 10 BEx Query Designer
Topics • Queries
• Query Design
• Variables
• Component Properties
• Structures
Unit - 11 Web Application Designer
Topics • WAD
• Web Applications
• Design
• Web Items
Unit - 12 Activities
Topics • Analyzer
• BEx Web Application Designer
• BEx Report Designer
Module - 6 Admin & Security
Unit - 13 Admin & Security
Topics • User Management
• Roles & Responsibilities
• Authorization Object
• Performance Tuning: Data Loading Performance, Query Performance
• Transports Organizer
Unit - 14 Advanced / general topics
Topics • ASAP Methodology
• Supporting
• FAQs
Module - 7 R/3 Extraction and Data loading
Unit - 15 Extractions and Data loading
Topics • LIS Vs LO Extraction
• LO Extraction
• Generic Extraction
• Types of Generic Extraction
• Delta Mechanism
• Enhancement in LO and Generic Extractions
Module - 8 ABAP Concept SAP-BI
Unit - 16 Routines SAP -BI
Topics • Routines
• Types of Routines
• Info package level Routines
• DTP level Routines
• Transformation level Routines


For more about SAP BI Course details please contact us