As an SAP BW Consultant, you need to include the following in your SAP BW Resume.
- Architecture of SAP R/3 Programs.
- Basic knowledge of data warehousing, tables and structure
- DDIC knowledge
- Fundamentals of SAP Netweaver
- SAP R3/ 4.6C / 4.7/ECC5/ECC6
- SAP BW 3.0 /3.5/7.0
- Concepts and architecture of the SAP Business Information Warehouse
- Hands-on experience of working with the SAP BW tools, focusing on Extraction, Transformation and Loading of Data. (ETL)
- Functions of the SAP BW Metadata repository
- Concepts and OLAP functions of SAP BW Reporting
- Usage of predefined SAP reports (Business Content)
- Generating and processing query definitions with both the BEx Query Designer and the BEx Web Application Designer
- Enhanced functions of SAP Business Explorer Analyzer
- Exception Reporting, Report-Report Interface
- Working with the Reporting Agent
- Presentation and navigation using cartographic elements with BEx Map
- Concepts of SAP BW Web Reporting
- Working with the SAP BW Web Application
- Design and Administration of HTML pages on the Web Application Server
- Overview of the different delta mechanisms and data staging from several source systems
- Generic Extraction
- Enhancement of extractors
- Extraction and Staging from Non-SAP Systems - Data extraction from SAP Components:
- Overview of the basic concepts for SAP R/3 extraction
- Customizing of Logistic Extract Structures
- Extraction from user defined LIS Info structures
- Extraction from CO-PA - Data modelling process (combined with case study elements):
- Requirements Analysis
- Development of a logical data model
- Transfer into a physical data model
- Technical implementation in SAP BW
- Upgrading the data model - Introduction to SAP BW authorization concepts:
- Differences and similarities between R/3 security requirements and SAP BW security requirements.
- Authorizations for reporting users, including the authorization objects and authorization values required
- SAP BW administration users and how to secure administration tasks
- Roles and templates provided by SAP to assist in building security for the SAP BW system
- Security required for source systems connected to SAP BW. - Introduction to Implementation with ASAP for BW:
- Methodology of SAP BW Implementation
- ASAP Project Phases - Integrated Case Study:
- Hand-on experience build on the knowledge of the previous courses in an SAP implementation project
- Implementing the data model
- Authorization concepts
- Web Reporting
- Aggregates and Performance - SAP BW Certification:
- TBW10 (mySAP BI - BW Data Warehousing), TBW20 (mySAP BI - BW Reporting & Analysis), TBW30 (mySAP BI - BW Data Staging & Extraction), TBW40 (mySAP BI - BW Modeling Authorization) and TBW50 (mySAP BI - BW Case Study)