dwh

Developing a concept for the cost-effective migration of 600 SSIS packages, consisting of an analysis of all existing packages, dividing the packages into three groups, underpinning the concept including calculating the time needed for migration, and developing several options for a cost-effective implementation of the entire migration. The implementation is partly done with in-house staff, with students and with migration specialists. The concept also takes into account performance optimisation of the individual SSIS packages.

The aim of the project is to generate reports based on a data warehouse to be created, which evaluates the data from Microsoft SCCM. For this purpose, a concept is created and then the relevant data from SCCM is loaded into the data warehouse using ETL routes implemented with Microsoft SQL (T-SQL) and Microsoft SSIS. After loading the data, the Enterprise DWH is created and the entire reporting is implemented using SSRS.

Creation of ETL routes for filling the financial data warehouse of the company ElipsLife. The tables of the data warehouse are first filled in the stage area and then, after transformation, in the area of the data warehouse. Both the stage database and the data warehouse are filled by calling stored functions that were implemented in T-SQL. Since the data warehouse is a data vault schema, the filling of the tables of the data warehouse is done according to exact rules. Only one statement is provided for filling the hubs, links or satellites. All three are always filled in the same way, only the names of tables and attributes change. The task is to write dynamic stored procedures for filling these tables, test them, document them and integrate them into the system. The development will be implemented using Microsoft SQL Server 2016 and Microsoft T-SQL. Some functionalities are implemented using Microsoft SSIS packages; these are also tested and documented.