Data Warehouse and Business Intelligence

22M1142

Master

German

5.0

only summerterm

1 semester

The course "Business Intelligence and Data Warehousing" deals with the data-driven management of organisations and processes in healthcare. Due to advancing digitalisation in the healthcare sector, more and more data and information from the workflows are available electronically and thus accessible for the analysis and control of clinical, administrative, and financial processes. These analyses allow for better decision-making in the care process itself and at the level of corporate management (data-driven & learning organisations). To make these analyses possible, the data and information must be extracted from the source systems, transformed and loaded into database structures or a data warehouse. Furthermore, they must be fed to the analysis and visualisation software depending on the question. With suitable data warehouses, it is possible to perform modern controlling and governance.

1) Introduction to Business Intelligence 

1.1) Objectives

1.2) Statistical methods and visualisation

1.3) Application examples

2) Data Warehouse

2.1) Technical basics

2.2) Extraction, transformation, loading process

2.3) Data schemata, especially entity-relationship models

2.4) Analyses via datamarts, introduction to data mining

2.5) Analysis and visualisation software

3) Practical applications and exercises

The total workload for the module is 150 hours (see also "ECTS credit points and grading").

• Presentation or
• Oral presentation, with written elaboration

Presentation: approx. 20-40 minutes

Report (R): presentation of approx. 20-40 minutes with written report of approx. 5-10 pages

The requirements are specified in the relevant class.

Descriptive statistics

The students have knowledge of what a data warehouse technically is, what is understood by an ETL process and how corresponding data can be technically and methodically pre-processed, analysed and visualised. The students can reproduce their acquired entry-level knowledge for the development and practical use of a data warehouse.

The students understand the importance of business intelligence and analytics as well as data warehouses for modern controlling and governance of healthcare organisations. They are able to independently identify new use cases for BI solutions, formulate corresponding requirements and prepare data.

The students can realistically assess the possibilities and limits of BI solutions and contextualise the acquired knowledge with the previously learned knowledge about controlling approaches. They are aware of the effectiveness of well-specified BI solutions for managing healthcare organisations.

The students can use the acquired knowledge independently to tap efficiency and quality potentials in clinical and operational workflows or to provide consulting in the implementation and use of BI solutions. They can solve decision-making problems with the help of data warehouse technologies and business analytics / business intelligence tools.

Students will be enabled to generate locally relevant insights in terms of decision support by applying and using BI methods and thus develop healthcare organisations further in the direction of learning organisations. Moreover, they are aware of research enablement by means of good data management of clinical data in particular.

The students know how to use BI solutions as a means of communication, especially in the exchange with superiors and clinicians to their advantage or to the benefit of their respective areas of responsibility. They can communicate complex applications of data warehouses in healthcare and demonstrate their benefits using examples. They develop corresponding solutions during exercises in small groups.

Students know how to realistically assess the limits and possibilities of BI solutions and data warehouses as well as their knowledge of pertinent solutions and how to act accordingly. They develop a self-image that internalises the prioritisation of the development of learning organisations as a strategic maxim for action.

This module is part of the specialisation "Management & Controlling". In particular, it picks up on the premises of decision-oriented corporate management from the previous module and connects to the corresponding content on the basics of controlling. Furthermore, the module takes up contents from the course "Methods of Data Analysis" with regard to the handling and analysis of quantitative data.

• Management for Health Services, M.A.

• Hübner, Ursula Hertha

• Hübner, Ursula Hertha
• Unknown person