<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE article PUBLIC "-//NLM//DTD JATS (Z39.96) Journal Publishing DTD v1.2 20190208//EN" "http://jats.nlm.nih.gov/publishing/1.2/JATS-journalpublishing1.dtd"><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" article-type="other" dtd-version="1.2" xml:lang="en">
    <front>
        <journal-meta>
            <journal-id journal-id-type="pmc">F1000Research</journal-id>
            <journal-title-group>
                <journal-title>F1000Research</journal-title>
            </journal-title-group>
            <issn pub-type="epub">2046-1402</issn>
            <publisher>
                <publisher-name>F1000 Research Limited</publisher-name>
                <publisher-loc>London, UK</publisher-loc>
            </publisher>
        </journal-meta>
        <article-meta>
            <article-id pub-id-type="doi">10.12688/f1000research.144450.1</article-id>
            <article-categories>
                <subj-group subj-group-type="heading">
                    <subject>Software Tool Article</subject>
                </subj-group>
                <subj-group>
                    <subject>Articles</subject>
                </subj-group>
            </article-categories>
            <title-group>
                <article-title>Management information system, a strategic tool to enhance decision making in micro and small businesses</article-title>
                <fn-group content-type="pub-status">
                    <fn>
                        <p>[version 1; peer review: 2 approved with reservations]</p>
                    </fn>
                </fn-group>
            </title-group>
            <contrib-group>
                <contrib contrib-type="author" corresp="no">
                    <name>
                        <surname>CRUZ MARTINEZ</surname>
                        <given-names>SILVIA JACQUELINE</given-names>
                    </name>
                    <role content-type="http://credit.niso.org/">Conceptualization</role>
                    <role content-type="http://credit.niso.org/">Formal Analysis</role>
                    <role content-type="http://credit.niso.org/">Investigation</role>
                    <role content-type="http://credit.niso.org/">Methodology</role>
                    <role content-type="http://credit.niso.org/">Software</role>
                    <role content-type="http://credit.niso.org/">Validation</role>
                    <role content-type="http://credit.niso.org/">Writing &#x2013; Original Draft Preparation</role>
                    <uri content-type="orcid">https://orcid.org/0009-0009-0404-1583</uri>
                    <xref ref-type="aff" rid="a1">1</xref>
                </contrib>
                <contrib contrib-type="author" corresp="yes">
                    <name>
                        <surname>ASTO CASTRO</surname>
                        <given-names>EDDIE DAMIAN</given-names>
                    </name>
                    <role content-type="http://credit.niso.org/">Conceptualization</role>
                    <role content-type="http://credit.niso.org/">Formal Analysis</role>
                    <role content-type="http://credit.niso.org/">Methodology</role>
                    <role content-type="http://credit.niso.org/">Resources</role>
                    <role content-type="http://credit.niso.org/">Software</role>
                    <role content-type="http://credit.niso.org/">Supervision</role>
                    <uri content-type="orcid">https://orcid.org/0009-0008-1221-4598</uri>
                    <xref ref-type="corresp" rid="c1">a</xref>
                    <xref ref-type="aff" rid="a1">1</xref>
                </contrib>
                <contrib contrib-type="author" corresp="yes">
                    <name>
                        <surname>Pacheco</surname>
                        <given-names>Alex</given-names>
                    </name>
                    <role content-type="http://credit.niso.org/">Conceptualization</role>
                    <role content-type="http://credit.niso.org/">Formal Analysis</role>
                    <role content-type="http://credit.niso.org/">Methodology</role>
                    <role content-type="http://credit.niso.org/">Resources</role>
                    <role content-type="http://credit.niso.org/">Software</role>
                    <role content-type="http://credit.niso.org/">Supervision</role>
                    <role content-type="http://credit.niso.org/">Validation</role>
                    <role content-type="http://credit.niso.org/">Writing &#x2013; Review &amp; Editing</role>
                    <uri content-type="orcid">https://orcid.org/0000-0001-9721-0730</uri>
                    <xref ref-type="corresp" rid="c2">b</xref>
                    <xref ref-type="aff" rid="a1">1</xref>
                </contrib>
                <aff id="a1">
                    <label>1</label>Escuela de Ingenieria y Arquitectura, Universidad Cesar Vallejo, Trujillo, La Libertad, 13001, Peru</aff>
            </contrib-group>
            <author-notes>
                <corresp id="c1">
                    <label>a</label>
                    <email xlink:href="mailto:easto12@ucvvirtual.edu.pe">easto12@ucvvirtual.edu.pe</email>
                </corresp>
                <corresp id="c2">
                    <label>b</label>
                    <email xlink:href="mailto:aapachecop@ucvvirtual.edu.pe">aapachecop@ucvvirtual.edu.pe</email>
                </corresp>
                <fn fn-type="conflict">
                    <p>No competing interests were disclosed.</p>
                </fn>
            </author-notes>
            <pub-date pub-type="epub">
                <day>21</day>
                <month>3</month>
                <year>2024</year>
            </pub-date>
            <pub-date pub-type="collection">
                <year>2024</year>
            </pub-date>
            <volume>13</volume>
            <elocation-id>206</elocation-id>
            <history>
                <date date-type="accepted">
                    <day>12</day>
                    <month>2</month>
                    <year>2024</year>
                </date>
            </history>
            <permissions>
                <copyright-statement>Copyright: &#x00a9; 2024 CRUZ MARTINEZ SJ et al.</copyright-statement>
                <copyright-year>2024</copyright-year>
                <license xlink:href="https://creativecommons.org/licenses/by/4.0/">
                    <license-p>This is an open access article distributed under the terms of the Creative Commons Attribution Licence, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.</license-p>
                </license>
            </permissions>
            <self-uri content-type="pdf" xlink:href="https://f1000research.com/articles/13-206/pdf"/>
            <abstract>
                <sec>
                    <title>Background</title>
                    <p>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.</p>
                </sec>
                <sec>
                    <title>Method</title>
                    <p>it was developed under the approach of the agile methodology &#x201c;SCRUM&#x201d; 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, &#x201c;Integration Services&#x201d; for the migration to the new dimensional model, Reporting Services for reports and Looker Studio for dashboards.</p>
                </sec>
                <sec>
                    <title>Results</title>
                    <p>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 &#x201c;offline&#x201d; analysis, which facilitates the work of employees in the field.</p>
                </sec>
                <sec>
                    <title>Conclusions</title>
                    <p>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.</p>
                </sec>
            </abstract>
            <kwd-group kwd-group-type="author">
                <kwd>Web system</kwd>
                <kwd>dashboard</kwd>
                <kwd>SIG</kwd>
                <kwd>Datamart</kwd>
                <kwd>Looker Studio.</kwd>
            </kwd-group>
            <funding-group>
                <award-group id="fund-1">
                    <funding-source>This research was funded by the vice rectorate of research of the Universidad Cesar Vallejo.</funding-source>
                    <award-id>6000139023</award-id>
                </award-group>
                <funding-statement>This research was funded by the vice rectorate of research of the Universidad Cesar Vallejo.&#13;
