BI course content

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 (metadata repository)
• 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

1. Introduction to BI Enterprise reporting
2. Navigation in reports
3. First steps in the Bex query designer
• Query designer
• Infoprovider in the Bex query designer

4. Key figures
• Restricted Keyfigures
• Calculated keyfigures
• Properties of Keyfigures
• Structures and cells

5. Characteristics
• Properties and attributes of characteristic
• Integrating hierarchies into report
• Creating user defined hierarchy

6. Variables
7. Exception and conditions
8. Bex analyzer
9. Bex web analyzer
10. Information broadcasting
• Information broadcasting overview
• Bex broadcaster
• Workbook precalculator
11. Enterprise portal integration
12. Document integration
13. Report –report interface
14. Managing query objects
15. Business content
16. Further SAP BI reporting tool.

Advance Modeling and Extraction

1. Overview of BI
a. Overview of data acquisition
b. 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 authorisation