SAP Business Intelligence ( SAP BI/BW )

WHAT IS IT ABOUT ?

SAP Business Intelligence (SAP BI) also earlier known as SAP Business warehouse (SAP BW) is the centrepiece of SAP’s Analytics and data warehousing solution. It’s used for Analysis and reporting on Enterprise data aiding them to make decision that will accelerate operations and growth in the competitive business environment. Using this tool you can consolidate, combine and transform information from other SAP application and external sources and create dynamic reporting solution. SAP BW provides a platform for an enterprise with which we can evaluate and interpret information.

Course Overview

Who is it for ?


  • IT Analysts
  • Any programming language specialists
  • Reporting Analyst
  • Any one working on Reports and Data
  • Database Administrators
  • Aspiring BW Consultants

Pre Requisites


  • A general understanding of IT terminologies

What will you learn ?


1. 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 all 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.

2. SAP Case Study:

3. SAP Data warehousing: 

  • Introduction to Data warehousing
  • Fundamentals of Data warehouse
  • Definition of Data Warehousing
  • Key functions of Data Warehousing
  • Applications & Types of SAP
  • Difference between OLTP vs OLAP
  • Types of Data in SAP
  • Multi Dimensional Modelling
  • Star Schema and Extended Star Schema

4. SAP BW/BI Introduction:

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

5. SAP BW/BI Architecture: 

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

6. SAP BW Data Modelling: 

    • Data Warehousing Workbench
    • Info Objects & Types of Info Objects
    • Info Area
4. Info Object Catalog
  • Application Component
6. 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

7. SAP BW Data Extraction: 

  • Application Specific Extractors(BW Content Extractors & Customer Generated Extractors)
  • Cross Application Specific Extractors ( Generic Extractors)
  • LIS Extraction
  • LO Extraction
  • COPA Extraction
  • Data Extraction using other tools
  • BW Data Source Enhancement
  • SAP BW Data Loading & Scheduling – 3 Hours
  • Introduction to Process Chains
  • Process Chains in SAP BW/BI
  • Types of Views in Process Chains
  • Process Chain Creation
  • Process Chain Monitoring

8. 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

9. SAP BW Real Time/Project Scenarios: 

  • Production Support Issues
  • Implementation Project Issues
  • Migration/Up gradation Project Issues
  • Tickets Handling
  • Batch Jobs Monitoring
  • Ticketing Tool Tracker.
  • SAP BW Clients & Projects Discussions:
  • Importance of SAP BW Projects in Market
  • Type of Domain Industries & Clients using SAP BW/BI

10. SAP BW Data Transportation: 

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

11. SAP BW Performance Tuning Techniques: 

  • Aggregates
  • Partitioning
  • Compressions
  • PSA Table Deletions
  • BI Accelerators

12. SAP Knowledge Sharing Sessions: 

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