The grant number for this research work is: 6000139023.&#13;
</funding-statement>
                <funding-statement>
                    <italic>The funders had no role in study design, data collection and analysis, decision to publish, or preparation of the manuscript.</italic>
                </funding-statement>
            </funding-group>
        </article-meta>
    </front>
    <body>
        <sec id="sec5" sec-type="intro">
            <title>1. Introduction</title>
            <p>Currently, companies face continuous changes, which force them to be versatile, to reinvent themselves and to manage large volumes of data that are not always relevant information for decision making; This is when micro and small companies in the financial sector find themselves at a point where the interpretation, analysis and application of information is essential to keep up with the competitive and globalized world.
                <sup>
                    <xref ref-type="bibr" rid="ref1">1</xref>
                </sup> In this context, the technological tools that emerge every day help in everyday processes, allowing the integration, optimization and automation of processes to meet the objectives of organizations, generating significant changes and benefits.
                <sup>
                    <xref ref-type="bibr" rid="ref2">2</xref>
                </sup> One of these tools is Management Information Systems, which in recent years have been the subject of much research to apply them in various fields, being considered a powerful option to create competitive advantages, increase organizational capacity in the face of change, reduce time in making decisions and obtaining accurate information.
                <sup>
                    <xref ref-type="bibr" rid="ref3">3</xref>
                </sup>
            </p>
            <p>In previous times, micro and small companies in the microfinance sector managed their data on paper, an overwhelming situation for the documentary staff who had to generate reports, which is why companies found themselves in the need to systematize the processes.
                <sup>
                    <xref ref-type="bibr" rid="ref4">4</xref>
                </sup> Management information systems provide advantages to obtain valuable, reliable, updated information, and can be applied in different functional areas of the organization.
                <sup>
                    <xref ref-type="bibr" rid="ref5">5</xref>
                </sup> In addition, it allows improving information control, provides support for operational processes, and makes correct decisions in any area in which they operate.
                <sup>
                    <xref ref-type="bibr" rid="ref6">6</xref>
                </sup>
            </p>
            <p>In this sense, this management information system is an interesting proposal to improve administrative management, since it consists of recording data more efficiently, minimizing errors, saving time on manual work, reducing costs, and resolving customer queries faster.
                <sup>
                    <xref ref-type="bibr" rid="ref3">3</xref>
                </sup> In addition, GIS allows the generation of reports automatically with relevant information, informing in a summarized and graphical way the current situation of the organization, obtaining a decision source that allows implementing strategies to lead the market.
                <sup>
                    <xref ref-type="bibr" rid="ref7">7</xref>
                </sup>
            </p>
            <p>The implementation of a management information system is an important tool in the business world, and it has a positive impact on information analysis and decision making.
                <sup>
                    <xref ref-type="bibr" rid="ref8">8</xref>
                </sup> However, there is a sector that still does not use this tool due to lack of knowledge about how to develop them and how to take advantage of their benefits, either at the enterprise level or in the cloud.
                <sup>
                    <xref ref-type="bibr" rid="ref9">9</xref>
                </sup> It is likely that research is needed to explore the impact of this tool on administrative management and decision-making at the level of micro and small businesses, focusing on rural and municipal savings banks.
                <sup>
                    <xref ref-type="bibr" rid="ref10">10</xref>
                </sup>
            </p>
            <p>This research aims to explore and publicize the impact of implementing a management information system as a strategic tool to improve administrative management and enhance decision making in MYPES
                <sup>
                    <xref ref-type="bibr" rid="ref11">11</xref>
                </sup>; quickly and efficiently managing the large volume of information generated by companies, reducing time when providing relevant and reliable information to make decisions, leading to multiple analyzes and reports with the information obtained, even reducing costs in labor or paperwork.
                <sup>
                    <xref ref-type="bibr" rid="ref12">12</xref>
                </sup> Therefore, the objective of this research is to implement a management information system to improve administrative management in a rural bank, such is the case of the savings and credit company &#x201c;Los Andes SAC&#x201d; based in Lima.</p>
            <p>The contribution of this research when implementing a management information system is to improve administrative management, minimizing errors due to manual work, automating the registration of information, reducing time when generating reports and analyzing accurate information for decision making.
                <sup>
                    <xref ref-type="bibr" rid="ref13">13</xref>
                </sup> In addition, it contributes to innovation since it plays a key role when introducing and promoting new technologies, allowing resources to be used efficiently.
                <sup>
                    <xref ref-type="bibr" rid="ref14">14</xref>
                </sup>
            </p>
            <p>If we relate other research with the same topic that we are presenting, with the purpose of analyzing and comparing; We find the following study
                <sup>
                    <xref ref-type="bibr" rid="ref15">15</xref>
                </sup> where it determines that the Jard&#x00ed;n Azuayo Savings and Credit Cooperative lacks relevant information for making business decisions, which is why it proposes the development of a management information system based on the definition of key performance indicators, with the It makes up for the absence of information and helps generate knowledge. On the other hand, we have another investigation
                <sup>
                    <xref ref-type="bibr" rid="ref16">16</xref>
                </sup> that seeks to solve the lack of truthful and quality information in the Portoviejo savings and credit cooperative, specifying that this is the indispensable basis in decision-making when granting loans, for This proposes the development of a web data management system that guarantees the integrity, accuracy and relevance of the information. Finally, in this research
                <sup>
                    <xref ref-type="bibr" rid="ref17">17</xref>
                </sup> they seek to solve the lack of control in administrative management in the Savings and Credit Cooperative &#x201c;Por el Pan y el Agua&#x201d; through the implementation of a web application for the internal management of the cooperative, this application manages to control the administration, organization and availability of information efficiently and effectively.</p>
        </sec>
        <sec id="sec6" sec-type="methods">
            <title>2. Methods</title>
            <p>In this section, we detail the methods used in the development and operation of our software; which has been designed to enhance decision-making in micro and small businesses.</p>
            <sec id="sec7">
                <title>2.1 Implementation</title>
                <p>Basic programming language in ASP was used .NET for source code development and Microsoft SQL Server 2019 and its extensions: Management Studio for data processing, Integration Services for migration to the new dimensional model, Reporting Services for reports and Looker Studio for dashboards.</p>
            </sec>
            <sec id="sec8">
                <title>2.2 Operation</title>
                <p>We worked with the agile SCRUM methodology, following the 5 phases into which this methodology is divided.
                    <sup>
                        <xref ref-type="bibr" rid="ref18">18</xref>
                    </sup>
                </p>
                <p>
                    <bold>2.2.1 Home</bold>
                </p>
                <p>In this phase, the vision statement of the system was made, explaining the need of the company and the objective of the project. Also, the charter was drawn up, which contains a statement of the objectives and expected results. Additionally, the collaboration plan and roles were drafted, detailing the people participating in the research; The epics, the description of the users involved, the risks and completion criteria were written (
                    <xref ref-type="fig" rid="f1">Figure 1</xref>).</p>
                <fig fig-type="figure" id="f1" orientation="portrait" position="float">
                    <label>Figure 1. </label>
                    <caption>
                        <title>The scrum team that developed the sprints, the SCRUM Master has the responsibility of managing the development of the methodology and helping to eliminate impediments that may affect the delivery of the product, the Product Owner is in charge of ensuring that the final deliverable (prepared by the entire team) has the greatest possible value for the customer and the market, while the SCRUM Team develops and shares the details of the final product.</title>
                    </caption>
                    <graphic id="gr1" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure1.gif"/>
                </fig>
                <p>
                    <bold>2.2.2 Planning and estimation</bold>
                </p>
                <p>In this phase, the user stories, lists of requirements (Product Backlog), the stacks of the 4 sprints were created where the requirements that the team will develop and the project planning were recorded (
                    <xref ref-type="fig" rid="f2">Figure 2</xref>).</p>
                <fig fig-type="figure" id="f2" orientation="portrait" position="float">
                    <label>Figure 2. </label>
                    <caption>
                        <title>In the planning stage we start from an adequate definition of the functional requirement.</title>
                        <p>This is the stage in which we translate the core of the business and transfer it to the system so that they respond according to the needs of the organization. If something is not well defined, we could be developing something that is not needed and that will not be used, which is why it is important going through several reviews, prototyping and requesting all conformities from the areas involved.</p>
                    </caption>
                    <graphic id="gr2" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure2.gif"/>
                </fig>
                <p>
                    <bold>2.2.3 Sprint implementation</bold>
                </p>
                <p>In this phase, the initiation minutes for each phase, pending list and sprint planning, database design, dashboard design, prototype implementation and obtaining the final dashboard were developed.</p>
                <p>In the case of the database, a star-type dimensional model has been chosen where gt_saldos represents the fact or Fact table (A) and the tables with initials &#x201c;ge_&#x201d; (B) represent the dimensions (
                    <xref ref-type="fig" rid="f3">Figure 3A</xref>).</p>
                <fig fig-type="figure" id="f3" orientation="portrait" position="float">
                    <label>Figure 3. </label>
                    <caption>
                        <title>This is the relational model of the database created, the dimensions begin with the prefix &#x201c;ge_&#x201d; and have an &#x201c;id&#x201d; that has the same name as the table, but in singular, to be able to recognize it quickly, this ID is the one that will be linked to the main table &#x201c;gt_&#x201d; and will generate a unique composite key when joined with all the other dimensions, making each record in the main table unique.</title>
                        <p>We identify which is the main table &#x201c;A&#x201d; and highlight 3 of the main dimensions as an example &#x201c;B&#x201d;.</p>
                    </caption>
                    <graphic id="gr3" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure3.gif"/>
                </fig>
                <p>
                    <bold>2.2.4 Review and retrospective</bold>
                </p>
                <p>burndown chart was made for each sprint (
                    <xref ref-type="fig" rid="f4">Figure 4</xref>).</p>
                <fig fig-type="figure" id="f4" orientation="portrait" position="float">
                    <label>Figure 4. </label>
                    <caption>
                        <title>The SCRUM methodology is based on continuous improvement, the retrospective stage allows the SCRUM team to learn from previous sprints, share experiences according to roles and also leave &#x201c;technical debts&#x201d; in writing to serve as a basis for subsequent developments.</title>
                    </caption>
                    <graphic id="gr4" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure4.gif"/>
                </fig>
                <p>
                    <bold>2.2.5 Launch</bold>
                </p>
                <p>In this phase, the deliverables and closing minutes of each phase were sent (
                    <xref ref-type="fig" rid="f5">Figure 5</xref>).</p>
                <fig fig-type="figure" id="f5" orientation="portrait" position="float">
                    <label>Figure 5. </label>
                    <caption>
                        <title> The development cycle of the SCRUM methodology, on the left we can see the 5 phases, the last four will be repeated according to the number of sprints defined in Sprint 0, it is important to highlight that each Sprint begins with the functional requirement well defined, if there are changes this will imply a restructuring in the current and subsequent sprints.</title>
                    </caption>
                    <graphic id="gr5" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure5.gif"/>
                </fig>
            </sec>
            <sec id="sec9">
                <title>2.3 Unique features</title>
                <p>This computer tool has characteristics that differentiate it from existing solutions:
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Focused on the microfinance system: our software is designed specifically for micro and small companies in the financial sector, adapting to specific requirements to improve decision making in administrative management, adapting to their workflows.</p>
                        </list-item>
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Tailored customization: users can easily customize the reports they really need to access, allowing queries, filters at the row and column level, showing detailed information to obtain reports adapted to the needs of companies, which makes it in a versatile solution.</p>
                        </list-item>
                    </list>
                </p>
                <p>By explaining the method and unique features, we provide a clear model for the development and implementation of our IT tool in microfinance institutions, promoting its replicability and usefulness.</p>
            </sec>
        </sec>
        <sec id="sec10">
            <title>3. Use cases</title>
            <p>In this section, we present the results of the learning outcome scores, the understanding aspect, and the user experience aspect.</p>
            <sec id="sec11">
                <title>3.1 Use case 1: General Management option interface</title>
                <p>
                    <xref ref-type="fig" rid="f6">Figure 6</xref> shows the main menu interface that was built in Looker Studio, which is a tool that turns your data into clear reports and dashboards.
                    <sup>
                        <xref ref-type="bibr" rid="ref19">19</xref>
                    </sup> In this interface you can view the portfolio stock on the day of consultation and the variations in placements (credits) and deposits (savings). Additionally, a line graph is included that represents the trend of these indicators in the last twelve months. The general menu always remains visible showing the divisions that make up the company and in each division the relevant reports for each of them have been grouped; It is worth mentioning that this dashboard may vary in content and design according to the requirements of each division.</p>
                <fig fig-type="figure" id="f6" orientation="portrait" position="float">
                    <label>Figure 6. </label>
                    <caption>
                        <title>The prototype of one of the Dashboards that will be built in Looker Studio, which seeks to summarize the large amount of commercial information processed into some key indicators for decision making.</title>
                        <p>The important thing was not only to define the key indicators, but also to show their movement over time to help predict behavior patterns. The prototype shows the Dashboard embedded within the main GIS form, specifically in the &#x201c;General Management&#x201d; section.</p>
                    </caption>
                    <graphic id="gr6" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure6.gif"/>
                </fig>
                <p>
                    <bold>3.1.1 Input</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Access to the &#x201c;Dashboard&#x201d; view</p>
                        </list-item>
                    </list>
                </p>
                <p>
                    <bold>3.1.2 Output</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Static report &#x201c;Management Summary&#x201d;</p>
                        </list-item>
                    </list>
                </p>
            </sec>
            <sec id="sec14">
                <title>3.2 Use case 2: Daily Portfolio report interface of the Business Management option</title>
                <p>
                    <xref ref-type="fig" rid="f7">Figure 7</xref> shows one of the most consulted reports of the daily portfolio, located within the Business Management division, in which we can see the details of the placements by region, and with the drill down, by office and by advisor; The drill down also works for the columns, in a first view we see the stock and if we activate the option (+) we can see the variations. The report allows queries of previous dates and filters by placement channel or sales force, maintaining the structure of the report after applying the filters. Additionally, the company&#x2019;s Business Management division has other reporting options such as zero disbursements, amortizations, monthly evolution, productivity and harvests.</p>
                <fig fig-type="figure" id="f7" orientation="portrait" position="float">
                    <label>Figure 7. </label>
                    <caption>
                        <title>One of the main Business Management reports &#x201c;Daily Wallet&#x201d; that has been built in Reporting Services, this report is characterized not by the evolution of the indicators (unlike the Dashboard) but by the progress at a specific moment, allowing make comparisons between work teams to show who is having a better result.</title>
                        <p>The image represents what the report should look like already integrated into the system.</p>
                    </caption>
                    <graphic id="gr7" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure7.gif"/>
                </fig>
                <p>
                    <bold>3.2.1 Input</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Access the &#x201c;Business Management&#x201d; section</p>
                        </list-item>
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Select &#x201c;Daily Portfolio&#x201d;</p>
                        </list-item>
                    </list>
                </p>
                <p>
                    <bold>3.2.2 Output</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Daily portfolio report with the main commercial indicators at the end of the day</p>
                        </list-item>
                    </list>
                </p>
            </sec>
            <sec id="sec17">
                <title>3.3 Use case 3: Monthly evolutionary report interface of the Business Management option</title>
                <p>
                    <xref ref-type="fig" rid="f8">Figure 8</xref> shows the structure of the monthly evolutionary report, which is within the Business Management division. In this report we are going to visualize the same commercial variables of the Daily Portfolio report, with the difference that is shown graphically and in an initial period of 6 months; The report allows you to change the start and end date to compare more months, in addition to filtering by region, office, advisor, channel, establishment or product.</p>
                <fig fig-type="figure" id="f8" orientation="portrait" position="float">
                    <label>Figure 8. </label>
                    <caption>
                        <title>A report built in Reporting Services, but this time it shows graphs and not tables, although the presentation is not very close to Looker Studio, Reporting Services was chosen since the latter allows working with filters linked to the database which facilitates the work of the analytical team that consumes this information to make appropriate and high-impact decisions on the business.</title>
                    </caption>
                    <graphic id="gr8" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure8.gif"/>
                </fig>
                <p>
                    <bold>3.3.1 Input</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Access the &#x201c;Business Management&#x201d; section</p>
                        </list-item>
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Select &#x201c;Monthly Evolutionary&#x201d;</p>
                        </list-item>
                    </list>
                </p>
                <p>
                    <bold>3.3.2 Output</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Evolutionary report with the main commercial indicators according to the filters applied</p>
                        </list-item>
                    </list>
                </p>
            </sec>
            <sec id="sec20">
                <title>3.4 Use case 4: Export options</title>
                <p>
                    <xref ref-type="fig" rid="f9">Figure 9</xref> shows the options available to export information from both a graph and a report. Options are XML, CSV (comma delimited), PDF, MHTML (web file), Excel, TIFF File, and Word; The described options are enabled for all main menu options, plus this functionality keeps the grouping components in the target format.</p>
                <fig fig-type="figure" id="f9" orientation="portrait" position="float">
                    <label>Figure 9. </label>
                    <caption>
                        <title>The export panel that we work with within Reporting Services, this helps make the analysis not only visual but also allows it to be taken to a spreadsheet and cross-reference the information with some additional basis that enriches the analysis.</title>
                    </caption>
                    <graphic id="gr9" orientation="portrait" position="float" xlink:href="https://f1000research-files.f1000.com/manuscripts/158252/b9e524e4-3a77-48c6-949c-fc34f7d6f66a_figure9.gif"/>
                </fig>
                <p>
                    <bold>3.4.1 Input</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Access the export section in any of the reports</p>
                        </list-item>
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Select &#x201c;Excel&#x201d;</p>
                        </list-item>
                    </list>
                </p>
                <p>
                    <bold>3.4.2 Output</bold>
                </p>
                <p>
                    <list list-type="bullet">
                        <list-item>
                            <label>&#x2022;</label>
                            <p>Excel file with the information structured according to the last view of the report</p>
                        </list-item>
                    </list>
                </p>
            </sec>
        </sec>
        <sec id="sec23" sec-type="discussion">
            <title>4. Discussion</title>
            <p>
                <xref ref-type="fig" rid="f6">Figure 6</xref> determines how we can optimize times by obtaining relevant information for the company without the need to perform specific searches, this is because the dashboards built in looker studio have the particular characteristic of obtaining information from the data and centralizing the indicators to know the situation at the beginning of the day. This agrees with what he indicates
                <sup>
                    <xref ref-type="bibr" rid="ref20">20</xref>
                </sup> in his research, where he explains the importance of implementing a dashboard in companies to identify key indicators, risk factors and make strategic decisions in order to obtain optimal results that guarantee the competitiveness of the company. Which is reflected in the 78.1% reduction in time in analysis and generation of reports. It also agrees with
                <sup>
                    <xref ref-type="bibr" rid="ref7">7</xref>
                </sup> where it is mentioned that dashboards are tools that allow you to view relevant information, have a clear perspective of the current situation of an organization, facilitating decision making. Finally, this also agrees with
                <sup>
                    <xref ref-type="bibr" rid="ref21">21</xref>
                </sup> where it indicates that dashboards are a powerful tool for managing information, allowing you to know the current situation of companies and allowing reports to be more efficient, placing the institution in a better position compared to its competitors. generating competitive advantages.
                <sup>
                    <xref ref-type="bibr" rid="ref22">22</xref>
                </sup>
            </p>
            <p>In 
                <xref ref-type="fig" rid="f7">Figure 7</xref>, through reporting services, the ability of the system to be able to make homogeneous comparisons by level is demonstrated, which makes it possible to determine deviations in regions, offices and/or advisors at the date of consultation and carry out corrective actions that help maximize results before the end of the month, information which was previously processed manually, taking longer to generate data and with a greater probability of error; This agrees with
                <sup>
                    <xref ref-type="bibr" rid="ref23">23</xref>
                </sup> those who analyze how information technologies can be associated with production processes to improve labor productivity, becoming a transformative element. In the same way
                <sup>
                    <xref ref-type="bibr" rid="ref24">24</xref>
                </sup> specify how administrative management processes are improved through the implementation of a web system, which contributed to the increase in sales and the reduction of time in the rental and reservation processes, streamlining the analysis of useful information for the decision making. Finally,
                <sup>
                    <xref ref-type="bibr" rid="ref25">25</xref>
                </sup> they also make reference to the improvement of processes in their research by demonstrating that the non-use of information technologies limits the process of generating and disseminating information in SMEs and directly affects its quality.</p>
            <p>In 
                <xref ref-type="fig" rid="f8">Figure 8</xref>, we determine how short, medium and long-term strategies can be structured with the help of an evolutionary report. This vision, accompanied by the seasonal behavior of the financial system, provides management with the ability to make effective decisions and to know in What time to launch aggressive or conservative campaigns to control results and achievement of objectives.
                <sup>
                    <xref ref-type="bibr" rid="ref26">26</xref>
                </sup> This is supported by the study of Ref. 
                <xref ref-type="bibr" rid="ref27">27</xref> those who demonstrated the lack of management information systems that support decision-making in companies in the sector due to the lack of management indicators. Likewise, Ref. 
                <xref ref-type="bibr" rid="ref25">25</xref> in their research they analyze how SMEs can improve their competitiveness through improvements in decision-making by including information technologies in their internal processes. Finally, Ref. 
                <xref ref-type="bibr" rid="ref28">28</xref> their study shows how to define information quality criteria and the appropriate use of data in SMEs to clarify information management in decision-making to support business activities.</p>
            <p>In 
                <xref ref-type="fig" rid="f9">Figure 9</xref>, the versatility of the system is determined to avoid dependence on connectivity to analyze the indicators, exporting any of the reports according to the need of the moment, we can access this information offline from any device and have the staff Dedicate yourself to the core of the business in the field without having to invest time in operational tasks in the office. As demonstrated in the study Ref. 
                <xref ref-type="bibr" rid="ref27">27</xref> where they show the need to carry out their research to develop a comprehensive proposal for linking GIS and management of indicators that supports decision making in a rural area of Ecuador. This also agrees with the statement made
                <sup>
                    <xref ref-type="bibr" rid="ref23">23</xref>
                </sup> when specifying that emerging companies suffer from problems of access and generation of information since, due to their structure, they treat information in a basic way. Finally, Ref. 
                <xref ref-type="bibr" rid="ref28">28</xref> they analyze how small and medium-sized companies often do not give due importance to data analysis and the negative impact that this practice has on the development of their activities.</p>
        </sec>
        <sec id="sec24" sec-type="conclusions">
            <title>5. Conclusions</title>
            <p>It is concluded that the implementation of a management information system to improve administrative management turned out to be a beneficial contribution in the treatment and analysis of information globally, which allowed the time dedicated to generating reports to be reduced by 21.2% in addition to reducing the error rate in manual records by 100%. This time savings provided the opportunity to improve business indicators through reports for decision making.</p>
            <p>The first improvement is associated with the reduction of time invested in generating reports, which allowed more space for adequate analysis of the information, in addition to reducing the high probability of error due to manual data recording; it also allowed the self-generation of reports and visualization on a dashboard that allows identifying opportunities for improvement in administrative and commercial management in a more efficient and orderly way, making each member of the organization focus on their area.</p>
            <p>Finally, the system has an additional advantage and that is that it handles the information securely, only controlling access to members of the organization and in accordance with the permissions that have been assigned to each user, ensuring that sensitive information is not filter through other channels.</p>
            <p>The preparation and continuous training of the organization&#x2019;s personnel is recommended for the correct use of the Management Information system. It is suggested to prepare an improvement plan to strengthen the system, or a maintenance plan in case an update to the reports is necessary. In addition, it is suggested to prepare a contingency plan for possible errors during the execution of the system.</p>
        </sec>
    </body>
    <back>
        <sec id="sec28" sec-type="data-availability">
            <title>Data availability</title>
            <p>Zenodo: DataDashboard, 
                <ext-link ext-link-type="uri" xlink:href="https://doi.org/10.5281/zenodo.10614354">https://doi.org/10.5281/zenodo.10614354</ext-link>.
                <sup>

                    <xref ref-type="bibr" rid="ref29">29</xref>
