This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4905 IT projects that we have successfully completed with our customers.How can we support you?
Balanced scorecard functions in a company database
Project duration: 1 year, 5 months
Brief description
Designing and developing a balanced scorecard for finances, controlling and logistics.
Supplement
In addition to the evaluations carried out with MS Access on the basis of the SQL server database, the Analysis Services data warehouse functions are used.
Subject description
The balanced scorecard consists of the department sub-cards and the division cards. Accounting key figures are identified on a monthly, quarterly or annual basis and displayed from the perspective of the customer, employee, process and finances. Additionally, "traffic lights" are used for visual checking of quality, and spider charts are used for a quick overview of the different perspectives.
IT project data
- Industries pharmaceutical industry
- Specialist tasks Controlling, financials
- DP tasks Data Warehouse
- System environments Client/Server
- Procedure model Summit-D (PwC)
- Programming languages VBA
- Databases MS Access, MS SQL Server
- Development and test tool MS Query Analyzer
- Middleware and frameworks MS SQL Server Analysis Services (SSAS)
Project period01.05.2004 - 30.09.2005
Customers who trust us
