{"id":133,"date":"2021-12-29T13:04:52","date_gmt":"2021-12-29T18:04:52","guid":{"rendered":"https:\/\/jupiterx.artbees.net\/business-2\/?post_type=portfolio&p=133"},"modified":"2022-02-10T10:18:53","modified_gmt":"2022-02-10T15:18:53","slug":"medellin-center-of-analytics","status":"publish","type":"portfolio","link":"https:\/\/dation.co\/en\/portfolio\/medellin-center-of-analytics\/","title":{"rendered":"Platform for Medellin Center of Analytics"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Client:<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

MEDELLIN MAYOR\u00b4S OFFICE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

City of Medell\u00edn \u2013 Colombia
December 2021<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

\u201cA 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\u201d<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t

Juan Felipe Salazar
Director<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Overview<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

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.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

Challenge<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Develop a unified platform for the analytics and information management of the Medellin mayor’s office<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t<\/i>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t
\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t\tData model\t\t\t\t\t<\/span>\n\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\tDefinition of a metadata model based on international standards that allow interoperability with other information systems.\t\t\t\t\t<\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t<\/i>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t
\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t\tIntegration and Interoperability\t\t\t\t\t<\/span>\n\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\tAllow the development and integration of services provided by external entities in a simple way by offering APIs.\t\t\t\t\t<\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t<\/i>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t
\n\t\t\t\t

\n\t\t\t\t\t\n\t\t\t\t\t\tVisualization\t\t\t\t\t<\/span>\n\t\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\tSet of Dashboards in Tableau \/ Power BI \/ Grafana connected to the integrated data model that allows real-time visualization.\n\n\t\t\t\t\t<\/p>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Solution<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Develop a platform that allows complete understanding by the mayor\u00b4s office with the data generated from the city and supporting the decision-making process.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t
01<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Prototype<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Evolutionary prototypes were designed that contained data (real and fictitious) and helped to validate the operation of the use cases.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t
02<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Product<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Individual and integrated tests were carried out based on an analysis and planning of test cases, keeping a record of the results obtained.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t
03<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Deployment in Production<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Initial configuration, implementation of the final version and deployment in production were provided.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Results<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
  • Web Platform deployed to integrate existing and new dashboards with user authentication and role definition.\u00a0\u00a0\u00a0<\/li>
  • 10 new dashboards implemented.\u00a0<\/li>
  • 20 existing dashboards integrated.<\/li>
  • Web and mobile friendly dashboard development.<\/li>
  • Data transformation processes completed and automated.<\/li>
  • Data Lake and 20+ data sources processed.\u00a0<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t<\/span>\n\t\t\t\t0<\/span>\n\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t
    New dashboards implemented<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t<\/span>\n\t\t\t\t0<\/span>\n\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t
    Existing dashboards integrated<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t<\/span>\n\t\t\t\t0<\/span>\n\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t
    Mobile friendly dashboards<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t<\/span>\n\t\t\t\t0<\/span>\n\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t
    Data sources processed<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

    \u201cA 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\u201d<\/p>\n","protected":false},"author":1,"featured_media":1609,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","portfolio_category":[3],"portfolio_tag":[77],"class_list":["post-133","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry","portfolio_category-software-solution","portfolio_tag-platform-for-medellin-center-of-analytics"],"acf":[],"_links":{"self":[{"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":73,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio\/133\/revisions"}],"predecessor-version":[{"id":2459,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio\/133\/revisions\/2459"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/media\/1609"}],"wp:attachment":[{"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio_category?post=133"},{"taxonomy":"portfolio_tag","embeddable":true,"href":"https:\/\/dation.co\/en\/wp-json\/wp\/v2\/portfolio_tag?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}