</sup>
            </p>
            <p>Data are available under the terms of the 
                <ext-link ext-link-type="uri" xlink:href="https://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0 International license</ext-link> (CC-BY 4.0).</p>
        </sec>
        <sec id="sec25">
            <title>Software availability</title>
            <p>Source code available from: 
                <ext-link ext-link-type="uri" xlink:href="https://github.com/eddie66618/sig.git">https://github.com/eddie66618/sig.git</ext-link> (Software).</p>
            <p>Archived source code at time of publication: 
                <ext-link ext-link-type="uri" xlink:href="https://doi.org/10.5281/zenodo.10614376">https://doi.org/10.5281/zenodo.10614376</ext-link>.
                <sup>

                    <xref ref-type="bibr" rid="ref30">30</xref>
</sup>
            </p>
            <p>License: 
                <ext-link ext-link-type="uri" xlink:href="https://www.gnu.org/licenses/gpl-3.0.en.html">GPL 3.0</ext-link>.</p>
        </sec>
        <ack>
            <title>Acknowledgments</title>
            <p>We thank Caja Los Andes for its strong support with this study and engineer Alex Pacheco from the Faculty of Engineering and Architecture of the Cesar Vallejo University for his methodological advice in this research.</p>
        </ack>
        <ref-list>
            <title>References</title>
            <ref id="ref1">
                <label>1</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Sutherland</surname>
                            <given-names>J</given-names>
                        </name>
