Menu
This is one of 4545 IT projects that we have successfully completed with our customers.How can we support you?
Support and development for central KPI reporting at a pharmaceutical company 2017
Project duration: 2 years
Brief description
In this project, further development and support tasks are provided for the analysis systems at a pharmaceutical company. This involves a series of OLAP databases covering all company reporting for actual and planned data, down to the level of individual articles. Support activities ensure smooth operation. They also include implementing changes and new requirements. Development activities cover ETL processes and system status reports.
Supplement
The database software used is the SQL Server 2016 from Microsoft. Business Intelligence Development Studio, based on Visual Studio 2015, is used as the development environment for the data processes and the OLAP databases. Support tasks that can be performed directly on the database (such as configuration, data checks and data corrections) are carried out using the SQL Server Management Studio. The processes for loading the fact and dimension data are implemented using Integration Services. The data processes that are to be implemented are integrated into an established centralized sequence control system. The sequence logic needed to do this also has to be created and maintained. The OLAP databases are made available to users by means of Analysis Services. MS Reports is used in this context with SharePoint for the system status reports. HPSM from HP is used as the ticket system and SAP SSM is used for documentation.
Subject description
The key performance indicators database shows the company's actual and planned 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 key performance indicators include values for the working capital, sales figures and manufacturing costs, value management, and employee figures and costs. The itemized items are available in both consolidated and unconsolidated form, which enables the value of the entire manufacturing process to be checked. In addition, data is provided for a detailed deviation analysis. The database enables planners and controllers to evaluate the KPIs in more than 12 dimensions. These dimensions are integrated into the management reporting concept for an existing analysis database at a rougher level.
Overview
- Branchen pharmaceutical industry
- Fachaufgaben BPM: process realization, data warehouse, Reporting
- DV-Aufgaben customised software further development
- Systemumgebungen Business Intelligence
- Vorgehensmodell Scrum
- Datenbanken MS SQL Server
- Entwicklungs- und Testtool MS Team Foundation Server TFS, SQL Server Business Intelligence Develop. Studio,
- Betriebssysteme Windows Server 2012
- Standardsoftware und BI Deltamaster, SAP Solution Manager, XL Cubed
Project period01.01.2017 - 31.12.2018
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
