Cost planning tool for dismantling industrial plants

Provided data structures of both source systems in the form of Excel and CSV exports form the basis to derive a consolidated data model within a SQL Server data management. In order to prepare a permanent import of the source data, appropriate interface functionalities are implemented which cleanse, consolidate and store the incoming information in the required format in the new data storage. On the one hand, these include .NET functionalities for extraction and preparation for data processing, on the other hand, database procedures to be able to handle a high-performance comparison with already existing information. Appropriate data views offer the possibility to present information via any tools like Excel Power Pivot or Power BI. The task of PTA lies in the conception of the IT system in close coordination with the business department, the data modeling and implementation of the interfaces as well as the evaluation basis.