Efficiency in the Availability of Indicators of a Datamart Based on the Kimball Methodology for a Baking Company

Vidal S.R.; Díaz R.H.; Loaiza O.L. · Lecture Notes in Networks and Systems (2023) · DOI: 10.1007/978-3-031-26254-8_132

Resumen

The aim of this research was to streamline the availability of strategic indicators of the financial perspective of a bakery company in Peru, through a Datamart based on Kimball's methodology. This study is relevant because it can serve as a reference for organizations in the process of growing their operations and market coverage to monitor their performance through indicators. Methodologically, this research consists of 5 phases: i) planning, ii) e-laboration of requirements, iii) analysis and design, iv) construction and deployment and v) evaluation of availability efficiency. The conclusions are: availability is more efficient because obtaining indicators goes from 3.49 min to 16 s, which represents an improvement of 93.1%, given that there is less sending of bytes from the client from 1,176 to 362 (efficiency of 69.21%) when server; and of a lower generation of bytes in this from 780,627 bytes to 186,968 bytes (efficiency of 417.52%); that is, with fewer bytes the recoverability is better.

Instituciones: Universidad Peruana Unión