Rancang Bangun Sistem Import dan Transformasi Data Excel ke Database Mysql pada Koperasi Syariah Benteng Mikro Indonesia

Erick Tarantino; Farizi Ilham; Pipin Haeriyanti; Tijan Daruri

doi:10.62951/router.v4i2.887

Authors

Erick Tarantino Universitas Pamulang
Farizi Ilham Universitas Pamulang
Pipin Haeriyanti Universitas Pamulang
Tijan Daruri Universitas Pamulang

DOI:

https://doi.org/10.62951/router.v4i2.887

Keywords:

Data Import, Data Transformation, Excel, MySQL, Python Flask

Abstract

Koperasi Syariah Benteng Mikro Indonesia is a microfinance institution that manages member data, financing, and financial transactions. Currently, data processing is still largely conducted using unstructured Excel files, which often leads to data duplication, formatting errors, information inconsistency, and delays in database integration. The objective of this internship project is to design and develop a web-based system for importing and transforming Excel data to improve efficiency, accuracy, and consistency in data management.The development method uses the SDLC Waterfall model, which consists of analysis, design, implementation using Python Flask and MySQL, and testing. Data collection methods include interviews, observations, and literature studies involving administrative staff and the IT division of the cooperative.The system scope includes eight main features: (1) Excel file upload; (2) data preview; (3) interactive column mapping; (4) automatic data validation; (5) data format transformation; (6) import process simulation; (7) data import into a MySQL database; and (8) logging and reporting of import results.The expected outcomes are to reduce data errors by up to 85%, accelerate data entry processes, improve database consistency, and support structured and integrated digitalization of cooperative data.

Downloads

Download data is not yet available.

References

Chanda, D. (2024). Automated ETL pipelines for modern data warehousing: Architectures, challenges, and emerging solutions. The Eastasouth Journal of Information System and Computer Science, 1(3), 209–212. https://doi.org/10.58812/esiscs.v1i03.523

Elmasri, R., & Navathe, S. B. (2017). Fundamentals of database systems (7th ed.). Pearson. https://books.google.com/books/about/Fundamentals_of_Database_Systems.html?id=tRybCgAAQBAJ

Flask Documentation. (2025). Welcome to Flask. https://flask.palletsprojects.com/

Fowler, M. (2021). UML distilled: A brief guide to the standard object modeling language (4th ed.). Addison-Wesley.

Kimball, R., & Caserta, J. (2004). The data warehouse ETL toolkit: Practical techniques for extracting, cleaning, conforming, and delivering data. Wiley Publishing.

Larasati, S., & Susetyo, Y. A. (2024). Development of a web-based trading term application using Flask framework at PT. XYZ. International Journal Software Engineering and Computer Science, 4(1), 367–376. https://doi.org/10.35870/ijsecs.v4i1.2339

Mahmud, D., & Ikbal, M. Z. (2022). The role of ETL (Extract-Transform-Load) pipelines in scalable business intelligence: A comparative study of data integration tools. ASRC Procedia: Global Perspectives in Science and Scholarship, 2(1), 89–121. https://doi.org/10.63125/1spa6877

Nithish, R., Ravi, & David. (2024). Data transformation techniques in ETL. International Journal of Multidisciplinary on Science and Management, 1(2), 1–16. https://doi.org/10.71141/30485037/V1I2P101

Pressman, R. S., & Maxim, B. R. (2020). Software engineering: A practitioner's approach (9th ed.). McGraw-Hill Education.

Relan, K. (2019). Building REST APIs with Flask: Create Python web services with MySQL. Apress. https://doi.org/10.1007/978-1-4842-5022-8

Sari, P., Kesuma, L. I., Afrina, M., & Kurniawan, D. (2024). Pemodelan integrasi data barang milik negara di perguruan tinggi menggunakan metode ETL (Extract, Transform, Load) dengan Pentaho. International Journal of Computer Science, 13(5). https://doi.org/10.33022/ijcs.v13i5.4424

Setiyawati, N. (2025). Design and implementation of an ETL pipeline for business intelligence systems. Jurnal Sistemasi. https://sistemasi.ftik.unisi.ac.id/index.php/stmsi/article/view/5158

Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database system concepts (7th ed.). McGraw-Hill Education. https://www.db-book.com/

Walingkas, H. L., & Saian, P. O. N. (2023). Penerapan framework Flask pada pembangunan sistem informasi pemasok barang. Jurnal Teknologi Informasi dan Komunikasi, 7(2), 227–234. https://doi.org/10.35870/jtik.v7i2.729

Wiratama, J., & Bagioyuwono, M. A. (2023). Improving the data management: ETL implementation on data warehouse at Indonesian vehicle insurance industry. International Journal of Science, Technology & Management, 4(5), 1256–1268. https://doi.org/10.46729/ijstm.v4i5.936