Analítica de datos para importaciones y exportaciones de Colombia a partir de datos abiertos

Abstract

In this work, analytical and business intelligence techniques are applied to open data on imports and exports from Colombia and a real-time tool is created - subject to updating the information provided by the virtual sites used - on the trade balance. Open data sources on Colombian imports and exports are analyzed and managed; The indicators and KPIs to be taken into account are determined, the appropriate analytical techniques are proposed to model and project time series that allow to raise the indicators and KPIs, find relationships and patterns from the data previously extracted; the development of a prototype of a BI tool on the trade balance is proposed that allows managing the indicators, relationships and previously defined patterns, in real time and from the open data extracted, updated, added, analyzed and standardized automatically.