TY - GEN
T1 - Efficiency in the Availability of Indicators of a Datamart Based on the Kimball Methodology for a Baking Company
AU - Vidal, Samuel Roncal
AU - Díaz, Roger Huanca
AU - Loaiza, Omar L.
N1 - Publisher Copyright:
© 2023, The Author(s), under exclusive license to Springer Nature Switzerland AG.
PY - 2023
Y1 - 2023
N2 - 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.
AB - 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.
KW - Business intelligence
KW - Datamart
KW - Financial indicators
KW - Kimball methodology
UR - http://www.scopus.com/inward/record.url?scp=85151120372&partnerID=8YFLogxK
U2 - 10.1007/978-3-031-26254-8_132
DO - 10.1007/978-3-031-26254-8_132
M3 - Conference contribution
AN - SCOPUS:85151120372
SN - 9783031262531
T3 - Lecture Notes in Networks and Systems
SP - 911
EP - 919
BT - Artificial Intelligence and Smart Environment - ICAISE 2022
A2 - Farhaoui, Yousef
A2 - Rocha, Alvaro
A2 - Brahmia, Zouhaier
A2 - Bhushab, Bharat
PB - Springer Science and Business Media Deutschland GmbH
T2 - International Conference on Artificial Intelligence and Smart Environment, ICAISE 2022
Y2 - 24 November 2022 through 26 November 2022
ER -