Purmerend district heating
Insight created with always up to date reports that are easy to maintain.
Purmerend District Heating (SVP) manages the district heating network of the municipality of Purmerend as an 'integrated utility'. This means that both production, delivery and billing are with the same party. They manage a heat plant, the distribution network and provide heat to around 30,000 connections in the region.
Out of date reports
SVP uses the MECOMS software package from supplier Ferranti. This is a software package based on Microsoft Dynamics. A 2012 version of this was used that migrated to a 365 version, also changing the underlying data model. The existing reports based on Microsoft Sequel Server Reporting Service (SSRS) thus partly expired, but were necessary for the proper functioning of processes in the business.
What was needed was a completely new data analysis and reporting environment that we set up in 2 months and the complete revaluation and analysis of all existing reports.
Unlock, clean, transform and report data
The new data landscape is set up quite differently than the old SSRS setup. Via Azure Data Factory, data is synchronized from the source systems to a data lake. From there, with Synapse, you have the opportunity to set up a modern data architecture. We have set up a medallion data architecture in which the data is updated every step (from “bronze”, to “silver”, to “gold”) into understandable, unambiguous and clean data. Synapse is also the tool for transforming data in the latest Microsoft analysis platform Fabric.
We set up the reports in Power BI based on the existing reports. And thanks to the possibilities of Power BI, we have set up a number of new reports that provide quick insight into, for example, the location of a heat interruption. Where the SSRS reports focused on static data dumps, Power BI is more suitable for independently looking for additional insights into the data for the business. All data that is unlocked in the data lake can be added to the reports by the business itself.
The benefits
- Maintainability. All data used for a report is based on the same tables. If business logic needs to be changed, it happens everywhere at once
- Reports can easily be enriched with insights. In Power BI, a graph can easily be modified or added without the help of our consultants
- Always up to date insights. No old versions of a report that has been downloaded and is wandering around the organization
- Future-proof landscape. Of course, you never know what the future holds, but building something in SSRS now probably means rebuilding everything within 4 years.
Neem contact op met
Auke
.jpg)
.webp)
.jpg)
