For SAP Training, Remote SAP Access or online SAP Access learn more by clicking on the links above. SAP BI ( formerly known as BW ) is the enterprise data mining and reporting tool specifically suited for extracting and reporting out of SAP.

Additional Freebies – Along with the training we provide the following additional services.

1. One Month of BW functional support (After training, During the practice).
2. Mock Interviews.
3. Interview Tips.
4. Resume Marketing

Intended Audience – SAP BW is intended for any of the following audience.

1. Experienced Business Users who have been working in Data Mining or as research analysts who deal extensively with data.
2. Experienced ABAP users who wish to get into Business Intelligence.
3. Less than 1 year of experience in SAP BW as a functional consultant.

Table of Contents

Basics of SAP , Business Data Warehouse (Week 1 )

• Basic SAP GUI Navigation
• Data warehousing Need – with an Example.
• SAP History
• SAP BW vs Other Data warehousing Tools
• SAP BW vs SAP BI
• SAP BW Terminology
  • Master Data
  • Transaction Data
  • Landscape
• Areas of SAP BW
  • Extraction
  • Modeling
  • Reporting
• Data Warehousing Categories
• SAP BW & EDW
  • 2-Dimensional Modeling
  • Multi Dimensional Modeling ( Star Schema )
  • SAP BW Star Schema ( Extended Star Schema )

Administrator Workbench ( Week 2 )

• Administrator Workbench ( AWB ) { RSA1 }
  • Info Area
  • Info Object Catalog
  • Info Objects ( Building Blocks )
    • Characteristics
    • Key Figures
  • Application Component Area
  • Info source, Types – Flexible , Direct
    • PSA ( Persistent Staging ARea )
    • Source System
    • Data Source
    • Info Package
    • Flat file extraction ( Master Data )
  • Extract Structure
  • Transfer Structure
    • Transfer Rules ( Types )
  • Communication Structure
    • Update Rules ( Types )
  • Data Targets
    • ODS
    • Info Cubes, Types
    • Multiproviders

Reporting ( Week 3 )

• Business Explorer
  • Bex Query Designer
  • Bex Analyzer
  • Restricted Key Figure
  • Free Characteristics
  • Filters
  • Variables
  • Calculated Key Figures
  • Navigation Options
  • Customer Exits
  • SAP Exits
• Extraction
  • LO Cockpit ( LBWE )
  • Generic Extraction ( Master Data Upload )
• Web Application Designer
• RRI ( Jump Reports )
• Solution Manager
• Transportation

SAP BI ( Business Intelligence ) 7.0 – Data Modeling (Week 4 )

• Data Warehouse Workbench Types of Data
  • Master Data
  • Transactional Data
  • Meta Data Data Model
  • BI Master Data Tables
  • BI Transaction Data Tables
  • Star Schema
  • Extended Star Schema
  • SID Tables
  • Structure of Dimension Tables
  • Dimension Modeling BI Objects
    • Info Area
    • Info Object Catalog
    • Characteristics / Attributes
    • Attribute Types
    • Time Characteristics
    • Unit Characteristics
    • Technical Characteristics
    • Key Figures Info Object Definition
  • Attribute Types
    • Time Characteristics
    • Unit Characteristics
    • Technical Characteristics
  • Key Figures Info Object Definitio