The aim of the project is to generate reports based on a data warehouse to be created that will evaluate the data from Microsoft SCCM. For this purpose, a concept is created and then the relevant data from SCCM is implemented using ETL routes with Microsoft SQL (T-SQL) and Microsoft SSIS and loaded into the data warehouse. 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.
• Load the DWH tables.
• Implementation of the VAULT schemes.
• Creation of the ETL processes (stage).
• Modeling the schemas based on the business requirements.
• Clarifications with the business.
• Loading data from the SAP.
• Data refinement and data mapping.