SAP-BW/BI Training

SAP-BW-BI Online Training

SAP Introduction

  • History of SAP
  • Evolution of ERP
  • ERP Packages
  • SAP R/3 System – ERP Backbone
  • SAP R/3 Modules – SD, MM, FI
  • Types of other ERP Packages in Market
  • Advantages of SAP ERP Compared to other ERP Packages
  • SAP R/3 (or) ECC Reporting
  • Limitations of SAP R/3 (or) ECC Reporting.

Sample SAP Case Study for Company

SAP Data warehousing

  • Introduction to Data warehousing
  • Father of Data warehouse
  • Definition of Data Warehousing
  • Key functions of Data Warehousing
  • Applications & Types of SAP
  • Types of Applications ( OLTP & OLAP)
  • OLTP vs OLAP
  • Types of Data in SAP
  • Entity Relationship Modelling & Multi Dimensional Modelling
  • Star Schema and Extended Star Schema

 SAP BW/BI Introduction

  • Introduction to SAP BW/BI
  • History of SAP BW/BI
  • Necessity of SAP BW/BI

 SAP BW/BI Architecture

  • Source System & Target System
  • Source system connections
  • Data Modelling, Extraction & Loading
  • Data Reporting

SAP BW Data Modelling

  • Data Warehousing Workbench
  • Info Objects & Types of Info Objects
  • Info Area
  • Info Object Catalog
  • Application Component
  • Activation of Business Content
  • Master data & Transaction data
  • Data Source, Info Source
  • Data transfer methods for SAP Systems(PSA and IDOC)
  • Info cube
  • DSO/ODS
  • Info Set
  • Info Provider
  • Multi Provider
  • Transformation
  • Routines
  • DTP
  • Info Package
  • Open Hub Destination
  • Transfer Rules
  • Update Rules
  • Authorisations
  • Roles

SAP BW Data Extraction

  • Application Specific Extractors( BW Content Extractors & Customer Generated Extractors)
  • Cross Application Specific Extractors ( Generic Extractors)
  • LO Extraction
  • COPA Extraction
  • Data Extraction using other tools
  • BW Data Source Enhancement

SAP BW Data Loading & Scheduling

  • Introduction to Process Chains
  • Process Chains in SAP BW/BI
  • Types of Views in Process Chains
  • Process Chain Creation
  • Process Chain Monitoring
  • Return Codes & Errors in Process Chain

BW Data Reporting

  • Bex Query Designer
  • Bex Analyzer
  • Bex WAD
  • Restricted & Calculated Key figure
  • Filters
  • Rows & Columns
  • Free & Filter Characteristics
  • Types of Variables
  • Conditions & Exceptions

SAP BW Data Transportation

  • System Landscape
  • Transportation Landscape
  • Overview of Transports
  • Objects Collection in Transports
  • Sequence of Transports Migration
  • Transports Collection & Setting
  • Transport Issues

SAP BW Performance Tuning Techniques

  • Aggregates
  • Partitioning
  • Compression
  • PSA and DSO Change Log Table Deletions
  • BI Accelerators

SAP Interview Perspective and Knowledge Sharing Discussions

  • SAP OSS Notes
  • SAP Marketplace
  • SAP Developer Forum
  • SAP Issues Forum
  • SAP Certifications
  • SAP Teched

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message