Centralised data lake with seamless integrations

Vaanster, a leader in the the sustainable energy sector, faced significant challenges in managing their growing data needs. With a mission to develop, finance, and operate collective sustainable energy systems, Vaanster needed a solution to improve their reporting, business intelligence, data analytics, and integration capabilities. To support their mission of advancing sustainable energy while ensuring operational excellence, they needed a robust, integrated solution for data management and analytics.

The Challenge

As Vaanster expanded, maintaining a clear overview of business processes became increasingly difficult. Vaanster relies on two primary software systems: Planon for property, building, and asset management, and Zero Friction for invoicing and client management. These systems were not integrated, resulting in fragmented data and limited analytical capabilities. Additionally, Vaanster needed better control and insights from their Kamstrup meters, which measure heating, cooling, and energy usage across all 164 projects.

The existing systems offered limited options for performing comprehensive analyses, and the lack of integration between Planon, Zero Friction and Kamstrup measurements made reporting cumbersome. Furthermore, Vaanster’s meter-data, critical for accurate billing and maintenance, occasionally showed unexpected variance, which required manual adjustments. Hence, there was a pressing need for a centralized data solution to enhance reporting, provide real-time analytics, and ensure data accuracy.

The Solution

TECHLETES developed a comprehensive data lake solution tailored to Vaanster's needs. This centralized data lake integrates data from Planon, Zero Friction, and Vaanster’s extensive network of Kamstrup meters, which measure heating, cooling, and energy usage every 15 minutes. The solution offers seamless data flow and accessibility, enabling robust analytics, business intelligence, and reporting.

Leveraging Power BI, TECHLETES created dynamic dashboards that provide Vaanster with actionable insights and real-time monitoring of their business processes. These dashboards empower stakeholders with the information needed to make strategic decisions, optimize operations, and enhance overall performance. Additionally, an automated control mechanism was implemented to monitor sensors and detect faulty measurements, significantly improving data accuracy and reliability.

Implementation

The implementation followed an iterative approach, ensuring continuous feedback and refinement throughout the project. This methodology allowed TECHLETES to adapt to Vaanster's evolving requirements and deliver a solution that perfectly aligned with their business objectives.

Benefits

  • Enhanced Reporting and Analytics: Centralized data storage and integration with Power BI have significantly improved Vaanster's reporting and analytics capabilities, driving data-informed decision-making.
  • Cost Savings: By developing a custom solution, Vaanster saved €8,000 in annual licensing fees, while improving flexibility and data-control.
  • Improved Data Accuracy: The automated control mechanism ensures reliable sensor data, reducing manual updates and errors.
  • Seamless Integration: The solution integrates Kamstrup, Planon and Zero Friction, providing a unified view of all business processes.
  • Future-Proofing: The flexible and scalable nature of the data lake solution allows for future integrations with other software systems Vaanster might use.

Client Feedback

"TECHLETES delivered exactly what we needed: a robust and scalable data solution that has enhanced our decision-making process and overall business performance.”

Evert van de Braak, Director of Assetmanagement at Vaanster

Conclusion

The partnership between Vaanster and TECHLETES has revolutionized Vaanster's data management and analytics capabilities. Our custom-built data lake and integrated reporting tools have not only enhanced their operational efficiency but also positioned them for future growth. By centralizing data and providing powerful reporting tools, Vaanster can now make more informed decisions, ultimately driving their mission of sustainability forward.

Ready to transform your data and AI capabilities? Contact us at info@techletes.ai to learn how we can help your business achieve its goals.