EUVIMEDEUVIMED entdecken
Crossref

Development of a Web-Based ETL Automation System to Support Monthly Reports

Icha Maulidya, Siti Farah Fakhirah, Jonser Steven Rajali Manik, Asa Yuaziva

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →