Implementation of database views as an access layer for a reporting tool

The aim of the transformation process to be set up is the automated checking and preparation of the data deliveries provided in Excel and csv format and the 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 historicised in an SQL database. The processed raw data is then used in Tableau to create reports with key figures on the gas and electricity networks operated by the customer. The Tableau reporting tool does not access the imported raw data directly, but uses an access layer based on database views, which filters and consolidates the raw data.