Kalmar Municipality Case Study - Holisticon
Skip to content
CASE STUDY

Integrating Critical Data for Smart Cities Initiative

Building a data-driven approach to government takes time and talent but is absolutely essential. This approach is crucial to making the best, most informed decisions for your municipality in today’s data-rich world. Through its hybrid data platform, Holisticon Insight (Nexer Insight) helps organisations, including
governments, build their data-driven practices by getting data, no matter where it resides, to those needing it.
– CARL TÖNSETH, BUSINESS MANAGER IOT & AI, SWEDEN

BACKGROUND

Kalmar Municipality, located in south-eastern Sweden, comprises 15 local government units and 16 cities, including Kalmar.

Like all local governments, Kalmar’s data is spread across many legacy systems, making it very difficult to aggregate data into a single source, access accurate, consistent data, extract and deliver insights, and maintain or lower overall costs.

Using Microsoft’s technology, Kalmar explored the potential of bringing this critical data together in the cloud. By doing so, they could quickly identify and resolve problems related to service delivery while following strict compliance regulations and guidelines for data collection and governance, including GDPR.

CHALLENGE

Kalmar had been working on a project with Microsoft to collect data from multiple legacy system sources but needed a secure place to store it – a data platform. Microsoft introduced their partner, Holisticon Insight (Nexer Insight), to Kalmar to explore different options for data management while ensuring full compliance with all established protocols and policies for protecting and managing this data.

To pilot the platform and demonstrate value early, surveys were conducted across Kalmar’s departments to identify use cases expected to drive significant value.

The use cases chosen were:

1.) Investigating the connection between food waste and sound levels in schools and restaurants, and,

2.) Tracking and analysing domestic and business refuse collection operations, including real-time route information, issues faced by trucks, and factors that contribute to bins not being emptied, such as weather and attendance.

SOLUTION

Holisticon Insight (Nexer Insight) and Kalmar created an Azure hybrid data platform using SQL Server and Azure Data Factory to standardise and share data. The platform was designed to comply with GDPR and include data from on-premises SQL environments and IoT sensors on a LoRaWAN network. A proof of concept for Purview was also implemented for data lineage tracking and data governance.

BENEFITS & RESULTS

Holisticon Insight (Nexer Insight) successfully created a Hybrid Data platform featuring two mirrored structures, one on-premises and the other in the cloud, with a steadfast commitment to security. They have also fully complied with GDPR by implementing stringent measures when transferring data between on-premises and the cloud.

Kalmar is still amidst the ongoing refuse collection project, and they continue to be satisfied with the valuable insights they gain from the data.

The team reviewed multiple use cases and decided to shift their focus to visitor data, examining weather, events, days, and visitors to determine if they are attracting the desired audience. This information will offer insights into the future of specific events, with the project still in its developmental stage.

LOOKING FOR OUR CASE STUDY IN PDF FORMAT?

DOWNLOAD NOW

GET IN TOUCH

Inspired by our success stories? Contact us today to discover how our cutting-edge solutions can enhance operational efficiency and improve business outcomes.

Want to know more?
Andrzej Winiarski
Business Unit Manager

+48 729 05 46 12
andrzej.winiarski@x-insight.pl

contact person

Never miss a thing With Holisticon´s newsletter you get all the latest updates on everything we do.

With Holisticon´s newsletter you get all the latest updates on everything we do.