Design and Implementation of An ETL-Based Data Management Pipeline Using a Semi-Kimball Approach for Business Intelligence in Boarding House and Laundry MSMEs
INSERT : Information System and Emerging Technology Journal · 30.06.2026 · 7 (1) · 1-14
DOI: 10.23887/insert.v7i1.113448 ↗Kurz gefasst
Fachartikel in der Zeitschrift INSERT : Information System and Emerging Technology Journal, online erschienen am 30.06.2026. Verfasst von I Made Yoga Sattwika Darma und 1 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
Micro, small, and medium enterprises (MSMEs) in the service sector, particularly boarding house and laundry businesses, often face challenges in managing operational data in an integrated and structured manner to support effective decision-making. In practice, most business owners rely on fragmented records and experiential judgment, resulting in limited ability to identify operational patterns and optimize business performance. This study proposes the design and implementation of a lightweight data management pipeline based on Extract, Transform, Load (ETL) and a data mart using a semi-Kimball approach to support Business Intelligence in MSMEs. The research adopts a Design Science Research (DSR) methodology, focusing on the development of a practical system artifact. The dataset consists of a combination of internal operational data, data from similar businesses, and simulated data reflecting realistic operational conditions. The system is implemented using Python for ETL processes, SQLite as a lightweight data warehouse, and Flask for backend and API services. The results demonstrate that the proposed system successfully integrates multi-source data—including occupancy, laundry transactions, and operational activities—into a structured and consistent data model. The system further enables the delivery of interactive dashboards that support descriptive and diagnostic analytics, facilitating the identification of operational patterns and improving data-driven decision-making.
Zitieren
APA
Darma, I. M. Y. S., & Astuti, L. G. (2026). Design and Implementation of An ETL-Based Data Management Pipeline Using a Semi-Kimball Approach for Business Intelligence in Boarding House and Laundry MSMEs. INSERT : Information System and Emerging Technology Journal, 7(1), 1-14. https://doi.org/10.23887/insert.v7i1.113448
Vancouver
Darma IMYS, Astuti LG. Design and Implementation of An ETL-Based Data Management Pipeline Using a Semi-Kimball Approach for Business Intelligence in Boarding House and Laundry MSMEs. INSERT : Information System and Emerging Technology Journal. 2026;7(1):1-14. doi:10.23887/insert.v7i1.113448
BibTeX
@article{Darma2026,
author = {Darma, I Made Yoga Sattwika and Astuti, Luh Gede},
title = {Design and Implementation of An ETL-Based Data Management Pipeline Using a Semi-Kimball Approach for Business Intelligence in Boarding House and Laundry MSMEs},
journal = {INSERT : Information System and Emerging Technology Journal},
year = {2026},
volume = {7},
number = {1},
pages = {1--14},
doi = {10.23887/insert.v7i1.113448}
}
EUVIMED