AI & MACHINE LEARNING
BESPOKE DATA VISUALISATIONS
CUSTOM SOFTWARE DEVELOPMENT
CLOUD & OPERATIONS
DATA & ANALYTICS
EMBEDDED & ENGINEERING
IOT & CLOUD
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.
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 NOWGET 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