The course introduces SAP’s market leading Data Warehousing solution SAP BW/4HANA.
As a first step, the theoretical basics of the SAP BW/4HANA system are introduced. Connected to this theoretical introduction, the acquired knowledge is applied practically to a living SAP system by solving case studies. The case studies are performed in an SAP education system. It is based on the standard SAP ERP system and offers the corporate structure and the data basis to accomplish extensive analyses in the SAP BW system.
The participants learn how to work with the SAP BW/4HANA system using the user interfaces SAP GUI and SAP HANA Studio. The course consists of two parts:
- In the first part, the basic setup of SAP BW/4HANA is introduced. Following this step, the data- and information structure in the BW system are illustrated and with the help of that, students are asked to independently work on a model scenario. One emphasis in this part is the modeling of dataflows within the BW-system (ETL-Process) and data acquisition from SAP source systems. Every chapter offers theoretical knowledge about a certain part of the BW system. The BW objects that are looked upon are then being introduced and illustrated. In addition to that, the native modeling capabilities of SAP HANA are introduced. The acquired knowledge is engrossed by working on case studies. Thus, students not only gather a profound overview on setup and functionality of the BW system and its integration with the SAP ERP system (or operative systems of third-party providers). They also gain respective practical experience in working with the software.
- The second part of the course focuses on the analysis of data. First, the basics of creating reports (queries) using characteristics, key figures, hierarchies, and variables are presented and explained. Based on the data and structures that were generated by the course participants in the first part of the course, own reports and analyzes are created in the BW system. Additionally, students will perform analyzes in Excel-based SAP BusinessObjects Analysis as well as work with the Reporting Tool Crystal Reports Enterprise Edition.
Learning Targets
After the course, students possess profound theoretical knowledge of the SAP BW/4HANA system, its technical aspects and the setup of the underlying data model, as well as approaches to define analyses and reports.
Course participants, in the end, are capable to orient themselves in an SAP BW/4HANA system. They will have acquired knowledge and skills in the following areas:
- Basics and Architecture of SAP HANA and SAP BW/4HANA
- Data Models and Data Structures in SAP BW/4HANA
- Data Acquisition and Dataflow in SAP BW/4HANA
- Administration of SAP BW/4HANA
- Native Modeling in SAP HANA
- Query Design in SAP BW/4HANA
- SAP BusinessObjects Analysis (Excel-Client)
- SAP BusinessObjects Crystal Reports Enterprise Edition
Students learn to work with different functional components of the SAP BW/4HANA system and its integration into complex business scenarios by first getting to know the relevant theory which in a second step is practically applied to the system. Thus, students understand the functions of the SAP BW/4HANA system in a way that enables them to quickly work their ways into the specific environment of a foreign SAP BW/4HANA system.
Structure
- Part I: SAP BW/4HANA – Enterprise Data Warehousing
- Basics of SAP HANA and SAP BW/4HANA
- Data Models in SAP BW/4HANA (InfoObjects, InfoProvider)
- Data Acquisition from SAP Source Systems
- Dataflows in SAP BW/4HANA (Extraktion, Transformation, Loading)
- Administration of Data Targets (InfoProvider Administration, Process Chains, Delta Merge)
- Native Modeling in SAP HANA (Information Views)
- Part II: SAP BW/4HANA – Query Design and Reporting
- Introduction to BEx Query Designer
- Navigation in Queries
- Key Figures
- Characteristics
- Structures
- Hierarchies
- Variables
- Exceptions and Conditions
- Report-to-Report-Interface
- Administration of Query Objects
- Query Performance Optimization
- SAP BusinessObjects Analysis (Excel-Client)
- SAP BusinessObjects Crystal Reports Enterprise Edition
SAP Certification Exam
After successfully completing the course, students are handed out the certificate of the Brandenburg University of Applied Sciences. The official SAP certification in SAP BW/4HANA (C_BW4HANA) presupposes the contents of the following consecutive courses:
Important information in brief
-
Total workload: The course requires a workload of 180 hours / 6 ECTS
-
Language: English
-
System requirements:
-
Microsoft Windows (Mac users need a Windows installation on Virtual Machine: free trial versions of VM software is available on the website of various vendors)
-
Recommended: Microsoft Office
-
at least 2 GB free hardware space
-
Internet Access
-
-
Course certificate: Certificate by Brandenburg University of Applied Sciences when all case studies are completed successfully in SAP BW during the course
-
Course fee: 450 €