5008153: 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 & Business Explorer
• SAP BusinessObjects Cloud and Enterprise
• In-Memory Computing with SAP HANA

Ziele

• 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

Lehrmethoden

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.

Literatur

Further reading:

• 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.
• Grossmann, W. & Rinderle-Ma, S. (2015). Fundamentals of Business Intelligence, Springer (ISBN 978-3-662-46530-1), Ch. 1-4https://help.sap.com/viewer/p/SAP_ANALYTICS
• Plattner, H. & Leukert B. (2015). The in-memory revolution. How SAP HANA Enables business of the future
• Codd, E.F. et al. (1993). Providing OLAP (Online Analytical Processing) to User-Analysts: An IT Mandate, White Paper Hyperion Solutions, E.F. Codd Associates
• 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
• 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.
• Kimball, R. & Ross M. (2013). The Data Warehouse Toolkit. The Definitive Guide to Dimensional Modeling, John Wiley & Sons, Inc. ISBN: 978-1-118-53080-1