Development of a Web-Based ETL Automation System to Support Monthly Reports
Journal of Applied Science, Technology & Humanities · 2026
DOI: 10.62535/2nepa911 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Applied Science, Technology & Humanities, 2026. Verfasst von Icha Maulidya und 3 weiteren Autor:innen.
Abstract (Originalsprache)
The process of preparing monthly reports in the Asset Accounting Department of PT RS was hampered by manual data transformation and the lack of centralized storage, which caused historical data to be scattered, difficult to track, and vulnerable to human error. This condition prompted the development of a web-based Extract, Transform, Load automation system that integrates data cleansing, schema validation, a centralized repository, and a reporting dashboard as a replacement for external Business Intelligence tools. The methodology used was Rapid Application Development with Python (Flask) and MySQL. The system was tested through Alpha Testing with Black Box Testing using the Equivalence Partitioning technique for 34 test cases resulting in a validation percentage of 100%. Beta Testing to 8 respondents resulted in a feasibility of 96.4% (Admin) and 99.1% (User) in the "Very Feasible" category, as well as Performance Testing with an error rate of 0.00% at normal load and 0.30% at high load, as well as a stable throughput of 3.1 transactions per minute. These test results confirmed that the system met all acceptance criteria and was suitable to support a more efficient monthly report process.
Zitieren
APA
Maulidya, I., Fakhirah, S. F., Manik, J. S. R., & Yuaziva, A. (2026). Development of a Web-Based ETL Automation System to Support Monthly Reports. Journal of Applied Science, Technology & Humanities. https://doi.org/10.62535/2nepa911
Vancouver
Maulidya I, Fakhirah SF, Manik JSR, Yuaziva A. Development of a Web-Based ETL Automation System to Support Monthly Reports. Journal of Applied Science, Technology & Humanities. 2026. doi:10.62535/2nepa911
BibTeX
@article{Maulidya2026,
author = {Maulidya, Icha and Fakhirah, Siti Farah and Manik, Jonser Steven Rajali and Yuaziva, Asa},
title = {Development of a Web-Based ETL Automation System to Support Monthly Reports},
journal = {Journal of Applied Science, Technology & Humanities},
year = {2026},
doi = {10.62535/2nepa911}
}
EUVIMED