Datamart for the analysis of information in the sales process of the company WC HVAC Engineering

Abstract

Introduction: information has become a crucial asset for companies in decision making and performance evaluation. Information technologies, such as Business Intelligence, allow data to be converted into relevant information. The implementation of a Datamart, a specialized database, stands out as a solution to analyze specific data from a business area. Objective: the main objective is to determine how the implementation of a Datamart affects data analysis in the sales area of the company. Method: a bibliographic review of various sources was carried out using the PICO keywords. In addition, filters were applied to limit the search to relevant articles published in the last 5 years in Spanish or English. Then, 31 relevant documents that highlighted the implementation of Datamarts in the sales area were evaluated. Results: predominant Datamart development methods were identified, such as the Kimball and Hefesto methodologies. Likewise, effectiveness was measured through indicators such as processing time, report generation, user satisfaction and availability of information. Conclusions: in conclusion, a well-implemented Datamart can be a key tool to improve data management and analysis in the sales area of a company.