Skip to content
MENU
SELECT LANGUAGE SELECT COUNTRY
CASE STUDY

CRITICAL DATA INTEGRATED INTO A DATA PLATFORM AS PART OF 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, 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, 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:

− Investigating the connection between food waste and sound levels in schools and restaurants, and,

− 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

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

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 involved in the ongoing refuse collection project, and it continues to be satisfied with the valuable insights it gains 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 learn how our innovative solutions boost operational efficiency and drive better business results.

Get in Touch
David Österlindh
CEO


contact person