1
2
3
4
5
Source Systems
Staging Data Lake
Enterprise Warehouse
Information Delivery
Data Consumption
Azure Data Lake Iceberg
Snowflake Data Vault
Snowflake Marts
ERP
Internal apps
LAKE NETZ
NETZ
NETZ
Embedded workflows
CRM
Power BI
LAKE AG
AG
AG
Managed reporting
Customer support
API
LAKE CROSS
CROSS
CROSS
Other systems
Application interfacing
Python dbt
dbt
datavault4dbt
Python on k8s
datavault4dbt
Catalog & Lineage
OpenMetadata Ownership Discoverability
Code & Delivery
GitHub Enterprise Issue Management CI/CD
At the foundation of the platform, data is ingested into dedicated staging environments built on Azure Data Lake and Apache Iceberg. Separate data lake environments are maintained for the dif- ferent subsidiaries and shared service areas, allowing data to be collected, stored, and processed while respecting organizational boundaries. Scalable processing capabilities based on Python and Kubernetes provide a flexible foundation for integrating and preparing enterprise data. An enterprise data warehouse (EDW) built with Data Vault methodology serves as the foundation of the platform. The EDW resides on Snowflake and is implemented using dbt Platform and dat- avault4dbt - a package created by Scalefree to streamline and automate Data Vault implementation. This layer provides a scalable, auditable, and historically traceable repository for enterprise infor- mation. Separate warehouse structures for the individual subsidiaries and shared domains ensure that data ownership and access controls can be implemented consistently while still enabling controlled shar- ing of approved information. The Data Vault methodology also supports long-term maintainability and simplifies the integration of new business areas and future acquisitions. Above the warehouse layer, business-, and use-case-oriented information marts are created to pro- vide data products tailored to analytical and reporting requirements. This separation between en- terprise-wide storage and consumption-ready models ensures that business logic is implemented once and reused consistently across multiple use cases. As a result, analytical applications, opera- tional reporting, and management dashboards can rely on a common and trusted data foundation. The platform supports multiple consumption channels, including reporting solutions, internal appli- cations, embedded workflows, and API-based integrations. This enables business users and techni- cal consumers to access governed data products through the tools most appropriate for their needs while maintaining consistent KPI definitions and standardized reporting across the organization.
Enercity AG Success Story - Engineering KPI Trust - Share Reliable Data in a Regulated Industry
5/12
Powered by FlippingBook