Introduction:-
 
What is Enterprise Resource Planning (ERP)?
          
Why Data Warehousing: Need

• Data warehousing Definition
• Data warehousing Categories
• Data warehousing Theme
• Comments of Data warehouse
• Data Provider Layer(DPL)
• Service Provider Layer(SPL)
• Information Consumer Layer (ICL)
• Data warehouse Management Layer (DML)       
  ERP Vs Data warehousing Business Intelligence (IBI)
                       Fact Based Systems (FBS)

SAP History:

SAP BW Vs other Data warehousing Tools.

• SAP BW Vs SAP BI

SAP BW TERMINOLOGY:                                       Top

• Master Data.
• Transaction data.
• Reference: Data.
• Landscape.
• Development (Initial Implementation).
• Quality (testing and Assurance).
• Production (Information Consumption).

Areas of SAP BW:

• Extraction.
• Modeling.
• Reporting.
• Architecture-Three Layers.

SAP BW as Extraprise Data warehouse (EDW)-Real Time Example
.
Theories Representing the Model:

• Two Dimensional Modeling.
• Multi Dimensional Modeling.
• SAP BW STAR SCHEMA (EXTENDED STAR SCHEMA).

Data Modeling: - BW Server Layer                          Top
Administrator Work Bench (AWB) (RSA1)

• Info area.
• Info Object Catalogue.
• Info Objects (Building Blocks).
• Characteristics.
• Key figures.
• Application Compliment area.
• Info Source, types of data staging-Flexible, Direct.
• PSA (Persistent Staging Area).
• Source Systems- Types.
• Data Source –Types.
• Info Package.
• Flat File Extraction (Master Data).
• Extract Structure.
• Transfer Structure.
• Transfer Rules.
• Communication Structure.
• Update Rules.
• BW Architecture- Source System to Data Targets.

Info Providers (data Targets)
Creation of ODS (Operational Data Store)

• New Data.
• Active Data.
• Change Log.

Creation of Info cubes (Transaction data upload)

• Contents.
• Performance.
• Requests.
• Rollup.
• Collapse.
• Reconstruction.
• Multi Providers.                                            Top

Reporting: Presentation and Analysis Layer
         Business Explorer (Bex) (RRMX).

• Bex Query Designer.
• Bex Analyzer.
• Restricted Key Figure.
• Free Characteristics.
• Filters.
• Variables.
• Calculated Key Figure.
• Exceptions.
• Conditions.
• Navigation Options. 

Extraction: -

• Logistics Extraction Cockpit (LBWE).
• Steps to Extract.
• Background Procedure.
• Generic Extraction.
• Controlling and Profitability Analysis (KEBO).

ADDITIONAL TOPICS:

• Business Content.
• Hierarchies.
• Navigational Attributes.
• Compounding.
• Aggregates.
• Types of Upload-Full, Delta.
• Data Monitoring (RSMO).
• Header.
• Status.
• Detail Tab strips.
• Open Hub Interface (RSBO)-Info spokes.
• Data Mart Interface – Real Time Example).
• Process Chains (RSPC).
• Business Add In’s (Badin’s) (SM19).
• Over View on Functional SD, MM Tables R/3 Knowledge.
• Frequently used Transaction Codes (T-Codes).

      REAL TIME ISSUES:-                                          Top 

• Real Time Requirements.
• Implementation Process.
• Real Time Based Practical Training.
• Interview Questions.
• How to Answer Interview Questions.
• Practical Examples.
• Communication Skills.
• Real Time Project Based Terminology.
• Interaction with Faculty (Feedback).
• BW Material (Hard and Soft Copies)- Suggested Readings and Websites.
• Who are looking for you- IT Companies Looking for BW Trainees and    Consultants.
                                                                 Top