Purmerend district heating

In short
Sector
Energy & Utilities
Service
Azure Synapse, Power BI, Data Factory
Solution
Data lake, reports, data architecture

2

months to go live

FUTURE PROOF

ALWAYS UP-TO-DATE

Background

Stadsverwarming Purmerend (SVP) manages the district heating network of the municipality of Purmerend as an integrated utility. This means that production, delivery, and billing are all handled by the same organization. They operate a heating plant, manage the distribution network, and supply heat to about 30,000 connections in the region.

Software migration

SVP migrated MECOMS (based on Microsoft Dynamics) from the 2012 version to Dynamics 365.

Challenges

Changes in the data model

The upgrade came with a modified underlying data model.

No reports to operate on

Existing reports partly stopped working, even though they were crucial for daily operations.

Solution needed within 2 months

SVP required a completely new data analysis and reporting environment within 2 months, including a reassessment and rebuild of all reports.

Solution

Maintainable, flexible and always up to date

The new data landscape has been completely redesigned for the long term. No more old, circulated report versions; everyone at SVP works with the latest insights.

    Azure Data Factory

     to connect source systems to a data lake.

    Medallion architecture

     (bronze → silver → gold) for clean, consistent data.

    Synapse in Microsoft Fabric

     to transform the data and prepare it for analysis.

    Power BI reports

     with interactive dashboards: these also give the business much more flexibility; charts and insights can be added independently, without the help of consultants.

Want to know more?

Get into contact with

Auke

Data & Analytics Lead | Business Technology Consultant
Cases

More success stories