This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Support for analysis systems for a pharmaceutical manufacturer's production costs and sales data
Project duration: 4 years, 3 months
Brief description
In this project, support is provided for a pharmaceutical company's analysis systems. The analysis systems are OLAP databases covering the sales data area and the production costs as well. Both sets of databases record the data down to the level of individual articles. The support comprises safeguarding operation, implementing changes, and database migration.
Supplement
The database software used by the customer is the SQL Server 2005 from Microsoft. The Business Intelligence Development Studio, based on Visual Studio 2005, 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 successor to the Enterprise Manager for SQL Server 2000. 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. The ticket system used is a customized solution developed by the customer using Sharepoint.
Subject description
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 option of analyzing 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 dimensions are integrated into the management reporting concept (existing analysis database at a rougher level).
Overview
- Industries pharmaceutical industry
- Specialist tasks cost analysis, Reporting, sales analysis, turnover analysis
- DV tasks Support
- System environment Business Intelligence, Client/Server
- Databases MS SQL Server
- Development/ test tools MS Visual Studio
- Operating systems Windows 7, Windows Server 2003 EE, Windows XP
- Standard software BI Documenter, SAP BI, SAP BW, SAP Solution Manager, SQL Compare
Project period01.01.2008 - 31.03.2012
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
