Creation of a data warehouse as a management tool for old people's homes and nursing homes. For this purpose, functions stored in Microsoft SQL Server are written using T-SQL, which extract the data from various sources, the extracted data is refined or transformed and then brought into the correct structure in order to fill the standing schema of the data warehouse be able. The cubes are then formed using SSAS and a report set is placed on top of the cubes using SSRS. The ETL links are developed as stored procedures using T-SQL and SSIS. The cube is developed and subordinated using SSAS and reporting is created using SSRS.

• Project: Analysis of a DWH, implemented using SQL Server (SSIS, SSAS,
  SSRS).
• Requirement engineering and creation of the concept.
• Creation of the ETL processes (SSIS).
• Creating the cubes (SSAS).
• Creation of reports and ad hoc evaluations (SSRS).
• Training of the internal SQL developers for the creation of ETL processes, cubes, evaluations and reports.
• Creation of a concept for the COZY application (new CURALYS).
• Windows application using C #.
• Evaluations with Tableau.