4208153: C15 Business Intelligence

Beschreibung

Short description
The course covers conceptual foundations, implementation, and operations of Business Intelligence solutions. Students will learn how to design and operate data warehouses, reports and dashboards, based on SAP BW, SAP BusinessObjects, as well as SAP HANA.

Topics

• Conceptual foundations of data warehouses and on-line analytical processing (OLAP)
• Conceptual foundations of in-memory column-based databases
• SAP BW Data Modeling & ETL
• SAP Business Explorer
• SAP BusinessObjects Cloud and Enterprise
• In-Memory Computing with SAP HANA

• Students know and understand foundational concepts and methods of data warehousing and on-line analytical processing (OLAP)
• Students know and understand foundational concepts and methods of in-memory column-based databases
• Students extract, transform, and load data from transactional systems into business intelligence solutions
• Students design and develop business intelligence reports and dashboards

• The module integrates theoretical knowledge and practical skills in an interactive seminar.
• The e-learning platform Moodle will be used throughout the course for the dissemination of course material and discussions.

• Egger et al. (2007). SAP Business Intelligence, SAP Press (ISBN: 978-1-59229-082-6)
• 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.
• http://help.sap.com/pcat_analytics

• 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
• Salmeron, Jose L. (2003). EIS Success: Keys and difficulties in major companies. Technovation, 23 (1), 35–38.