Methodology for a Business Intelligence Platform by Using Oracle 19C Database Engine and its Limitations

The use of data warehousing and data processing technology accelerated the generation of reports by 50%. The adoption of a specific value creation model for business intelligence increased operational efficiency in decision making by 25%. A total of 39 articles, found in various academic repositories, were included in the research study. These 39 articles went through a rigorous final selection process using the PRISMA methodology. As a result, a final set of 17 research articles that were considered relevant and pertinent to the study were selected. PRISMA was the most representative methodology used in the research work, which allowed for greater analysis and detail of the specific articles related to the topic. The importance of coordinating IT applications to improve organizational performance was highlighted, with an emphasis on agility as a key mechanism for strategic decision making. Lack of access to relevant data is equivalent to 10% of employees’ daily work time. Operational and quality errors generate customer complaints, which account for 2% of annual revenue. Non-compliance with quality standards, such as ISO 9001:2015, can amount to up to 5% of SUNARP’s annual operating costs. The staff in charge of quality management is in a sub optimal position, as they cannot directly access the data and analysis needed to evaluate quality indicators so they have to resort to the Technology area in order to access this information through reports. The motivation of the SLR is a fundamental step to identify best practices and strategies used by other organizations to overcome similar challenges presented in the problem.