DESIGN & COMMUNICATION
TECH & DEVELOPMENT
BUSINESS OPERATIONS
STRATEGY, TALENT & MANAGEMENT
ENGINEERING
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.
BACKGROUND
Kalmar Municipality in southeastern Sweden needed to consolidate data from multiple legacy systems. With Microsoft’s technology, they began exploring a secure cloud approach to improve data access, insights, and compliance with GDPR.
CHALLENGE
Kalmar required a secure and compliant platform to store and manage data from across its various systems. Microsoft introduced Nexer Insight to help define the solution.
The early 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 built a hybrid Azure-based platform using SQL Server and Azure Data Factory. It integrates on-prem and IoT data, supports GDPR compliance, and includes Microsoft Purview for data governance and traceability.
BENEFITS & RESULTS
– Secure, compliant hybrid data platform
– Real-time insights into operational data
– Ongoing value from use cases like waste management and visitor tracking
– Strong foundation for scalable data-driven decision-making