</person-group>:
                    <article-title>More Praise for Scrum: The Art of Doing Twice the Work in Half the Time.</article-title>
                    <year>2014</year>; vol.<volume>3</volume>.</mixed-citation>
            </ref>
            <ref id="ref2">
                <label>2</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Fern&#x00e1;ndez Torres</surname>
                            <given-names>A</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Gonz&#x00e1;les Valero</surname>
                            <given-names>M</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Esparza Cruz</surname>
                            <given-names>N</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Estructura de los procesos de software en los sistemas de informaci&#x00f3;n gerencial que se aplica en la parte agr&#x00ed;cola.</article-title>
                    <source>

                        <italic toggle="yes">J. Sci. Res.</italic>
</source>
                    <year>Dec. 2020</year>;<volume>5</volume>(<issue>CININGEC</issue>):<fpage>800</fpage>&#x2013;<lpage>807</lpage>.
                    <pub-id pub-id-type="doi">10.5281/zenodo.4450883</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref3">
                <label>3</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Alvarado</surname>
                            <given-names>R</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Acosta</surname>
                            <given-names>K</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Mata de Buonaffina</surname>
                            <given-names>YV</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Necesidad de los sistemas de informaci&#x00f3;n gerencial para la toma de decisiones en las organizaciones.</article-title>
                    <source>

                        <italic toggle="yes">InterSedes.</italic>
