Desarrollo de una aplicación web de soporte de decisiones para el control de la información financiera de una productora bananera

Abstract

Due to the automation of processes in different aspects of daily life, the implementation of technology has played a very important role in the workplace, which has led companies to make use of systems that allow them to keep up with a more digitized era. This has led to the appearance of new technologies that facilitate this task together with data management, as is the case of information systems whose objective is the administration and control of the data and information that compose it. Taking this into account, specialized systems have been created to support the managers of a business when making decisions, these are known as Decision Support Systems. DSS, whose purpose is to provide information to help the user to make timely decisions, to improve the effectiveness of these. It should be emphasized that this type of system does not replace the judgment of the manager of a company, but it does help him not to make intuitive decisions, and instead allows him to analyze other options based on real data. Translated with www.DeepL.com/Translator, free version. For the above mentioned, the present technological proposal arises, which focuses on the creation of a decision support web application for the control of the financial information of a banana producer through the use of the agile development methodology known as Extreme Programming, XP. This methodology was chosen because it is focused on customer satisfaction and also because of the constant communication that the customer has with the developer in case of changes in the initial requirements. The web application is built with frontend, backend and database technologies. In the frontend, the Angular Framework was used for the creation of user interfaces, HTML in conjunction with Bootstrap for the design, and Typescript for the management of the information presented in these interfaces. In the backend, Javascript and Node.js were used to generate the functions that will allow communication between the client and the server, and finally PostgreSQL for database management. Among the most important functionalities of the web application are the dashboard that graphically informs about the income and expenses generated by the company in the years registered in the database, as well as the status of the key performance indicators. KPIs, it also has an interface for the traceability of expenses, which will consist of 3 informative graphs about the expenses incurred according to the phases of planting, care and harvesting of bananas. Once the system was completed, a quality self-assessment was performed according to the characteristics of ISO-IEC 9126, which are, functionality, reliability, usability, efficiency, maintainability and portability, the result was a very good evaluation that gives the web application a sufficient level of quality to be used by the banana producer's users.