Subject: SAP BW-BI

Location: Farmington Hills, Michigan

Duration: 40 Hours

Start Date: Jul 10th, 2010

Fee: $2500.00

Learn from an expert instructor. Our expert instructors are themselves have years of experience in the real world as well as in teaching. A large majority of our instructors are Full-time consultants and provide solutions to a wide variety of companies.

Topics to be covered

• Introduction:
  • Intro to ERP
  • Intro to SAP
  • Why SAP
  • Different SAP systems
  • Overview of Modules in SAP
  • Navigation in SAP (using SAP GUI)
  •  Intro to SAP Netweaver 2004 & 2004s systems
• Data Warehouse & Modeling:
  • OLAP vs OLTP
  • Star Schema, Extended star schema
  • Master Data – Attribues, Text, Hierarchies
  • Transaction Data.
  • InfoObjects – Characteristics, KeyFigures, Unit & Time
  • InfoCubes – Basic
  • ODS/DSO, PSA
  • MultiProviders & InfoSet
  • DataSource, InfoSource, InfoPackage
  • InfoCube Administration
• Extraction:
  • Extracting Master Data – Attributes, Texts,
  • Extracting Transaction data
  • Flat file extraction
  • Generic Extraction
  • LO Extraction
  • BC Extraction
  • Monitoring the data loads
• Reporting:
  • Intro to Query Designer
  • Intro to BEx Analyzer
  • Calculated & Restricted key figures
  • Exceptions & Conditions
  • Variables (and types)
  • Web Application Designer
  • Web Templates
  • Web items
• Performance Tuning & Administration:
  • Aggregates & Rollup
  • Compression
  • Navigational Attributes
  • Line Item Dimension
  • Partitioning
  • Transport Management
  • Process Chains
• SAP Netweaver 2004s (BI 7.0):
  • New GUI object Navigation
  • BI System Upgrade
  • Migration of  dataflow from BW 3.x to BI 7.0
  • New concept of DataSource
  • OpenHub Destination
  • (new) DSO types
  • Transformation & DTP