The theoretical basics gained in the course Introduction to SAP BI are inevitable for this course. They will be addressed to and enhanced by knowledge on data employment, data procurement and data preparation in the SAP BI system, as well as the interface technology of the BI system. In the course run, students again apply the new theoretical knowledge practically to the system. This consolidates the knowledge and helps to acquire important practical skills in working with a BI system.

The case studies are performed in an SAP education system. The used IDES (Internet Demonstration and Evaluation System) represents a fully developed model enterprise. It is based on the standard SAP ERP system and it offers the corporate structure and the data basis to accomplish extensive analyses in the SAP BI system.

The course consists of two parts. In the first part, students are confronted with the general setup of the BI system. Building upon that, data and information structures in the BI system are explained. Students are asked to model these independently. The training scenario is immediately based upon the data structures of the enterprise controlling from the course Introduction to SAP BI and in this course is extended by special aspects of data procurement. The emphasis of the first part is on the different methods and interfaces for data procurement and data preparation over which data is loaded into the BI system and then again provided by the BI system. The individual chapters elucidate the theoretical fundamentals to the BI objects and interfaces that are looked at and illustrate the gained knowledge in form of case studies which need to be solved practically. Thus, students acquire knowledge of the setup and function of the BI system and its integration with SAP ERP, or with operative systems of third-party providers.

In the second part of the course, the training scenario is extended by additional activity areas of Controlling. Here, students are asked to implement the whole process from data modeling over the defining of data structures up to data loading mostly on their own. The independent work on the system is becoming more and more important. In the second step of part two, students get to know Query-Design and Reporting in SAP BI. Knowledge from the introductory course concerning BEx Query Designer, BEx Analyzer and BEx Broadcaster is extended here. Additionally, students engage extensively with the Web Application Designer and the BEx Report Designer.

The contents of the individual chapters are structured in a way that helps students to get a broad overview over functions of the SAP BI system and internalize its handling.

 

After the course, students will have gained profound theoretical and methodological knowledge of the SAP BI system and its interfaces to data acquisition by intensive engagement with SAP BI objects and their functions. In the course, the technical aspects of the BI system are approached, the structure of the underlying data model, as well as its modes of operation when customizing analyses, reports and web applications.

 

The following areas of activity are trained in the course:

• The Modeling Process in SAP BI
  
• SAP BI Administration
  
• SAP BI Data Models and Structures
  
• Procurement, Acquisition and Preparation of Data
  
• SAP BI Business Content
  
• SAP BI BEx Reporter
  
• SAP BI BEx Query Designer and Analyzer
  
• SAP BI BEx Broadcaster
  
• SAP BI Web Application Designer 

 

Due to the combination of theoretical and practical work, course participants are enabled to understand the use and function of a BI system to such an extent that allows them to quickly find their way into a foreign BI system of a future employer.

 

Find here a detailed structure of the course contents:

• Part I: SAP BI - Advanced Enterprise Data Warehousing
  
• SAP BI Fundamentals
• Data Flow in Data Acquisition
• Data Acquisition with the Service API
  
• Delta Management
  
• Data Acquisition with DB Connect
• Data Acquisition with Universal Data Integration
  
• XML-based Extraction Data Transfer with Third-Party-ETL-Tools
  
• Data Mart Interface
  
• Part II: SAP BI – Advanced Modeling, Reporting and Query Design
  
• Enterprise Data Warehouse Architecture
  
• Modelling Process
  
• Master Date for Modelling
• Multi-dimensional Modelling
  
• Enhanced InfoProvider Modelling
• DataTransfer
  
• BEx Analyzer
• BEx Report Designer
• BEx Web Application Designer
• BEx Broadcaster: Enhanced Functions

After successfully completing the course, students are handed out the certificate of the University Duisburg-Essen.

The official SAP certification in SAP BI (C_TBW45_70) presupposes the contents of the following consecutive courses:

• Introduction to SAP BI
  
• SAP BI – Advanced Business Intelligence
  
• SAP BI – Integrated Business Planning
  

 

After completing these three courses, the certification exam can be booked directly at SAP Education. Dates and fees can be looked up on the websites of SAP Education.

 

• Total workload
  The course requires a workload of 180 hours corresponding to 6 credit points according to the European Credit Transfer System (ECTS)
• Language: English
• System requirements:
  
• Microsoft Windows or Mac with a Virtual Machine
• internet access
• MS Office (especially MS Excel)
  
• other requirements
  For participants without knowlegde of SAP ERP we urgently suggest the previous or parallel participation in the course Integrated business processes with SAP ERP (TERP10).
  For participants without knowlegde of SAP ERP we urgently suggest the previous or parallel participation in the course Introduction to SAP BI.

• Course term: 17 May 2012 - 16 September 2012

• Course certificate: Certificate by University Duisburg-Essen when all case studies are completed successfully in SAP BI during the course
• Course fee: 450 €
  
• Tutors
  Prof. Dr. Heimo H. Adelsberger
  Taymaz Khatami, Dipl.-Wirt. Inf

 

REGISTER NOW