The course “SAP BI – Integrated Business Planning” deals with the SAP BI software for Data Warehousing. The theoretical and practical knowledge gained in the courses Introduction to SAP BI and SAP BI – Advanced Business Intelligence is inevitable for this course. Building upon that, possibilities are looked at of developing an integrated business planning based on data from many different source systems. The theoretical contents will then be applied to the system which helps to consolidate to theoretical knowledge in return.

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. The first part gives an overview on planning functions in SAP BI. Based upon that, students compile their own data models by using MultiProviders. They also get to know BI’s planning architecture and, connected to that, planning functions and Plan-Queries. Furthermore, the Lock-Concept of SAP BI is introduced and planning sequences are applied to the system. Eventually, planning applications are defined. Here, the generation of web-based planning applications via the Web Application Designer is introduced, as well as the generation of Excel-based planning applications via BEx Analyzer.

In the second part of the course, specific approaches to data extraction are looked at: Data extraction via the Universal Data Integration Interface, as well as the Exchange Infrastructure. Furthermore, it is shown how data from different sources can be combined in order to capture invisible patterns and connections. To reveal complex and hidden structures, the Analysis Process Designer is used. The results of this process can be updated and be used as the planning starting point.

The contents of the individual chapters are structured in a way that helps students to get a very complex overview of functions of the SAP BI system – specifically planning models and the Analysis Process Designer – and internalize its handling.

After the course, students will have gained profound theoretical and methodological knowledge of the SAP BI planning elements and their functions. Additionally, students will be able to implement planning within SAP BI, generate the necessary data and unfold complex hidden connections within this data.

The following areas of activity are trained in the course:

• Fundamentals of Integrated Planning with SAP BI
  
• Planning Architecture and Data Models
  
• Use of Planning Functions
  
• Customizing and using Plan-Queries
  
• Lock-Concept in Integrated Planning
  
• Customizing and using Excel-based Planning Elements via BEx Analyzer
  
• Modelling and Planning with MultiProviders
  
• Use of Planning Sequences
  
• Characteristic Relationships and Data Slices
  
• Customizing and Using Web-based Planning Elements via Web Application Designer
  
• Status- and Tracking System
  
• Data Extraction via Universal Data Integration
  
• Data Extraction via Exchange Infrastructure
  
• Analysis Process Designer
  
• Transport Management
  

The theoretical work and the tutor-guided but mostly independent practical work on the system, enables course participants 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.

• Part I: SAP BI – Integrated Planning
  
• Basic Concepts and Challenges of Business Planning
  
• Building a Data Model and Data Input
  
• Fundamentals of Planning Functions
• Customizing Plan-Queries
  
• Lock-Concept for Dynamic Data
  
• Customizing and Using Excel-based Planning Elements using BEx Analyzer
  
• Advanced Planning Functions
• Using Planning Sequences
• Characteristic Relationships and Data Slices
• Customizing and Using Web-based Planning Elements with the Web Application Designer
• Status and Tracking System
  
• Part II: SAP BI – Enhanced Methods of Extraction and Analyses
  
• Data Extraction via Universal Data Integration
• Data Extraction via Exchange Infrastructure
• Using the Analysis Process Designer
• Data Mining with SAP BI

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 and SAP BI - Advanced Business Intelligence.
• Course term:
• for registration until 21st March 2012: 22 March 2012 - 22 July 2012
• for late registrations until 1st April 2012: 5 April 2012 - 22 July 2012

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

REGISTER NOW