A modern data architecture with Azure Synapse and Power BI for SVP
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.
Stadsverwarming Puremerend
Service
Solution
Sector
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.
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.
.jpg)
.jpg)
