Data Warehouse Management with SAP BW


The entire course will emulate a real-world warehouse implementation project from its early planning stages to final use. The system used will be SAP HANA as well as tools for speech recognition and analysis.

Learning Outcomes

Students will understand the concept, tools and limitations of in-memory-based business intelligence, which enables analytics far beyond traditional data warehousing. They will also understand how methods of artificial intelligence interact and enhance analytics. Furthermore, students will learn to analyse analogue data and to merge it with formatted data from commercial information systems, such as ERP. The analogue data used will be voice clips from a “helpdesk support”, which are analysed in speech recognition, assigned to topics talked about and the sentiment of the talk. This enables to analyse customer feelings about the company products, which are related to traditional analysis of formatted data, in this case customer interactions.

Formatted data analysis, however, will not be based on traditional data warehousing based on aggregate “cubes”, but will utilize in-memory computing to analyse individual records which enable a much more in-depth analysis.

Students will also learn how to conceptually plan such a data warehouse with particular reference to unformatted and analogue data sources and their analysis.

For DFM modelling cf. Golfarelli, M., Rizzi, S., Maio, D., The Dimensional Fact Model: A Conceptual Model for Data Warehouses