This is one of 4552 IT projects that we have successfully completed with our customers.

How can we support you?

Migration of Data storage of the gas storage management from Excel to Snowflake database

Project duration: 5 months

Brief description

For the reporting of the gas storage capacity, a global power plant operator uses Excel with VBA. In order to improve the application performance and user acceptance, the data storage is migrated to Snowflake and additional business logic is implemented.

Supplement

The Excel VBA application is replaces by a Snowflake database on Azure. Data from different data sources are integrated in Snowflake as data warehouse using different services (Azure Function App, Azure Webjobs, Sharepoint API). The ETL tool Talend is used to start an Azure Batch Account, which is calling Python scripts. The Python scripts are running SQL statements to transform the data on Snowflake and also insert the transformed data back into Snowflake. The transformed data on Snowflake can be used for reporting on Power BI.

Subject description

The customer used Excel for capacity management of gas storages. In the application, technical and business data from external systems are imported. The available capacity of the gas storage is calculated and used for capacity planning and trading.

Have we sparked your interest?

Dr. Andreas Schneider

Sector Manager Energy

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.