Project description MICROSOFT PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Microsoft SQL Server DWH and SSIS, SSRS, SSAS and T-SQL development

Raiffeisen

MS-Server DWH, SSIS, SSRS, SSAS,T-SQL

UBS AG, Zurich

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: Feb 2022 - Dec 2022
PROJECT Value: SFR. 00'000.00

DWH

Proects portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT
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.
  • Creating the ETL processes (stage).
  • Performance tuning specialist for complex SSIS packages
  • Modeling of schemas based on business needs.
  • Check with the business.