</source>
                    <year>Jul. 2018</year>;<volume>19</volume>(<issue>39</issue>):<fpage>17</fpage>&#x2013;<lpage>31</lpage>.
                    <pub-id pub-id-type="doi">10.15517/isucr.v19i39.34067</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref4">
                <label>4</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Sociedad</surname>
                            <given-names>UY</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Katiuska</surname>
                            <given-names>G</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Guzm&#x00e1;n</surname>
                            <given-names>V</given-names>
                        </name>
</person-group>:
                    <article-title>Sistema de informaci&#x00f3;n gerencial para el control de costos de empresas agroindustriales del Cant&#x00f3;n Daule.</article-title>
                    <source>

                        <italic toggle="yes">Revista Universidad y Sociedad.</italic>
</source>
                    <year>2021</year>;<volume>13</volume>(<issue>5</issue>):<fpage>605</fpage>&#x2013;<lpage>614</lpage>. Accessed: Oct. 05, 2023.</mixed-citation>
            </ref>
            <ref id="ref5">
                <label>5</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Vargas Encalada</surname>
                            <given-names>EE</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Rengifo Lozano</surname>
                            <given-names>RA</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Guizado Oscco</surname>
                            <given-names>F</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Sistemas de informaci&#x00f3;n como herramienta para reorganizar procesos de manufactura.</article-title>
                    <source>

                        <italic toggle="yes">Revista Venezolana de Gerencia.</italic>
</source>
                    <year>2019</year>. Accessed: Oct. 11, 2023.</mixed-citation>
            </ref>
            <ref id="ref6">
                <label>6</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Bravo Cobe&#x00f1;a</surname>
                            <given-names>CM</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Valdivieso Guerra</surname>
                            <given-names>P</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Arregui Pozo</surname>
                            <given-names>R</given-names>
                        </name>
</person-group>:
                    <article-title>Los sistemas de informaci&#x00f3;n en la toma de decisiones gerenciales en las empresas comerciales de Portoviejo.</article-title>
                    <source>

                        <italic toggle="yes">ECA Sinergia.</italic>
</source>
                    <year>2018</year>; vol.<volume>9</volume>(<issue>2</issue>): pp.<fpage>45</fpage>&#x2013;<lpage>54</lpage>. ISSN 1390-6623, ISSN-e 2528-7869, Vol. 9, N
                    <sup>o</sup>. 2 (Julio - Diciembre), 2018, p&#x00e1;gs. 45-54. Accessed: Oct. 11, 2023.</mixed-citation>
            </ref>
            <ref id="ref7">
                <label>7</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Angel</surname>
                            <given-names>F</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Lois</surname>
                            <given-names>B</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Del R&#x00ed;o</surname>
                            <given-names>CA</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Lecciones aprendidas de la implementaci&#x00f3;n de un Sistema de Informaci&#x00f3;n Gerencial dise&#x00f1;ado en la Universidad de Otavalo, Ecuador.</article-title>
                    <source>

                        <italic toggle="yes">E-Ciencias de la Informaci&#x00f3;n.</italic>
</source>
                    <year>Jan. 2021</year>;<volume>11</volume>(<issue>1</issue>):<fpage>90</fpage>&#x2013;<lpage>92</lpage>.
                    <pub-id pub-id-type="doi">10.15517/ECI.V11I1.41501</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref8">
                <label>8</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Litvaj</surname>
                            <given-names>I</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Stancekova</surname>
                            <given-names>D</given-names>
                        </name>
</person-group>:
                    <article-title>Knowledge Management Embedment in Company, Knowledge Repositories, Knowledge Management Significance and Usage in Company.</article-title>
                    <source>

                        <italic toggle="yes">Procedia Economics and Finance.</italic>
</source>
                    <year>2015</year>;<volume>23</volume>:<fpage>833</fpage>&#x2013;<lpage>838</lpage>.
                    <pub-id pub-id-type="doi">10.1016/S2212-5671(15)00549-3</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref9">
                <label>9</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Mac&#x00ed;as Arteaga</surname>
                            <given-names>MF</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Mero Velez</surname>
                            <given-names>JM</given-names>
                        </name>
