Design of Datamart for the Cargo Service of an SME in the Transport Sector

Authors

  • DEZA CASTILLO, JUAN MIGUEL
  • FLORIAN CASTILLO, ODAR ROBERTO
  • ARROYO MELENDEZ, GIAN MARCO
  • VALQUI JIMENEZ, LILIANA DEL PILAR

DOI:

https://doi.org/10.18687/LACCEI2023.1.1.386

Keywords:

Datamart, Ralph Kimball, Freight Forwarding Service, Business Intelligence, Dashboard

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.

Downloads

Published

2024-04-16

Issue

Section

Articles