ONLINE Training starts Sunday May 11, 2008

Quality Training at Very Reasonable Price

For more info, please contact Rashmi at sapsansaar@gmail.com

SAP Business Information Warehouse (BI) Class Overview

1. General Overview of SAP Systems

• SAP System Architecture
• SAP System Landscape

 2. General Overview of BI

• Integration of Business Intelligence capabilities in SAP NetWeaver
• Architecture and functions of BI
• BI business content and BI metadata repository
• Enterprise Data Warehousing
• Enterprise Reporting, Query & Analysis
• Overview of the most important objects (InfoObjects, InfoProviders etc.) of BI and their attributes
• BI Objects Defination
• DataWarehouse Workbench
• Components of the data flow and extraction of data from SAP source systems or additional data sources in BI
• Benefits and use of Business Content
• Introduction to the administration of BI data targets
• New Objects and enhancements in BI ( From BW 3.x)

 3. BI Modeling:

• Creating a requirements analysis
• Developing a BI data model
• Star and Extended Star Schema
• Activating Business Contents and analyzing them
• Modeling InfoObject
• Master Data Characteristic with Attribute, Text and Hierarchy
• Modeling InfoCube, InfoSet, DSO, VirtualCube and MultiProivder
• SID Tables, Dimension Tables and Fact Table
• DSO Tables
• Master Data Tables
• Logical InfoProviders and Physical InfoProviders
• Enhancing/changing the data model, remodeling
• Aspects of an enterprise data warehouse architecture
• Special modeling and Data Warehousing aspects
• Best Practices (Do’s and Don’ts) on Modeling
  

4. BI Data Acquisition (Extraction, Transfer and Load)

• New Data Flow Process in BI
• Data flow in BI Data Acquisition (Data Transfer Process)
• Transformations in BI (such as translating units of measure)
• Direct access
• Real-Time Data Acquisition
• Data Source creation for SAP and Flat File Systems
• Enhancing BI Content Data Sources
• Delta management
• Data extraction and Transformation methods from
• From SAP Systems
• Flat Files
• DB Connect, UD Connect and Web Service
• Lo Cockpit
• Activating Logistics data sources from Cockpit
• Initial setup of Logistics data sources
• Scheduling jobs for those data sources
• Replicating data sources
• Define and manage Process Chains

5. BI Performance and Monitoring

• Optimize Performance on Data Load
• Optimize  Performance on InfoProviders
• Compression
• Logical Partition
• Physical Partition
• Remodeling
• Aggregation and rollup aggregation
• BI Statistics
• Enabling Statistics
• Monitoring BI Stat
• Monitor query performance
• Optimize Performance on Query
• BI accelerator
• Transport management

 6. BI Reporting and Analysis

• Reporting Tools
• Business Explorer Suites
• BEx  Analyzer
• Query Designer
• Report Designer
• Web Application Designer
• Creating reports from Query designer
• Simple and advanced queries
• Reports with restricted key figures, Formulas, variables, exceptions, conditions and more
• Executing reports from BEx Analyzer and Web Analyzer
• Configuring report to report interface ( RRI)
• Information Broadcasting

 7. Some Extra Topics

• BI Security and Authorization
• Open Hub formally known as InfoSpoke
• Process Chain
• Enterprise Portal Integration
• Information Lifecycle Management

 8. Others:

• Homework is based on real business scenarios
• Group and Individual exercises
• Weekly Assignments
• Hands on training
• Lots of related and helpful documents are given to all students
• One or two case studies for whole modeling and data loading process
• Conference call with Instructor at least once a week during training and after training if needed
• Suggest students on interview questions
• Mock interview