• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

SAP BI

SAP BI / SAP Business Intelligence

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 Area4. Info Object Catalog
  • Application Component6. 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