Implementación de un cuadro de mando para el análisis predictivo de las zonas de mayor aumento de cartera vencida del Almacén Unicomercio.

Abstract

The process of obtaining the past-due portfolio status of customers located in the UNICOMERCIO WAREHOUSE area, as well as knowing the direction that the areas are taking, generates some inconveniences when making decisions by management. The UNICOMERCIO WAREHOUSE requires a technological solution, due to this, the implementation of a control panel was proposed that allows to visualize, in a more detailed way, the state of the overdue portfolios, at the same time as obtaining a prediction of the behavior of said portfolio. according to your trend. It was decided to use research by objectives with a focus on applied research and for the data collection technique, the interview with company personnel was chosen. It was agreed with the store manager that the program be developed with the React Framework and using the existing access credentials in the sales system; the process and categorization of the credits was known, as well as the segmentation by zone that is given to each client. The benefit of using a visual tool that helps in the knowledge and visualization of the past-due portfolio of the client and how it is distributed in the different areas of the Simón Bolívar canton was pointed out. It was concluded that the project facilitates knowledge and decision-making on the non-performing portfolio, allowing a view of the debt of clients in each area.