Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development
Company: Raiffeisen
Technology: T-SQL, SSIS, SSRS, MS-SQL.
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Feb 2022 – Dec 2022
Cost: no details
The aim of the project is the generation of 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 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.
- Development of DWH load procedures using SQL server.
- Loading the staging tables.
- Loading the DWH tables.
- Implementing the VAULT schemas.
- reation of the ETL processes (stage).
- Performance tuning specialist for complex SSIS packages
- Modeling of schemes based on business needs.
- Clarifications with the business.