SSNIT SOLUTIONS

DATAWAREHOUSE Technology



SAP Introduction-2 Hours

  1. History of SAP
    2. Evolution of ERP
    3.ERP Packages
    4. SAP R/3 System – ERP Backbone
    5. SAP R/3 Modules – SD, MM, FI
    6. Types of other ERP Packages in Market
    7. Advantages of SAP ERP Compared to other ERP Packages
    8. SAP R/3 (or) ECC Reporting
    9. Limitations of SAP R/3 (or) ECC Reporting.

SAP Case Study

SAP Data warehousing-2 Hours

  1. Introduction to Data warehousing
    2. Father of Data warehouse
    3. Definition of Data Warehousing
    4. Key functions of Data Warehousing
    5. Applications & Types of SAP
    6. Types of Applications ( OLTP& OLAP)
    7. OLTP vs OLAP
    8.Types of Data in SAP
    9. Entity Relationship Modelling&Multi DimensionalModelling
    10. Star Schema and Extended Star Schema

SAP BW/BI Introduction:-2 Hours

  1. Introduction to SAP BW/BI
    12. History of SAP BW/BI
    13. Necessity of SAP BW/BI

SAP BW/BI Architecture: 1 Hour

  1. Source System & Target System
    2. Source system connections
    3.Data Modelling, Extraction & Loading
    4. Data Reporting

SAP BW Data Modelling: 12 Hours

  1. Data Warehousing Workbench
    2. Info Objects & Types of Info Objects
    3.Info Area
    4.Info Object Catalog
    5.Application Component
    6.Activation of Business Content
    7.Master data & Transaction data
    8. Data Source, Info Source
    9. Data transfer methods for SAP Systems(PSA and IDOC)
    10. Info cube
    11. DSO/ODS
    12. Info Set
    13.Info Provider
    14. Multi Provider
    15. Transformation
    16.Routines
    17.DTP
    18.Info Package
    19. Open Hub Destination
    20. Transfer Rules
    21. Update Rules
    22. Authorisations
    23. Roles

SAP BW Data Extraction: 5 Hours

  1. Application Specific Extractors( BW Content Extractors & Customer Generated Extractors)
    2. Cross Application Specific Extractors ( Generic Extractors)
    3. LIS Extraction
    4. LO Extraction
    5. COPA Extraction
    6. Data Extraction using other tools
    7. BW Data Source Enhancement

SAP BW Data Loading & Scheduling – 3 Hours

  1. Introduction to Process Chains
    2. Process Chains in SAP BW/BI
    3.Types of Views in Process Chains
    4.Process Chain Creation
    5.Process Chain Monitoring
    6. Return Codes & Errors in Process Chain

BW Data Reporting – 5 Hours

  1. Bex Query Designer
    2. Bex Analyzer
    3.Bex WAD
    4. Restricted & Calculated Key figure
    5. Filters
    6.Rows & Columns
    7.Free & Filter Characteristics
    8.Types of Variables
    9. Conditions & Exceptions

SAP BW Miscellaneous Topics: 2 Hours

  1. SAP BW Reports through Enterprise Portal
    2. SAP BW/BI – BO Integration
    3. SAP BW/BI With HANA
    4. SAP BW/BI with BPC
    5. SAP BW/BI with Legacy systems
    6. SAP BW/BI Batch Job Monitoring Tools
    7. SAP BW/BI Issues Ticketing Tool
    8. Importance of SAP ABAP/4 & Basis in BW/BI

SAP BW Real Time/Project Scenarios- 1.5 Hours

  1. Production Support Issues
    2. Implementation Project Issues
    3.Migration/Up gradation Project Issues
    4.Tickets Handling
    5.Batch Jobs Monitoring
    10.Ticketing Tool Tracker.

SAP BW Clients & Projects Discussions: 1 Hour

  1. Importance of SAP BW Projects in Market
    2. Type of Domain Industries & Clients using SAP BW/BI

SAP BW Data Transportation: 2 Hours

  1. System Landscape
    2. Transportation Landscape
    3.Overview of Transports
    4. Objects Collection in Transports
    5. Sequence of Transports Migration
    6.Transports Collection & Setting
    7. Transport Issues

SAP BW Performance Tuning Techniques -2 Hours

  1. Aggregates
    2. Partitioning
    3.Compressions
    4.PSA Table Deletions
    5. BI Accelerators

SAP Interview Perspective Discussions – 30 Mins

SAP Knowledge Sharing Sessions – 30 Mins

  1. SAP OSS Notes
    2. SAP Marketplace
    3. SAP Developer Forum
    4. SAP Issues Forum
    5. SAP Certifications
    6. SAP Teched