SAP BW-BI

SAP BW TRAINING

SAP BW/BI TRAINING COURSE CONTENT


SAP BW 3.5

  1. Overview & Concepts
  • Overview of SAP R/3
  • Necessity of SAP BW & Version of BW
  • OLAP & OLTP
  • Data Ware Housing Concepts
  • Landscape of SAP BW
  • Integration of BW system with different systems
  • ERM, MDM, Star Schema& Extended Star Schema.
  1. Objects in SAP BW
  • Info Area, Info Object Catalogs
  • Characteristics
  • Key Figures-Cumulative & Non Cumulative
  • PSA- Transfer Structure/Data sources
  • Transfer Rules
  • Info Source/Communication Structure
  • ODS- Info Cubes
  • Types of Info Cubes- Update Rules
  1. Data Loading Using Flat Files
  • Master Data – Attributes, Texts, Hierarchies
  • Transaction data-Delta data loading
  1. Data Filtration Techniques
  • Transfer Rules level
  • Update Rules level
  • Start Routines
  1. PSA-Maintenance scheduling the data
  • Data Packet by Packet
  • Complete scheduling
  • Scheduling in background
  • Transfer Rules & Update Rules
  • PSA-Processing Types
  • Monitoring & scheduling  data loading
  • Scheduling the jobs on periodic values

SAP-BI 7.0/7.3/7.4

  1. Overview & Concepts
  • Overview of SAP R/3
  • Necessity of SAP BW & Version of BW
  • OLAP & OLTP
  • Data Ware Housing Concepts
  • Landscape of SAP BW
  • Integration of BW system with different systems
  • ERM, MDM, Star Schema & Extended Star Schema.
  1. BI7.3/7.4 Concepts & Overview
  • Data warehousing workbench
  • Components of data warehousing workbench.
  • Difference B/w BW and BI.
  1. Modelling
  • Types Of Data.
  • Master Data Loading
    1. Attribute Data Loading
    2. Text Data Loading
  • Transaction Data Loading.
    1. Info cube Data Loading and Its Concept.
    2. DSO &Difference between ODS & DSO
    3. Standard DSO
    4. Direct DSO
    5. Write Optimized DSO.
    6. Multi provider.
    7. Info set
    8. Open Hub Destination.
  • Concepts of Transformation & Its Types
  • Controlling the data-flow with Info packages (IP)& Data Transfer
  • Process(DTP)
  • Open Hub & Performance Issue
  • Deleting data from data target
  • Query performance & Load Performances

9.Excerise for Lab.

  1. Types of Info Cubes, Info Sets, Multi Provider
  • Open Hub& Performance Issue
  • Deleting data from data target
  • Query performance & Load Performances

11.Excerise for Lab.

  1. Extraction
  • Flat file Extraction
  • LO or Logistic Extraction
  • Generic Extraction & Generic Delta

1.Using Table Extraction

2.Using View Extraction

3.Using Info set Query Extraction

4.Using Functional Modular Extraction

  • FI-SL, Co-PA, DB Connect
  • Business Content Extraction
  • Data Enhancements- Tables, View, Query
  1. Exercises for Lab.
  2. BI 7.4 Reporting
  • BEx Query Designer
  1. Introduction of BEx Query
  2. Filters, Columns & Rows
  3. Characteristic Restrictions & Free Characteristics
  4. Formulas & Calculated Key Figures
  5. Restricted Key figures & Variables with Texts.
  • Web Application Designer
  1. Creating Web Templates
  2. Web Item & properties
  3. Drop-down Functions
  4. Condition & Integration
  5. Business Explorer Analyzer
  6. Introduction to BEx Analyzer
  7. Filtering Option
  8. Properties Available in Analyzer
  • Report Designer
  1. Creating Reports
  2. Formatting columns & Rows
  3. Changing font styles with background colour.
  4. Inserting Rows & columns
  • Bo Reporting with BW data
  1. Induction and Concept
  2. Universal designers
  3. Webi
  4. Deski
  5. Crystal Reports etc

15.Excerise for Lab.

16.Business Content

  • a)Important of business Content
  • b)Business Content Installation & Activation
  • c)Business Content Data Source, DSO’s, Cubes, Reports, etc…
  1. Meta Data Repository
  • Important of Metadata Repository

18.Process Chain

  • Types of Process Chains
  • Process Groups & Meta Chain, etc…
  1. Transport Mechanism
  • Review of system Landscape
  • Collecting Objects
  • Creating Transports
  • Releasing Transport
  • Importing Transport
  • Monitoring Transport
  1. Authorization Concepts
  • Authorization
  1. Integrated Planning
  • Introduction & Planning Application- On web, MS Excel

22.Excerise for Lab.

  1. Types of Projects

a)Real Time Implementation Projects

b)Up-Gradation project

c)Enhancements to the existing Implementation project

d)Support project

  1. Advanced Topics in BI 7.0
  • Analysis process Designer
  • Modelling/Repartitioning
  • Data Mart
  • Open Hub Destination
  • Info set
  • Multi provider
  1. Real Time Implementation Projects

26.Module

  • System landscapes
  • SAP BW-Bo landscape
  • SAP ERP Landscape
  • Non ERP Systems landscape
  • Database landscape
  1. Exerciser for Lab.
  2. Post Test

Pre-requisites

LAB Setup for BW/BI:

  1. All Machines with Windows Server2008 64 bit OS.
  2. With 8GB RAM.
  3. With VMWARE Workstation 8.0.
  4. MS-Office 2007 and Adobe Reader Installed.
  5. SAP-BODS Image should be copied in all the Machines.

Note:- VMWARE Image will be sent 5-7 days before the training through Hard drive/USB.