Tableros y gráficos automatizados: un enfoque a la visualización de datos e inteligencia de negocios

Abstract

The purpose of this article is to investigate the importance of business intelligence and its effectiveness in a business organization together with the need for data visualization. As time goes by, business intelligence is becoming more and more important in organizations. For this reason it is focused on solving problems in various organizational sectors by extracting, filtering and modeling information. Technological tools to develop business intelligence have been growing satisfactorily in agribusiness and agricultural markets worldwide. In the following research, the Kimball method was applied. Two sequential moments were carried out, to proceed to extract the data in Microsoft Excel, where the BI architecture design of the company was used, the identification of indicators, design of database dashboards, development of extraction, transformation and loading of the process and implementation of dimensional model, management development and development of sales report, which resulted that the Kimball methodology allowed the use of data more quickly the implementation of information within the company, for this reason, it is convenient to implement BI in the areas of production and finance.