SAP BI

SAP BW/BI 7.0 Online Training Course

Duration: 3 – 4 Weeks

I. Introduction to SAP Business Intelligence

• BI Architecture / BI Platform
• Enterprise Data warehousing / Data Modelling
• Enterprise Reporting, Query and Analysis
• Data Acquisition / Data Extraction
• Star Schema and Extended Star Schema
  • Multidimensional Modelling
  • Entity Relationship Modelling

II.Enterprise Data warehousing

• Master Data Loading Attributes, Texts and Hierarchies
• Transaction Data Loading
• Types of Info provider
  • Info cubes
  • DSO/ODS Objects(Standard DSO, WriteOptimized DSO, Direct Update DSO)
  • Info objects as Info providers
  • Info sets (Inner-Joins, Outer-Joins, Temporial-Joins, Equi-Joins)
  • Multi providers
  • Virtual Providers
• Differentiating between 3.x version and 7.0 version.
• Open Hub Destination
• InfoSpokes
• Routines
• Business Content and its Relevance
• Performance Tuning
  • Aggregates
  • Compression
  • Rollup
  • Reconstruction
  • Indexing etc.
• Analysis Process Designer

III. Data Acquisition / Data Extraction

Logistics Extraction

• Generic Extraction (View AND Infoset Query)
• Enhancing Standard Data Sources
• Delta Mechanism
• COPA Extraction
• FI-SL

IV. Enterprise Reporting, Query and Analysis

• Introduction to BEX Query Designer/ BEX Analyser and other Reporting Tools
• Free Characteristic and Filter
• Restricted Key Figures and Calculated Key figures
• Variables and Structures
• Exceptions, Conditions, RRI
• Information Broadcasting and other Reporting Features
• Performance Tuning of Query
• Web Application Designer
• Bex Broadcaster
• Workbook features
• Roles and authorization

SAP BI Advanced Topics

• Creating Process Chains, Scheduling and Monitoring
• Remodeling of InfoCube
• Partition and repartition of InfoCube
• Transportation
• Support Project Issues

Project documentation and project environment overview.