Design of Datamart for the Cargo Service of an SME in the Transport Sector
DOI:
https://doi.org/10.18687/LACCEI2023.1.1.386Palabras clave:
Datamart, Ralph Kimball, Freight Forwarding Service, Business Intelligence, DashboardResumen
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.
Descargas
Publicado
2023-07-27
Número
Sección
Articles
Derechos de autor
Derechos de autor 2023 LACCEI
Licencia
Esta obra está bajo una Licencia Creative Commons Atribución-NoComercial-CompartirIgual 4.0 Internacional.
LACCEI conserva el copyright de todos los artículos publicados bajo los términos de su acuerdo de transferencia de copyright. Como titular del copyright, LACCEI distribuye los artículos al público bajo la Licencia Internacional Creative Commons Atribución-NoComercial-CompartirIgual 4.0 (CC BY-NC-SA 4.0).
Cómo citar
DEZA CASTILLO, JUAN MIGUEL, FLORIAN CASTILLO, ODAR ROBERTO, ARROYO MELENDEZ, GIAN MARCO, & VALQUI JIMENEZ, LILIANA DEL PILAR. (2023). Design of Datamart for the Cargo Service of an SME in the Transport Sector. LACCEI, 1(8). https://doi.org/10.18687/LACCEI2023.1.1.386