Management information system, a strategic tool to enhance decision making in micro and small businesses

Abstract

Background Nowadays, companies face continuous changes, which force them to be more versatile by managing large volumes of data, which do not always become relevant information for decision making. Therefore, the objective of this research is to implement a management information system to improve administrative management in micro and small businesses. Method it was developed under the approach of the agile methodology “SCRUM” following its 5 phases; In addition, the visual basic programming language in ASP.NET was used for the development of the source code and Microsoft SQL Server 2019 and its extensions: Ma-nagement Studio for data processing, “Integration Services” for the migration to the new dimensional model, Reporting Services for reports and Looker Studio for dashboards. Results The implementation of a management information system based on a dashboard allowed managers to obtain relevant information quickly and easily, optimizing decision-making times. In addition, the system allowed for homogeneous comparisons by level, which made it easier to identify deviations in commercial goals and the implementation of corrective actions such as adjustments in goals, changes in productivity, among others. Another result was the visualization of the monthly behavior of the financial system, which helped management structure short, medium and long-term strategies; in addition to the export of reports for “offline” analysis, which facilitates the work of employees in the field. Conclusions This allows reducing the time invested in generating reports, improving the efficiency and precision of the analysis. In addition, it has facilitated the identification of opportunities for improvement in administrative and commercial management, specifically in average productivity and the weighted average rate per advisor.