</person-group>:
                    <article-title>Importancia de Planeaci&#x00f3;n Estrat&#x00e9;gica en Empresas en el Siglo XXI.</article-title>
                    <year>2022</year>.
                    <pub-id pub-id-type="doi">10.23857/pc.v7i2.3567</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref10">
                <label>10</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Begazo Villanueva</surname>
                            <given-names>JD</given-names>
                        </name>
</person-group>:
                    <article-title>La toma de decisiones y la gesti&#x00f3;n por objetivos en la empresa peruana.</article-title>
                    <source>

                        <italic toggle="yes">Gesti&#x00f3;n en el Tercer Milenio.</italic>
</source>
                    <year>Dec. 2014</year>;<volume>17</volume>(<issue>34</issue>):<fpage>21</fpage>&#x2013;<lpage>27</lpage>.
                    <pub-id pub-id-type="doi">10.15381/gtm.v17i34.11690</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref11">
                <label>11</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Huacchillo</surname>
                            <given-names>LA</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Ramos Farro&#x00f1;an</surname>
                            <given-names>EV</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Pulache Lozada</surname>
                            <given-names>JL</given-names>
                        </name>
</person-group>:
                    <article-title>La gesti&#x00f3;n financiera y su incidencia en la toma de decisiones financieras.</article-title>
                    <source>

                        <italic toggle="yes">Revista Universidad y Sociedad.</italic>
</source>
                    <year>2020</year>;<volume>12</volume>(<issue>2</issue>):<fpage>356</fpage>&#x2013;<lpage>362</lpage>. Accessed: Sep. 08, 2023.</mixed-citation>
            </ref>
            <ref id="ref12">
                <label>12</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Puello</surname>
                            <given-names>P</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Cabarcas</surname>
                            <given-names>A</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Martelo</surname>
                            <given-names>RJ</given-names>
                        </name>
</person-group>:
                    <article-title>SISTEMA DE INFORMACI&#x00d3;N GERENCIAL PARA LA ADMINISTRACI&#x00d3;N DE RECURSOS EDUCATIVOS.</article-title>
                    <source>

                        <italic toggle="yes">Formaci&#x00f3;n Universitaria.</italic>
</source>
                    <year>2013</year>;<volume>6</volume>(<issue>5</issue>):<fpage>13</fpage>&#x2013;<lpage>20</lpage>.
                    <pub-id pub-id-type="doi">10.4067/S0718-50062013000500003</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref13">
                <label>13</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Reason</surname>
                            <given-names>J</given-names>
                        </name>
</person-group>:
                    <article-title>Human error: models and management.</article-title>
                    <source>

                        <italic toggle="yes">BMJ.</italic>
</source>
                    <year>Mar. 2000</year>;<volume>320</volume>(<issue>7237</issue>):<fpage>768</fpage>&#x2013;<lpage>770</lpage>.
                    <pub-id pub-id-type="pmid">10720363</pub-id>
                    <pub-id pub-id-type="doi">10.1136/BMJ.320.7237.768</pub-id>
                    <pub-id pub-id-type="pmcid">PMC1117770</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref14">
                <label>14</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Arregoc&#x00e9;s</surname>
                            <given-names>I</given-names>
                        </name>

                        <name name-style="western">
                            <surname>De La Costa</surname>
                            <given-names>U</given-names>
                        </name>

                        <name name-style="western">
                            <surname>D&#x00ed;az Hern&#x00e1;ndez</surname>
                            <given-names>J</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Integraci&#x00f3;n de Scrum y RUP para el desarrollo de software de planes tur&#x00ed;sticos basado en preferencias de usuario.</article-title>
                    <source>

                        <italic toggle="yes">Ingenier&#x00ed;a e Innovaci&#x00f3;n.</italic>
</source>
                    <year>Jul. 2022</year>;<volume>10</volume>(<issue>1</issue>).
                    <pub-id pub-id-type="doi">10.21897/RII.2974</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref15">
                <label>15</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>G&#x00f3;mez Espinoza</surname>
                            <given-names>HO</given-names>
                        </name>
</person-group>:
                    <article-title>Metodolog&#x00ed;a para la implementaci&#x00f3;n de un sistema de informaci&#x00f3;n gerencial para el gestor transaccional inclusivo de la Cooperativa de Ahorro y Cr&#x00e9;dito Jard&#x00ed;n Azuayo.</article-title>
                    <source>

                        <italic toggle="yes">Polo del Conocimiento: Revista cient&#x00ed;fico - profesional.</italic>
</source>
                    <year>2022</year>;<volume>7</volume>(<issue>4</issue>):<fpage>56</fpage>. ISSN-e 2550-682X, Vol. 7, N
                    <sup>o</sup>. 4 (ABRIL 2022), 2022.
                    <pub-id pub-id-type="doi">10.23857/pc.v7i4.3919</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref16">
                <label>16</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Delvalle Mor&#x00e1;n</surname>
                            <given-names>FJ</given-names>
                        </name>
</person-group>:
                    <article-title>An&#x00e1;lisis del Sistema de Informaci&#x00f3;n en la toma de decisiones del sector crediticio de cooperativas de ahorro y cr&#x00e9;dito de la ciudad de Portoviejo.</article-title>
                    <source>

                        <italic toggle="yes">DSpace Repository.</italic>
</source>
                    <year>2020</year>. Accessed: Oct. 11, 2023.</mixed-citation>
            </ref>
            <ref id="ref17">
                <label>17</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Baque Garc&#x00ed;a</surname>
                            <given-names>YM</given-names>
                        </name>
</person-group>:
                    <article-title>Implementaci&#x00f3;n de un aplicativo web para la gesti&#x00f3;n interna de la cooperativa de ahorro y cr&#x00e9;dito &#x2018;por el pan y el agua,&#x2019;.</article-title>
                    <year>Jan. 2023</year>. Accessed: Oct. 11, 2023.</mixed-citation>
            </ref>
            <ref id="ref18">
                <label>18</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Timkyw</surname>
                            <given-names>N</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Bournissen</surname>
                            <given-names>JM</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Tumino</surname>
                            <given-names>MC</given-names>
                        </name>
</person-group>:
                    <article-title>Scrum como Herramienta Metodol&#x00f3;gica para el Aprendizaje de la Programaci&#x00f3;n.</article-title>
                    <source>

                        <italic toggle="yes">Revista Iberoamericana de Tecnolog&#x00ed;a en Educaci&#x00f3;n y Educaci&#x00f3;n en Tecnolog&#x00ed;a.</italic>
</source>
                    <year>Oct. 2020</year>; (<issue>26</issue>):<fpage>e9</fpage>.
                    <pub-id pub-id-type="doi">10.24215/18509959.26.E9</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref19">
                <label>19</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Moraes</surname>
                            <given-names>GG</given-names>
                        </name>
</person-group>:
                    <article-title>Google looker studio: a experi&#x00ea;ncia de implementa&#x00e7;&#x00e3;o em uma empresa de compliance.</article-title>
                    <year>2023</year>. Accessed: Oct. 13, 2023.</mixed-citation>
            </ref>
            <ref id="ref20">
                <label>20</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Calle Paz</surname>
                            <given-names>II</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Valles Coral</surname>
                            <given-names>MA</given-names>
                        </name>
</person-group>:
                    <article-title>Dashboard digital para el monitoreo de indicadores y metas de los proyectos de consultores San Mart&#x00ed;n E.I.R.L.</article-title>
                    <source>

                        <italic toggle="yes">Revista Cient&#x00ed;fica de Sistemas e Inform&#x00e1;tica.</italic>
