Support and interface development for central KPI reporting at a pharmaceutical company

The database software used by the customer is the SQL Server 2008 from Microsoft. The Business Intelligence Development Studio, based on Visual Studio 2008, 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.