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 4822 IT projects that we have successfully completed with our customers.How can we support you?
Capital Reporting
Brief description
The customer regularly provides the parent company with data from a core system as reporting. For this purpose, the data has to be processed and enriched, which is controlled with the help of an Excel file. PTA has created a Power BI report, which imports and processes the data using Excel. From this Excel/CSV files can be exported and reported.
Supplement
PTA develops power query code that can read and understand comparison logic from an Excel file. Furthermore, PTA supports the customer in the further development and conception of the configuration Excel.
Subject description
The data in the core system is raw data which is used in a productive system. For upward reporting, however, a number of additional columns must be calculated from the existing data and some data sets must be combined with each other. The Excel file offers the customer the possibility to adapt the mappings continuously without having to adapt the code.
IT project data
- Industries banking
- Specialist tasks business intelligence, data analysis, Data Analytics, ETL, performance analysis
- DP tasks standard software development
- System environments Business Intelligence, technical data processing
- Procedure model customer standard
- Standard software and BI MS PowerBI
Project start01.04.2022
Customers who trust us
