SAP BI Online Training covers Data extraction logics in R/3, data warehousing concepts like extraction, transformation and creating data logics in BW Data extraction from the SAP source systems and flat files.  

SAP BI Online Training also covers Support activities of SAP BW/BI and real time issues, SAP BW/BI Online Training covers Implementation of SAP BW system SAP BW 3.5 WITH BI 7.0

SAP BW 3.5 WITH BI 7.0

• DATA WAREHOUSE OVERVIEW
• Understanding Data warehousing Methodology.
• OLTP vs. OLAP.
• DSS Functionality.
• Requirement Analysis of BW.
• Versions of BW
• INTRODUCTION TO BW/BI
• Overview of SAP R/3 Environment
• BW/BI Architecture
• Landscape of BW
• ERM
• MDM
• Star Schema
• Extend Star Schema
• Fundamental differences between above models .
• SID Tables
• Dimension Tables
• Fact Tables.

DATAWARE HOUSE WORK BENCH

• Administrator Workbench (BW3.x) vs. Data ware House Workbench (BI7.x)
• Functionality of Data ware House Workbench.
• Modeling
• Administration
• Transport Connection
• BI Content
• Translation
• Metadata Repository

SAP BW/BI DATA MODELS

• Info Area
• Info Object Catalogue
• Info Objects:
• Characteristics: Display, Navigational, Transitive, Compounding Attributes
• Key Figures: Cumulative and Non-CumulativeKey Figures
• Info Cube
• ODS (BW3.x) vs. DSO (BI 7.x)
• Requirement Analysis of DSO
• DSO Types: Standard, Write Optimized, Direct Update
• Virtual Providers vs. Data Targets
• Data Mart Concept
• Multi Providers
• Info sets
• Virtual Providers
• Aggregation Levels
• Info Cube Types: Standard vs. Real time info cube
• Basic vs. Virtual Providers

FLAT FILE DATA EXTRACTION

• Maintaining Data source
• Managing PSA
• Maintaining Transformation
• Maintaining Info source
• Maintaining D.T.P
• Maintaining Info Packages

BI CONTENT

• Understanding BI Content Requirement
• Identify BI Content
• Install BI Content - Delivery to Active Version
• Precautions while Installing
• Customizing Business Content
• Usage of Best Practice’s
• SAP R/3 EXTRACTOR Using BW3.x And BI 7.x ETL Process
• SAP R/3 Reporting vs BW Reporting
• Configuring R/3 Connection
• Types of R/3 Extractors
• BI Content Extractor
• Extracting Master data, Text Data, Hierarchy Data and Transaction Data
• Generic Extractor
• LO Cockpit
• CO-PA Extractors
• FI-SL Extractors
• Enhancement of Standard Data source.
• Writing Enhancement Code in Customer Exit
• Real Time Data Acquisition
• Data Reconciliation
• Extract Checker
• Delta Que Maintenance
• Real Time Scenarios, Functional and Technical Specs & Project Work
• TRANSFORMATIONS
• Transformation Types
• Using Routines in Transformations
• Start Routine
• Expert Routine
• End Routine
• Currency CONVERSIONS
• BW/BI REPORTING

Introduction to BEX components.

• Query Designer
• Query Elements
• Filters, Structures, Selections, Formula’s, Restricted Key figures, calculated
• Key figures, Hierarchies, Exceptions, Conditions, Variables, Variable Types,Variable processing types
• BEX ANALZER

Bex Web Analyzer

• Properties of Query’s
• Work Books, Query Views
• Designing work books
• Report to Report (R/RI) Interface
• BEX WEB Application Designer
• Web Items
• Properties, creating simple web Templates,Creating Dash Boards

Support Activities

• Aggregates,
• BIA
• Maintain Info cube
• Maintain DSO
• Attributing Change Run
• Process Chains
• Load monitoring
• Query Monitoring
• Analyze & Repair Database Objects
• Statistics
• production support issues while Monitoring Data Loads