SAP BI

User Avatar

SAP BI

10 weeks
All levels
0 lessons
0 quizzes
0 students

Requirements

  • 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 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

3. SAP BW/BI Introduction:

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

4. SAP BW/BI Architecture:

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

5. 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
  • Authorizations
  • Roles

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

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

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

9. SAP BW Data Transportation:

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

10. SAP BW Performance Tuning Techniques:

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

11. SAP Knowledge Sharing Sessions:

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