 |
Introduction to SAP and its solutions |
 |
Overview of a Data Warehouse |
| |
 |
Objectives of a Data Warehouse |
| |
 |
Information Management |
| |
 |
Features of a Data Warehouse |
| |
 |
Data Warehouse Architecture |
 |
Overview of basic concepts and architecture of the SAP Business Information Warehouse |
| |
 |
System Types |
| |
 |
Architecture |
| |
 |
Concepts and Terms |
| |
 |
OLTP vs. OLAP |
| |
 |
OLAP Tools |
 |
Business Warehouse Configuration Overview |
 |
Introduction to Data Modeling |
| |
 |
Creating a requirements analysis |
| |
 |
Developing a BI data model |
| |
 |
Modeling data marts |
| |
 |
Enhancing/changing the data model, remodeling |
| |
 |
Aspects of an enterprise data warehouse architecture |
| |
 |
Special modeling and Data Warehousing aspects |
| |
 |
InfoSets, MultiProviders and Open Hub Service |
 |
SAP BW Performance and Administration |
| |
 |
Functions of Administrator Workbench |
| |
 |
Information Retrieval |
| |
 |
Update Rules |
| |
 |
Displaying the Data Flow |
| |
 |
Extraction, Transformation and Loading (ETL) Process Overview |
| |
 |
InfoAggregates |
| |
 |
Introduction to the functions of the SAP BW Metadata repository |
 |
Extraction |
| |
 |
SAP BW in SAP NetWeaver |
| |
 |
Data Transfer with the Service API |
| |
 |
Delta Management |
| |
 |
Transfer of flat files |
| |
 |
Data Transfer with DB Connect |
| |
 |
Data Transfer with UDC |
| |
 |
XML-Based Extraction |
| |
 |
Data Transfer with Third-Party ETL Tools |
| |
 |
Data Mart Interface |
| |
 |
Open Hub Service |
 |
Reporting and Analysis |
| |
 |
Architecture and functions of SAP BW analysis tools |
| |
 |
Navigating in SAP BW reports using the Web and the BEx Analyzer |
| |
 |
Using predefined SAP reports from Business Content |
| |
 |
Creating and executing query definitions with the BEx Query Designer |
| |
 |
Using key figures, characteristics, hierarchies, variables, properties , exceptions, and conditions for defining queries |
| |
 |
Creating and using Web templates that differ from the SAP default template |
| |
 |
Generating Excel-based and/or HTML-based reports |
 |
Archiving |
| |
 |
Creating Archive Objects |
| |
 |
Reloading Archived Objects |
 |
Reporting Management |
| |
 |
Enterprise Portal |
| |
 |
Reporting Agent |
| |
 |
Report To Report Interface |
 |
Business Content |
| |
 |
Evolution and Use of Business Content |
| |
 |
BW Statistics |
| |
 |
Components Activation |
 |
SEM BPS |
| |
 |
General concepts and challenges of business planning |
| |
 |
Positioning of BPS and relationship to BW |
| |
 |
Forming planning structures |
| |
 |
Manual planning and layout formatting |
| |
 |
Locking concept and commit model used in BPS |
| |
 |
Configuration of planning functions and sequences |
| |
 |
Retraction into SAP R/3 applications |
| |
 |
The status and tracking system as a monitoring tool for planning |
| |
 |
Forming planning structures |
| |
 |
Manual planning and options for layout formatting |
| |
 |
Defining generic planning functions |
| |
 |
Designing end-user interfaces with the help of planning folders and the Web Interface Builder |
| |
 |
Integrating BW hierarchies and attributes |
| |
 |
Retraction into SAP R/3 applications |