TY - GEN
T1 - Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte
AU - Deza Castillo, Juan M.
AU - Florian Castillo, Odar R.
AU - Meléndez, Gian Marco Arroyo
AU - del Pilar Valqui Jimenez, Liliana
N1 - Publisher Copyright:
© 2023 Latin American and Caribbean Consortium of Engineering Institutions. All rights reserved.
PY - 2023
Y1 - 2023
N2 - The objective of this research was to design a Datamart for the cargo service in an SME in the transport sector. Which had a mixed approach, applied, prospective, cross-sectional, and non-experimental, where the cargo transport service and records of the logistics area were selected as part of the sample. It conducted an interview validated by expert judgment, in addition to the respective analysis of the records for the development of the research. It applied the methodology of Kimball for the development of the design of the Datamart, making the dimensional database, which allowed the development of the ETL subsystem, the elaboration of the OLAP Cube and achieve the visualization of indicators, in a BI tool, according to the established requirements, estimating a cost of S/. 48.814 for implementation.
AB - The objective of this research was to design a Datamart for the cargo service in an SME in the transport sector. Which had a mixed approach, applied, prospective, cross-sectional, and non-experimental, where the cargo transport service and records of the logistics area were selected as part of the sample. It conducted an interview validated by expert judgment, in addition to the respective analysis of the records for the development of the research. It applied the methodology of Kimball for the development of the design of the Datamart, making the dimensional database, which allowed the development of the ETL subsystem, the elaboration of the OLAP Cube and achieve the visualization of indicators, in a BI tool, according to the established requirements, estimating a cost of S/. 48.814 for implementation.
KW - Business Intelligence
KW - Dashboard
KW - Datamart
KW - Freight Forwarding Service
KW - Ralph Kimball
UR - https://www.scopus.com/pages/publications/85172323545
M3 - Contribución a la conferencia
AN - SCOPUS:85172323545
T3 - Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology
BT - Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology
A2 - Larrondo Petrie, Maria M.
A2 - Texier, Jose
A2 - Matta, Rodolfo Andres Rivas
T2 - 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023
Y2 - 19 July 2023 through 21 July 2023
ER -