Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte

Juan M. Deza Castillo; Odar R. Florian Castillo; Gian Marco Arroyo Meléndez; Liliana del Pilar Valqui Jimenez

Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte

Translated title of the contribution: Design of Datamart for the Cargo Service of an SME in the Transport Sector

Juan M. Deza Castillo, Odar R. Florian Castillo, Gian Marco Arroyo Meléndez, Liliana del Pilar Valqui Jimenez

Humanities

Universidad Privada del Norte

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

1 Scopus citations

Abstract

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.

Translated title of the contribution	Design of Datamart for the Cargo Service of an SME in the Transport Sector
Original language	Spanish
Title of host publication	Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology
Subtitle of host publication	Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023
Editors	Maria M. Larrondo Petrie, Jose Texier, Rodolfo Andres Rivas Matta
ISBN (Electronic)	9786289520743
State	Published - 2023
Event	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 - Buenos Aires, Argentina Duration: 19 Jul 2023 → 21 Jul 2023

Publication series

Name	Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology
Volume	2023-July
ISSN (Electronic)	2414-6390

Conference

Conference	21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023
Country/Territory	Argentina
City	Buenos Aires
Period	19/07/23 → 21/07/23

Cite this

Deza Castillo, J. M., Florian Castillo, O. R., Meléndez, G. M. A., & del Pilar Valqui Jimenez, L. (2023). Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte. In M. M. Larrondo Petrie, J. Texier, & R. A. R. Matta (Eds.), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023 (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July).

Deza Castillo, Juan M. ; Florian Castillo, Odar R. ; Meléndez, Gian Marco Arroyo et al. / Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte. Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. editor / Maria M. Larrondo Petrie ; Jose Texier ; Rodolfo Andres Rivas Matta. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

@inproceedings{4d250b51b43b4f318bfbf8b82abf92ee,

title = "Dise{\~n}o de Datamart para el Servicio de Carga de una Pyme del Sector Transporte",

abstract = "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.",

keywords = "Business Intelligence, Dashboard, Datamart, Freight Forwarding Service, Ralph Kimball",

author = "{Deza Castillo}, {Juan M.} and {Florian Castillo}, {Odar R.} and Mel{\'e}ndez, {Gian Marco Arroyo} and {del Pilar Valqui Jimenez}, Liliana",

note = "Publisher Copyright: {\textcopyright} 2023 Latin American and Caribbean Consortium of Engineering Institutions. All rights reserved.; 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023 ; Conference date: 19-07-2023 Through 21-07-2023",

year = "2023",

language = "Espa{\~n}ol",

series = "Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology",

editor = "{Larrondo Petrie}, {Maria M.} and Jose Texier and Matta, {Rodolfo Andres Rivas}",

booktitle = "Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology",

}

Deza Castillo, JM, Florian Castillo, OR, Meléndez, GMA & del Pilar Valqui Jimenez, L 2023, Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte. in MM Larrondo Petrie, J Texier & RAR Matta (eds), Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology, vol. 2023-July, 21st LACCEI International Multi-Conference for Engineering, Education and Technology, LACCEI 2023, Buenos Aires, Argentina, 19/07/23.

Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte. / Deza Castillo, Juan M.; Florian Castillo, Odar R.; Meléndez, Gian Marco Arroyo et al.
Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. ed. / Maria M. Larrondo Petrie; Jose Texier; Rodolfo Andres Rivas Matta. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology; Vol. 2023-July).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

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

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 - http://www.scopus.com/inward/record.url?scp=85172323545&partnerID=8YFLogxK

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 -

Deza Castillo JM, Florian Castillo OR, Meléndez GMA, del Pilar Valqui Jimenez L. Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte. In Larrondo Petrie MM, Texier J, Matta RAR, editors, Proceedings of the 21st LACCEI International Multi-Conference for Engineering, Education and Technology: Leadership in Education and Innovation in Engineering in the Framework of Global Transformations: Integration and Alliances for Integral Development, LACCEI 2023. 2023. (Proceedings of the LACCEI international Multi-conference for Engineering, Education and Technology).

Diseño de Datamart para el Servicio de Carga de una Pyme del Sector Transporte

Abstract

Publication series

Conference

Other files and links

Fingerprint

Cite this