Utilização da análise envoltória de dados na concepção de um sistema de apoio a decisão para gestão de uma distribuidora de recargas de dispositivos móveis

Abstract

The telecommunications industry has been suffering in recent years with their ability to increase its profitability. In this way, large companies in the market have adopted a strong strategy of reducing costs, promoting cuts in several segments of the business in an attempt to leverage its margin. Therefore, considering the need for performance improvements and assertiveness in the allocation of resources, the possibility of implementing a decision support system with the aid of a Data Envelopment Analysis (DEA) methodology was studied in a telecommunications company located in the city of Fortaleza. For this, one must take into account technological factors, using tools considered innovative for the market. Initially, the data sources needed to work were mapped and the quality of the data received was evaluated. After mapping, the architecture of the project was idealized in a second moment and validated by proof of concept (PoC) applied to a sample base. The development took place with the ETL process creation, performing treatments in the main fields related to neighborhoods and geographic coordinates, application of DEA methodology for prioritization of actions according to scale of efficiency and design of a methodology to classify the points of sales (POS) according to the level of revenue generated. The functionality of the system was validated by the practical application on the monthly basis of an operator, where it achieved a reduction of 1,247 points of sale, or 19.15%, without significantly impacting the total revenue, besides providing visual aids allowing analysis of each POS under different optics.