SAP BIW/BI Training and Course Content
Modeling:
1. SAP Net Weaver and BI: Overview, Positioning and Fundamentals
Fundamentals of Data warehousing and Business Intelligence
SAP Netweaver Business Intelligence (BI) overview
SAP Netweaver Solution Delivery: IT Practices, scenarios and usage Types
SAP NetWeaver Business Intelligence: Data Warhousing Overview.
2. Objects in the BI Data Warehouse Layer
Data Warehousing Workbench
Infoproviders: Business Purpose
Infoobjects: Characteristics
Infoobjects: Key figures
The BI Infocube: An extended Star Schema
Creating Infocubes
3. Data Acquisition and Transformation from SAP Source Systems
Data Flow: Overview
Loading Master Datasource from an SAP source System
Loading Transaction Datasource from an SAP source System
4 Data Acquisition from other systems
Extraction from Non sap systems: Overview
Flat file Loading
5 BI Content
BI content discovery
BI content Activation
6 Other Infoproviders
Datastore objects
Virtual providers and Real time data acquisition
Multiprovider and BI Infoset
7 Administration of Data Targets
System administration tasks in BI: Overview
Administration of infocubes
Administration of Datastore objects
Process chains
8 Introduction to query Performance Optimization
Introduction to query Performance Optimization in BI
BI Aggregates
BI Accelerator
Reporting
Introduction to BI Enterprise reporting
Navigation in reports
First steps in the Bex query designer
Query designer
Infoprovider in the Bex query designer
Key figures
Restricted Keyfigures
Calculated keyfigures
Properties of Keyfigures
Structures and cells
Characteristics
Properties and attributes of characteristic
Integrating hierarchies into report
Creating user defined hierarchy
Variables
Exception and conditions
Bex analyzer
Bex web analyzer
Information broadcasting
Information broadcasting overview
Bex broadcaster
Workbook precalculator
Enterprise portal integration
Document integration
Report –report interface
Managing query objects
Business content
Further SAP BI reporting tool.
Advance Modeling and Extraction
a. Overview of BI
1. Overview of data acquisition
a. Bi content
2. Data flow in data acquisition
a. Data flow summary
b. Transformation process
c. Direct access to source system
d. Real time data acquisition
3. Data acquisition in Service API
a. Connecting SAP source system to BI system
b. Basic of the BI S API
c. Transfer of Business content
d. Logistic data acquisition
e. Generic data acquisition
f. Enhancement of BI content data source
4. Transfer of flat file
5. Data acquisition with DB connect
6. Process chain
a. Process chain design
b. Managing process chain
7. Report performance
a. Design
b. OLAP caching
8. BI statistic and monitoring
9. Aggregates
10. BI accelerator
11. Security component in BI
12. Security data access for report user
13. Saving bex object in BI roles
14. Securing data access for advance user
15. Maintain authorization