4004361: Business intelligence

back to overview
Semester:WS 15/16
Type:Module
Language:English
ECTS-Credits:5.0
Scheduled in semester:3
Semester Hours per Week / Contact Hours:66.5 L / 50.0 h
Self-directed study time:100.0 h

Module coordination/Lecturers

Curricula

Master's degree programme in IT and Business Process Management (01.10.2008)

Description

The course starts with an exam in the first session.
Exam subjects are available in Moodle.


A general introduction to SAP and handling of the software is provided in the first session of the course Enterprise Systems. Please make sure to attend this session in case you do not have some prior experience with SAP software.

The course focuses on conceptual principles, implementation and operations of Business Intelligence solutions, based on SAP NetWeaver BW, SAP BusinessObjects and SAP HANA. The main learning outcomes are:

Topics:

  • Conceptual foundation
    • The Data Warehouse theory
    • In-Memory column based solutions
  • Market overview
  • SAP NetWeaver BW Data Modeling & ETL
  • SAP Business Explorer
    • Query
    • Front End Tools
  • SAP BusinessObjects Front End Tools
  • In Memory Computing with SAP HANA

Qualifications

    • describe different concept of Data Warehousing and In-Memory columns
    • give examples of practical application
    • apply knowledge in implementing solutions based on SAP applications
    • compare different solutions
    • relate different concepts to develop an individual solution
    • plan their case study / project
    • summarize the contents of the case study they are provided with.
    • discuss the case study in the light of existing models and theories.
    • solve different assignments in the case study with the help of different methods.
    • compare the as-is situation described in the case study and identify possible solutions for improvement.
    • develop new strategies for a successful implementation of a business intelligence solution for the case study and
    • do the conceptional breakdown of the case study /project with a blue print
    ...evaluate different solutions regarding their value contribution and sustainability.

Lectures Method

The module integrates theoretical knowledge and practical skills based on an interactive lecture that includes teaching cases.

The e-learning platform Moodle will be used throughout the course for the dissemination of course material and discussions.

Admission Requirements

The students are familiar with the concepts of ERP systems and the SAP ERP/ECC solution as discussed in the first sessions of the module "Enterprise Systems".

Literature

Compulsory Reading:

  • Egger et al. (2007). SAP Business Intelligence, SAP Press (ISBN: 978-1-59229-082-6)

  • SAP Documentation: http://help.sap.com/businessobject/product_guides/default.asp

  • SAP BusinessObjects Web Intelligence User's Guide

  • SAP Crystal Reports 2011 Users Guide

  • Plattner, H. (2009). A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database, Hasso Plattner Institute for IT Systems Engineering University of Potsdam.

  • Inmon, W. H. (2005). Building the Data Warehouse, (4th ed) John Wiley.

The students will be provided with the lecture slides and supporting materials (literature and exercises) throughout the course.

Further Recommended Readings:

Egger et al. (2009). Reporting und Analyse mit SAP BusinessObjects, Galileo Press. (ISBN: 978-3-8362-1380-6).

Codd, E.F. et al. (1993). Providing OLAP (Online Analytical Processing) to User-Analysts: An IT Mandate, White Paper im Auftrag von Arbor Software (jetzt Hyperion Solutions). Siehe auch: http://www.fpm.com/refer/codd.html.

Egger N., Fiechter J.-M. & Rohlf J. (2005). SAP BW - Data Modeling, SAP Press (ISBN: 1-59229-043-4)

Plattner, H. & Zeier, A. (2011). In-Memory Data Management. An Inflection Point for Enterprise Applications, Springer, ISBN-13: 9783642193620

Hichert, R. & Moritz, M. (1995). Management-Informationssysteme. Praktische Anwendungen, (2nd ed.) Springer Verlag.

Kaiser, B.-U. (1999). Unternehmensinformation mit SAP-EIS. Hrsg. von Stephen Fedtke, Vieweg.

Keen, P. G. W. (1978). Decision support systems: an organizational perspective. Reading, Mass., Addison-Wesley Pub. Co. ISBN 0-201-03667-3

Laudon, K. C. & Laudon, J.P. (2013). Management Information Systems: A Contemporary Perspective. (13th ed.) New York: Macmillan.

Salmeron, Jose L. (2003). EIS Success: Keys and difficulties in major companies. Technovation 23 (1), 35–38.

Exam Modalities

  • Please check examination details. Attendance is mandatory in this course.
  • Evaluation of exams should take no longer than six weeks.
  • The written exam is split up in an entry exam (30 points) and a final exam (60 points). Overall a minimum of 45 points must be achieved to pass the written exam part.

Exams

  • PWW-MA_08_Business Intelligence (WS 15/16, bewertet)