Menu
This is one of 4544 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.
Overview
- Branchen banking
- Fachaufgaben business intelligence, data analysis, Data Analytics, ETL, performance analysis
- DV-Aufgaben standard software development
- Systemumgebungen Business Intelligence, technical data processing
- Vorgehensmodell customer standard
- Standardsoftware und BI MS PowerBI
Have we sparked your interest?
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
