Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal INSERT: Information System and Emerging Technology Journal
I Made Yoga Sattwika Darma
Udayana University
Computer Science & IT Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Design and Implementation of An ETL-Based Data Management Pipeline Using a Semi-Kimball Approach for Business Intelligence in Boarding House and Laundry MSMEs: English I Made Yoga Sattwika Darma; Luh Gede Astuti
INSERT : Information System and Emerging Technology Journal Vol. 7 No. 1 (2026)
Publisher : Information System Study Program, Faculty of Engineering and Vocational, Undiksha

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.23887/insert.v7i1.113448

Abstract

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.
Co-Authors Luh Gede Astuti