TY - JOUR
T1 - Business intelligence for decision-making in the collection area of a municipality
AU - Daza, Alfredo
AU - Casas, Daniela Belen Salazar
AU - Cajas, Yohan Roy Alarcón
N1 - Publisher Copyright:
© 2024, Institute of Advanced Engineering and Science. All rights reserved.
PY - 2024/12
Y1 - 2024/12
N2 - The large volume of data in systems in the collection area leads to the lack of adequate management of information, as well as dissatisfaction on the part of the user. The purpose of the study is to implement business intelligence (BI) technology to improve the effectiveness of the information and the satisfaction of the attention of the users of a municipality of Lima in the area of collection; therefore, the phases of the Ralph Kimball method with the following phases: project planning; definition of requirements; design of technological architecture; in the dimensional modeling a snowflake scheme was made with 9 dimensions and 1 table made, in the physical design it was implemented in the MySQL management system and in the extract, transform, and load (ETL) development the migration, transformation and cleaning of the data from the online transaction processing (OLTP) database to online analytical processing (OLAP) was executed; obtaining as results that BI managed to increase the level of information efficiency by 53.32%, as well as the level of user satisfaction (LUS) by 1.90%, concluding that BI allows to meet the needs of the user since it maintains a clean, secure and reliable data structure.
AB - The large volume of data in systems in the collection area leads to the lack of adequate management of information, as well as dissatisfaction on the part of the user. The purpose of the study is to implement business intelligence (BI) technology to improve the effectiveness of the information and the satisfaction of the attention of the users of a municipality of Lima in the area of collection; therefore, the phases of the Ralph Kimball method with the following phases: project planning; definition of requirements; design of technological architecture; in the dimensional modeling a snowflake scheme was made with 9 dimensions and 1 table made, in the physical design it was implemented in the MySQL management system and in the extract, transform, and load (ETL) development the migration, transformation and cleaning of the data from the online transaction processing (OLTP) database to online analytical processing (OLAP) was executed; obtaining as results that BI managed to increase the level of information efficiency by 53.32%, as well as the level of user satisfaction (LUS) by 1.90%, concluding that BI allows to meet the needs of the user since it maintains a clean, secure and reliable data structure.
KW - Business intelligence
KW - Data mart
KW - Decision making
KW - Level of effectiveness
KW - Ralph Kimball
UR - http://www.scopus.com/inward/record.url?scp=85205269008&partnerID=8YFLogxK
U2 - 10.11591/eei.v13i6.5704
DO - 10.11591/eei.v13i6.5704
M3 - Article
AN - SCOPUS:85205269008
SN - 2089-3191
VL - 13
SP - 4223
EP - 4235
JO - Bulletin of Electrical Engineering and Informatics
JF - Bulletin of Electrical Engineering and Informatics
IS - 6
ER -