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?
Introduction of a central KPI database
Projektdauer: 10 Monate
Kurzbeschreibung
A database system is developed which receives unprocessed commercial data, condenses it and calculates KPIs based on this; these are stored in order to be available across the company to external systems for request. The project involves the design, implementation and testing of the system to be created. The target system comprises a database in which up to 20 GB is imported daily in the form of csv files, and processed within two hours. The architecture is open both for expansion by new input and output interfaces as well as implementation of new key figures.
Ergänzung
The target system runs on an Oracle 12c database under Linux. The input data is supplied in the form of csv files which are imported as external tables and processed with PL/SQL. The calculated KPIs are accessed via Oracle database links from the external systems. The project activities involve all tasks from the general concept through to the fine concept, requirement analysis and definition, implementation of all functions as well as planning and carrying out the module and integration tests, and providing support for the system and acceptance tests.
Fachbeschreibung
The target system serves as a central source system for quick access to condensed KPIs by external systems. The implemented KPIs are planned and achieved sales quantities, sales volumes and, resulting from this, commercial KPIs that are used for providing information to planning processes.
IT-Projektdaten
- Branchen Handel
- Fachaufgaben Big Data, KPI, promotional transaction, sales analysis, sales planning
- DV-Aufgaben customised software new development
- Systemumgebungen technical data processing
- Vorgehensmodell agile software development
- Programmiersprachen PL/SQL
- Datenbanken Oracle Database
- Entwicklungs- und Testtool MS Team Foundation Server TFS, MS Visual Studio, Oracle SQL Developer, Oracle SQL*Loader
- Standardsoftware und BI Microsoft Test Manager
- Middleware und Frameworks MS Office SharePoint Server (MOSS)
Projektzeitraum06.05.2015 - 29.02.2016
Kunden, die uns vertrauen
Haben wir Ihr Interesse geweckt?
