Client:
MEDELLIN MAYOR´S OFFICE
City of Medellín – Colombia
December 2021
“A unique project in Colombia processing large volumes of data and developing dashboards and advanced analytical models for the generation of insights and key indicators for local government”
Juan Felipe Salazar
Director
Overview
Design of a data model, dashboards and development of a unified command post that integrates external services and applications as well as information from different devices and sources for further analysis and visualization.
Challenge
Develop a unified platform for the analytics and information management of the Medellin mayor’s office
Data model
Definition of a metadata model based on international standards that allow interoperability with other information systems.
Integration and Interoperability
Allow the development and integration of services provided by external entities in a simple way by offering APIs.
Visualization
Set of Dashboards in Tableau / Power BI / Grafana connected to the integrated data model that allows real-time visualization.
Solution
Develop a platform that allows complete understanding by the mayor´s office with the data generated from the city and supporting the decision-making process.
Prototype
Evolutionary prototypes were designed that contained data (real and fictitious) and helped to validate the operation of the use cases.
Product
Individual and integrated tests were carried out based on an analysis and planning of test cases, keeping a record of the results obtained.
Deployment in Production
Initial configuration, implementation of the final version and deployment in production were provided.
Results
- Web Platform deployed to integrate existing and new dashboards with user authentication and role definition.
- 10 new dashboards implemented.
- 20 existing dashboards integrated.
- Web and mobile friendly dashboard development.
- Data transformation processes completed and automated.
- Data Lake and 20+ data sources processed.
