This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

Re-engineering and further development of an international data warehouse environment

Project duration: 6 years, 1 month

Brief description

Expanding and adjusting an existing data warehouse (DWH) and the reporting based on it. Sales figures, sales activities and information about servicing and maintenance are consolidated together with sales and turnover information from various source systems in a group-wide DWH. This data is then prepared for evaluations and research by means of OLAP (online analytical processing).

Supplement

An existing web-based information system is expanded and improved technically. The processes for loading sales information (SAP) and distribution information (CRM) are linked in and further processed with the help of the SQL Server 2005 Integration Services. Other external sources with market and structural data complete the data pool. The data is consolidated and prepared in a two-stage staging area. The consistent data pool that is then created is used both as a data source for the central DWH and for various company-wide applications. On the basis of the DWH data, the SQL Server 2005 Analysis Services are used to prepare the data for various reporting functions using OLAP. The information system implemented in ASP.Net enables structured and role-specific access to the defined DWH reports. ProClarity is used as a flexible report generator.

Subject description

The data can either be evaluated and analyzed by means of an information system with reports or by means of a flexible report generator. The application provides reports about sales/turnover figures, classified according to product and regional structures, as well as evaluations of expected turnover, customer structure, market information and sales planning. The question of time is given special consideration; specifically, annual and quarterly comparisons are made. Evaluations of distribution activities, servicing and maintenance information are also possible. Additionally, users can create further reports and make these accessible to other people. The DWH is validated in accordance with FDA guidelines.

Overview

Project period01.01.2006 - 30.01.2012

Have we sparked your interest?

Portrait Herr Knudsen, Mann im Anzug

Ole Knudsen

Key Account Manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.