Use of data warehouse for business decision making: a literary review

Romero-Chuquital A.; Melendres-Velasco J.J. · Revista Cientifica de Sistemas e Informatica (2023) · DOI: 10.51252/rcsi.v3i2.543

Resumen

Over the years, Data Warehouses (DwH) have become necessary for companies that handle huge amounts of data from one or more sources, such as transactional systems or other relational databases. This tool allows processing and transforming raw data into useful information, make it available and accessible so that users can analyze it. Our objective was to identify the reason why it is necessary to implement DwH in organizations, as well as identify success stories, to achieve this we rely on the integrative review technique, using bibliographic search engines, ensuring the review of articles published in indexed journals. between the years 2018 and 2022. The review has made it possible to determine that the use of DwH plays an important role in decision-making in organizations. In conclusion, the Data Warehouse (DwH) is a fundamental tool in business decision-making by providing a solid infrastructure to collect, store and analyze large volumes of relevant data, allowing a holistic vision of the business and making decisions based on evidence, empowering business leaders to identify trends, opportunities and make strategic decisions, improving the efficiency, profitability and competitive advantage of companies.

Instituciones: Universidad Peruana Unión