Establishment of a data solution for network access

The goal of the transformation process to be set up is the automated checking and preparation of the data deliveries provided in Excel format and further processing of this raw data into monthly reports in Tableau. The import data is first checked for incorrect structure and content, corrected if necessary, and then stored and historized in an SQL database. The processed raw data is then used to create reports in Tableau with key figures for the gas and electricity networks operated by the customer. The responsible department is also offered a function for commenting on the reports created.