</source>
                    <year>Jan. 2021</year>;<volume>1</volume>(<issue>1</issue>):<fpage>24</fpage>&#x2013;<lpage>36</lpage>.
                    <pub-id pub-id-type="doi">10.51252/RCSI.V1I1.94</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref21">
                <label>21</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Gonz&#x00e1;lez</surname>
                            <given-names>J</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Salazar</surname>
                            <given-names>F</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Ortiz</surname>
                            <given-names>R</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Gerencia estrat&#x00e9;gica: herramienta para la toma de decisiones en las organizaciones.</article-title>
                    <source>

                        <italic toggle="yes">Telos: Revista de Estudios Interdisciplinarios en Ciencias Sociales.</italic>
</source>
                    <year>Jan. 2019</year>;<volume>21</volume>(<issue>1</issue>):<fpage>242</fpage>&#x2013;<lpage>267</lpage>.
                    <pub-id pub-id-type="doi">10.36390/TELOS211.12</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref22">
                <label>22</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Sizwe</surname>
                            <given-names>N</given-names>
                        </name>
</person-group>:
                    <article-title>Integration of the Management Information System for Competitive Positioning.</article-title>
                    <source>

                        <italic toggle="yes">Procedia Manuf.</italic>
</source>
                    <year>Jan. 2020</year>;<volume>43</volume>:<fpage>375</fpage>&#x2013;<lpage>382</lpage>.
                    <pub-id pub-id-type="doi">10.1016/J.PROMFG.2020.02.176</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref23">
                <label>23</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>D&#x00ed;az Rodr&#x00ed;guez</surname>
                            <given-names>HE</given-names>
                        </name>
</person-group>:
                    <article-title>Tecnolog&#x00ed;as de la informaci&#x00f3;n y comunicaci&#x00f3;n y crecimiento econ&#x00f3;mico.</article-title>
                    <source>

                        <italic toggle="yes">Eco. Inform.</italic>
</source>
                    <year>Jul. 2017</year>;<volume>405</volume>:<fpage>30</fpage>&#x2013;<lpage>45</lpage>.
                    <pub-id pub-id-type="doi">10.1016/J.ECIN.2017.07.002</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref24">
                <label>24</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Francia</surname>
                            <given-names>K</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Lopez</surname>
                            <given-names>R</given-names>
                        </name>
</person-group>:
                    <article-title>Desarrollo de un sistema web para la mejora en la gesti&#x00f3;n administrativa del hospedaje Mis Recuerdos de la ciudad de Chiclayo en el a&#x00f1;o 2019.</article-title>
                    <year>2022</year>. Accessed: May 25, 2023.</mixed-citation>
            </ref>
            <ref id="ref25">
                <label>25</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Rend&#x00f3;n Fern&#x00e1;ndez</surname>
                            <given-names>RJ</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Ca&#x00f1;izares Galarza</surname>
                            <given-names>PF</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Romero Fern&#x00e1;ndez</surname>
                            <given-names>A</given-names>
                        </name>
</person-group>:
                    <article-title>Los sistemas de informaci&#x00f3;n gerencial en peque&#x00f1;as y medianas empresas del sector tur&#x00ed;stico de la provincia los R&#x00ed;os, Ecuador.</article-title>
                    <source>

                        <italic toggle="yes">Revista UNIANDES Episteme.</italic>
</source>
                    <year>2019</year>;<volume>6</volume>(<issue>3</issue>):<fpage>369</fpage>&#x2013;<lpage>382</lpage>. ISSN-e 1390-9150, Vol. 6, N
                    <sup>o</sup>. 3, 2019 (Ejemplar dedicado a: julio - septiembre (01/07/2019)), p&#x00e1;gs. 369-382. Accessed: Oct. 05, 2023.</mixed-citation>
            </ref>
            <ref id="ref26">
                <label>26</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Aguilar</surname>
                            <given-names>C</given-names>
                        </name>
</person-group>:
                    <article-title>Calidad de gesti&#x00f3;n administrativa financiera en las municipalidades, 2020.</article-title>
                    <source>

                        <italic toggle="yes">Ciencia Latina Revista Cient&#x00ed;fica Multidisciplinar.</italic>
</source>
                    <year>Nov. 2020</year>;<volume>4</volume>(<issue>2</issue>):<fpage>613</fpage>&#x2013;<lpage>634</lpage>.
                    <pub-id pub-id-type="doi">10.37811/CL_RCM.V4I2.104</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref27">
                <label>27</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Quispe Otacomal</surname>
                            <given-names>AL</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Padilla Mart&#x00ed;nez</surname>
                            <given-names>MP</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Telot Gonz&#x00e1;lez</surname>
                            <given-names>JA</given-names>
                        </name>

                        <etal/>
</person-group>:
                    <article-title>Sistema de informaci&#x00f3;n gerencial para las cajas solidarias de Ecuador.</article-title>
                    <year>2018</year>. Accessed: Oct. 05, 2023.</mixed-citation>
            </ref>
            <ref id="ref28">
                <label>28</label>
                <mixed-citation publication-type="journal">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Villac&#x00ed;s Yank</surname>
                            <given-names>JA</given-names>
                        </name>

                        <name name-style="western">
                            <surname>Moreno Mej&#x00ed;a</surname>
                            <given-names>MA</given-names>
                        </name>
</person-group>:
                    <article-title>Caracterizaci&#x00f3;n de la gesti&#x00f3;n de la informaci&#x00f3;n contable en las Pymes comerciales de Ambato &#x2013; Ecuador.</article-title>
                    <source>

                        <italic toggle="yes">Cuadernos de Contabilidad.</italic>
</source>
                    <year>Aug. 2021</year>;<volume>22</volume>:<fpage>1</fpage>&#x2013;<lpage>13</lpage>.
                    <pub-id pub-id-type="doi">10.11144/JAVERIANA.CC22.CGIC</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref29">
                <label>29</label>
                <mixed-citation publication-type="data">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Asto</surname>
                        </name>

                        <name name-style="western">
                            <surname>Cruz</surname>
                        </name>
</person-group>:
                    <data-title>DataDashboard.</data-title>[Data set].
                    <source>

                        <italic toggle="yes">Zenodo.</italic>
</source>
                    <year>2024</year>.
                    <pub-id pub-id-type="doi">10.5281/zenodo.10614354</pub-id>
                </mixed-citation>
            </ref>
            <ref id="ref30">
                <label>30</label>
                <mixed-citation publication-type="other">
                    <person-group person-group-type="author">

                        <name name-style="western">
                            <surname>Asto</surname>
                        </name>

                        <name name-style="western">
                            <surname>Cruz</surname>
                        </name>
</person-group>:
                    <article-title>C&#x00f3;digo Fuente.</article-title>
                    <source>

                        <italic toggle="yes">Zenodo. [Software].</italic>
