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 4902 IT projects that we have successfully completed with our customers.How can we support you?
Development and adaptation of automatic reporting via Excel and VBA
Project duration: 8 months
Brief description
Our customer operates in the gas trade. To improve profits in gas sales and turnover planning, further functions are to be added to the existing software components. The objective is to increase the efficiency of the planning process by reducing processing time.
Supplement
The customer uses various Excel reports that are used to generate evaluations and as a complement to the BI system. Essentially, this involves presenting and formatting pivot tables. These are used for monitoring and as the basis of sales and turnover planning.
Subject description
To support sales and turnover planning, numerous Excel reports are created and automated using VBA. Essentially, this involves presenting pivot tables. The reports are used for pricing and quantity calculation. The data basis for the reports is an Oracle database that is operated by different systems. Excel is accessed via ODBC. From Excel, various stored procedures, views, and PL-SQL functions. The logic is partially mapped in VBA and PL-SQL procedures.
IT project data
- Industries energy
- Specialist tasks BPM: process optimization, BPM: process realization, gas trade, general IT environment
- DP tasks customised software new development
- System environments Client/Server
- Procedure model agile software development
- Programming languages PL/SQL, VBA
- Databases Oracle Database
- Middleware and frameworks ODBC
Project period01.10.2015 - 31.05.2016
Customers who trust us
Have we sparked your interest ?
