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).
• Modeling of schemas based on business needs.
• Check with the business.