Business solutions for you portfolio

About

Company: Volkswagen, Wolfsburg

Technology: Microsoft SCCM, SQL, ETL, T-SQL, SSIS, SSRS.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Feb 2018 – Mer 2019

Cost: no details


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.

  • Develop DWH load procedures using SQL Server.
  • Loading the staging tables.
  • Loading the DWH tables.
  • Implementing the VAULT schemas.
  • Creating the ETL processes (stage).
  • Modelling of the schemas based on the business requirements.
  • Clarifications with the business.
  • Loading of data from SAP.
  • Data refinement and data mapping.
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

 

info@bs4y.ch

Order a project
Tell us what kind of project you want to do.
Name
E-mail
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.