4408153: C15 Business Intelligence

Beschreibung

• Short descriptionThe 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. TopicsConceptual foundations of data warehouses and on-line analytical processing (OLAP)Conceptual foundations of in-memory column-based databasesSAP BW Data Modeling & ETLSAP Business ExplorerSAP BusinessObjects Cloud and EnterpriseIn-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 databasesStudents extract, transform, and load data from transactional systems into business intelligence solutionsStudents 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

Compulsory 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-4
• https://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