</source>
                    <year>2024</year>.
                    <pub-id pub-id-type="doi">10.5281/zenodo.10614376</pub-id>
                </mixed-citation>
            </ref>
        </ref-list>
    </back>
    <sub-article article-type="reviewer-report" id="report334736">
        <front-stub>
            <article-id pub-id-type="doi">10.5256/f1000research.158252.r334736</article-id>
            <title-group>
                <article-title>Reviewer response for version 1</article-title>
            </title-group>
            <contrib-group>
                <contrib contrib-type="author">
                    <name>
                        <surname>Stoica</surname>
                        <given-names>Marian</given-names>
                    </name>
                    <xref ref-type="aff" rid="r334736a1">1</xref>
                    <role>Referee</role>
                    <uri content-type="orcid">https://orcid.org/0000-0003-2852-9224</uri>
                </contrib>
                <aff id="r334736a1">
                    <label>1</label>Academia de Studii Economice Bucure&#x0219;ti, Bucure&#x0219;ti, Romania</aff>
            </contrib-group>
            <author-notes>
                <fn fn-type="conflict">
                    <p>
                        <bold>Competing interests: </bold>No competing interests were disclosed.</p>
                </fn>
            </author-notes>
            <pub-date pub-type="epub">
                <day>6</day>
                <month>11</month>
                <year>2024</year>
            </pub-date>
            <permissions>
                <copyright-statement>Copyright: &#x00a9; 2024 Stoica M</copyright-statement>
                <copyright-year>2024</copyright-year>
                <license xlink:href="https://creativecommons.org/licenses/by/4.0/">
                    <license-p>This is an open access peer review report distributed under the terms of the Creative Commons Attribution Licence, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.</license-p>
                </license>
            </permissions>
            <related-article ext-link-type="doi" id="relatedArticleReport334736" related-article-type="peer-reviewed-article" xlink:href="10.12688/f1000research.144450.1"/>
            <custom-meta-group>
                <custom-meta>
                    <meta-name>recommendation</meta-name>
                    <meta-value>approve-with-reservations</meta-value>
                </custom-meta>
            </custom-meta-group>
        </front-stub>
        <body>
            <p>At the first reading of the article, it proposes a decision-making process automation solution for small and medium-sized businesses. However, during the course of the material, no novel aspects are highlighted in relation to products and software tools of the same type, already existing on the IT market (see ERP type applications). A hybrid methodological approach is emphasized, which calls on the agile SCRUM methodology in connection with established software tools for the development of software applications (.NET, SQL Server).</p>
            <p> Not enough detail is provided on the methodological approach and the business analysis component so that the solution can be extended or replicated by other entities. The generally valid aspects of the SCRUM methodology are highlighted, and these in a minimalist manner.</p>
            <p> Regarding the results provided by the proposed software product, aspects regarding internal software features such as assistability, maintainability, testability or portability are not mentioned.</p>
            <p> Conclusions on the proposed software tool do not cover basic aspects such as reliability and capability.</p>
            <p> The justification and development of all the aspects mentioned above can give the proposed article a much higher practical level. I also recommend that authors include at least one tester in the development team to validate viable and credible testing strategies. At the same time, I recommend the approach and inclusion in the development of the proposed product of the scalability feature.</p>
            <p>Are the conclusions about the tool and its performance adequately supported by the findings presented in the article?</p>
            <p>Partly</p>
            <p>Is the rationale for developing the new software tool clearly explained?</p>
            <p>Yes</p>
            <p>Is the description of the software tool technically sound?</p>
            <p>Yes</p>
            <p>Are sufficient details of the code, methods and analysis (if applicable) provided to allow replication of the software development and its use by others?</p>
            <p>Partly</p>
            <p>Is sufficient information provided to allow interpretation of the expected output datasets and any results generated using the tool?</p>
            <p>Partly</p>
            <p>Reviewer Expertise:</p>
            <p>Management information systems, computer programming, emerging technologies of the information society</p>
            <p>I confirm that I have read this submission and believe that I have an appropriate level of expertise to confirm that it is of an acceptable scientific standard, however I have significant reservations, as outlined above.</p>
        </body>
    </sub-article>
    <sub-article article-type="reviewer-report" id="report290837">
        <front-stub>
            <article-id pub-id-type="doi">10.5256/f1000research.158252.r290837</article-id>
            <title-group>
                <article-title>Reviewer response for version 1</article-title>
            </title-group>
            <contrib-group>
                <contrib contrib-type="author">
                    <name>
                        <surname>Asemi</surname>
                        <given-names>Asefeh</given-names>
                    </name>
                    <xref ref-type="aff" rid="r290837a1">1</xref>
                    <role>Referee</role>
                </contrib>
                <aff id="r290837a1">
                    <label>1</label>Corvinus University of Budapest, Budapest, Hungary</aff>
            </contrib-group>
            <author-notes>
                <fn fn-type="conflict">
                    <p>
                        <bold>Competing interests: </bold>No competing interests were disclosed.</p>
                </fn>
            </author-notes>
            <pub-date pub-type="epub">
                <day>15</day>
                <month>7</month>
                <year>2024</year>
            </pub-date>
            <permissions>
                <copyright-statement>Copyright: &#x00a9; 2024 Asemi A</copyright-statement>
                <copyright-year>2024</copyright-year>
                <license xlink:href="https://creativecommons.org/licenses/by/4.0/">
                    <license-p>This is an open access peer review report distributed under the terms of the Creative Commons Attribution Licence, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.</license-p>
                </license>
            </permissions>
            <related-article ext-link-type="doi" id="relatedArticleReport290837" related-article-type="peer-reviewed-article" xlink:href="10.12688/f1000research.144450.1"/>
            <custom-meta-group>
                <custom-meta>
                    <meta-name>recommendation</meta-name>
                    <meta-value>approve-with-reservations</meta-value>
                </custom-meta>
            </custom-meta-group>
        </front-stub>
        <body>
            <p>The article authored by Martinez, Castro and Pacheco discusses a Management Information System (MIS) designed specifically for micro enterprises, in the industry. It addresses the issue of handling datasets to assist in decision making processes. Constructed using the SCRUM approach this system integrates Visual Basic in ASP.NET, Microsoft SQL Server 2019 and Looker Studio to offer dashboards. Its main objective is to streamline tasks by automating report generation reducing errors and providing real time information that is pertinent. The systems tailored. Offline accessibility benefit field personnel by cutting down time spent on generating reports and enhancing data analysis accuracy. The authors describe the development journey from planning to implementation and evaluation to ensure that the tool can be replicated successfully. They also showcase the systems impact through case studies which reveal a 78.1% decrease in time taken for analysis and report generation. While the article presents a rationale along with technical details and methodology making it scientifically valid the conclusions drawn are supported by the study results. Including information on long term performance outcomes and its applicability, across sectors could further enrich this research.</p>
            <p> </p>
            <p> </p>
            <p> 
                <underline>
                    <bold>Suggestions, for Improvement</bold>
                </underline>
            </p>
            <p> Strengthen the Explanation; Provide a comparison with existing solutions emphasizing gaps that the proposed Management Information System (MIS) addresses.</p>
            <p> Detailed Technical Specifications; Incorporate information, rationale for technology selections and potential challenges encountered during development.</p>
            <p> Replication Guidelines; Integrate code snippets, pseudocode or a repository link to assist researchers in replicating the work.</p>
            <p> Interpretation of Results; Elaborate on the Key Performance Indicators (KPIs) utilized in the dashboards and reports explaining their significance, in decision making processes.</p>
            <p> Quantitative Analysis; Present findings and user feedback to validate the tools efficacy and influence.</p>
            <p>Are the conclusions about the tool and its performance adequately supported by the findings presented in the article?</p>
            <p>Yes</p>
            <p>Is the rationale for developing the new software tool clearly explained?</p>
            <p>Partly</p>
            <p>Is the description of the software tool technically sound?</p>
            <p>Partly</p>
            <p>Are sufficient details of the code, methods and analysis (if applicable) provided to allow replication of the software development and its use by others?</p>
            <p>Partly</p>
            <p>Is sufficient information provided to allow interpretation of the expected output datasets and any results generated using the tool?</p>
            <p>Partly</p>
            <p>Reviewer Expertise:</p>
            <p>Business informatics</p>
            <p>I confirm that I have read this submission and believe that I have an appropriate level of expertise to confirm that it is of an acceptable scientific standard, however I have significant reservations, as outlined above.</p>
        </body>
    </sub-article>
</article>
