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
