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?
Migrating analysis systems for a pharmaceutical manufacturer's production costs and sales data
Projektdauer: 1 Jahr
Kurzbeschreibung
In this project, analysis databases are migrated from Microsoft SQL Server 2000 to Microsoft SQL Server 2005. This is expected to reduce the loads on the current server and enable up-to-date evaluation options. To this end, a new server is provided and the analysis databases will be made available on the server in stages.
Ergänzung
The OLAP databases are migrated from the existing OLAP database technology in Microsoft SQL Server 2000 (Analysis Services) to the SQL Server 2005 (Analysis Services). The design of the OLAP databases is to be aligned with the management reporting specifications (analysis database currently available in SQL Server 2005).The processes for loading the fact and dimension data are implemented using Integration Services. The data processes to be implemented are integrated into a centralized sequence control system that has already been established. The Business Intelligence Development Studio, based on Visual Studio 2005, is used as the development environment for the data processes and the OLAP databases. The OLAP databases are made available to users by means of Analysis Services. At the front end, users can select either "MIS Plain" (from MIS AG) or "Deltamaster" (from Bissantz). This is made available to users via an application server (Citrix).
Fachbeschreibung
The sales database shows the pharmaceutical company's actual sales around the world at the level of individual articles, in terms of value and quantity. Target figures can be used together with up-to-date actual figures on a monthly basis to create analyses. The database for analyzing the manufacturing costs provides the opportunity to analyze manufacturing costs at the article level. The itemized cost items are available in both consolidated and unconsolidated form, which enables the value of the entire manufacturing process to be checked. The databases enable planners and controllers to evaluate sales and manufacturing costs in 13 dimensions. These are integrated into the management reporting concept.
IT-Projektdaten
- Branchen Pharma-Industrie
- Fachaufgaben cost analysis, Reporting, sales analysis, turnover analysis
- DV-Aufgaben Migration
- Systemumgebungen Business Intelligence, Client/Server
- Programmiersprachen C-Sharp, SQL
- Datenbanken MS SQL Server
- Entwicklungs- und Testtool MS Visual Studio
- Betriebssysteme Windows Server 2003 EE, Windows XP
- Systemsoftware MS Visual SourceSafe
Projektzeitraum01.04.2007 - 30.03.2008
Kunden, die uns vertrauen
Haben wir Ihr Interesse geweckt?
