KPIs in Snowflake on Azure

As part of a process standardisation and modernisation a large set of KPIs related to power plant and environment management and health & safety at work are migrated to the organisation's central Snowflake DB data warehouse on the Microsoft Azure cloud. Improvements are made to the technical data model where most parts now following a star schema design. The data transformation logic is implemented as Python scripts running on Azure Batch Services. Features available in Snowflake, such as the management of time zones and time travel functionalities for reports comparing different versions, are used. A dedicated web frontend, written in Python, is available for users to start a data loading process manually, for example after uploading an Excel file.