Business solutions for you portfolio

About

Company: Liebherr, Germany

Technology: Microsoft SQL Server, SSIS, SSAS, SSRS, T-SQL

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Sep 2012 – Jan 2013

Cost: no details


The aim of the project is to migrate a Cognos data warehouse to Microsoft SQL Server. The ETL routes were implemented using stored procedures in T-SQL or SSIS packages were created. The data cubes were implemented using SSAS and the reports were realised using SSRS. Thus, in 2012, the entire data warehouse was converted or migrated from Cognos to Microsoft SQL Server. The task was to support and train the database developers at Liebherr so that they could successfully implement this migration. In special cases, development work was also carried out on more complex tasks that could not be solved by the teams.

  • Requirement engineering and creation of the concept.
  • Consulting and training of internal employees for the conversion of a Cognos DWH to a Microsoft SQL Server DWH.
  • Creation of the ETL processes (SSIS and T-SQL).
  • Creation of the cubes (SSAS).
  • Creation of reports and ad-hoc evaluations (SSRS).
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.