Dieses IT-Projekt ist Teil unserer Digitalisierung und Optimierung der IT-Landschaft unserer Kunden. Durch gezielte Maßnahmen fördern wir den technologischen Fortschritt, optimieren systemübergreifende Prozesse und schaffen eine nachhaltige Basis für zukünftige Entwicklungen. Unsere IT-Referenzprojekte dienen als Grundlage zur Orientierung. Sie unterstützen die Wiederverwendbarkeit erprobter Konzepte im Rahmen der Projektumsetzung.
Dies ist eines von 4929 IT-Projekten, die wir erfolgreich mit unseren Kunden abgeschlossen haben.Wobei dürfen wir Sie unterstützen?
Re-engineering and further development of an international data warehouse environment
Projektdauer: 6 Jahre, 1 Monat
Kurzbeschreibung
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).
Ergänzung
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.
Fachbeschreibung
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.
IT-Projektdaten
- Branchen Pharma-Industrie
- Fachaufgaben Controlling, fine scheduling, sales and distribution, sales and distribution controlling, sales support
- DV-Aufgaben Data Warehouse
- Systemumgebungen Business Intelligence
- Vorgehensmodell PTA project manual
- Programmiersprachen T-SQL (Microsoft)
- Datenbanken MS SQL Server
- Betriebssysteme Windows 2003, Windows XP
- Middleware und Frameworks ASP.NET, MS .NET, MS SQL Server Analysis Services (SSAS)
Projektzeitraum01.01.2006 - 30.01.2012
Kunden, die uns vertrauen
Haben wir Ihr Interesse geweckt?
