Rancang Bangun Aplikasi Pengelolaan Data Statistik Sosial Berbasis Web menggunakan Metode Kanban
DOI:
https://doi.org/10.55606/jupti.v5i2.7101Keywords:
Agile Development, Black-Box Testing, Kanban, Social Statistics, Web ApplicationAbstract
Statistical data is a crucial foundation for evidence-based government policymaking and public accountability. The Social Statistics Division of Badan Pusat Statistik (BPS) Jambi Province currently manages its data through fragmented Microsoft Excel files, causing inefficiencies such as difficulty locating tables, vulnerability to manual entry errors, and the absence of a structured verification pathway before data reaches external users. This study designed and developed SISTADISS (Sistem Pengelolaan Data Statistik Sosial), a web-based application for social statistics data management, using the Kanban agile development method. The system was built using Next.js, Neon PostgreSQL, Prisma ORM, and Tailwind CSS. Authentication is implemented through an SSO integration for internal BPS staff and a bcryptjs-JWT mechanism for external users. Development was conducted across four iterative cycles: user authentication, dynamic statistical table display, data management via a change-request workflow, and a multi-level verification module. All nineteen functional requirements were validated through black-box testing, yielding a 100% pass rate across three user roles: Admin Verifikasi, Petugas, and Pengguna. The system was deployed on Vercel and is accessible at the BPS Jambi Province institutional domain.
References
Alaidaros, H., Omar, M., & Romli, R. (2021). The state of the art of agile Kanban method: Challenges and opportunities. Independent Journal of Management & Production, 12(8), 2535–2550. https://doi.org/10.14807/ijmp.v12i8.1482
ALazzawi, A., Yas, Q. M., & Rahmatullah, B. (2023). A comprehensive review of software development life cycle methodologies. Iraqi Journal for Computer Science and Mathematics, 4(4), 173–190. https://doi.org/10.52866/ijcsm.2023.04.04.014
Anderson, D. J., & Carmichael, A. (2016). Essential Kanban condensed. Blue Hole Press.
Assidqi, M., Prasetyo, Y. A., & Adi, T. N. (2015). Pembangunan aplikasi web e-commerce kelompok tani Katata dengan metode iterative and incremental. eProceedings of Engineering, 2(2).
Badan Pusat Statistik. (2025, January). Profil BPS [Laman daring]. https://ppid.bps.go.id/app/konten/3506/Profil-BPS.html
Beck, K., Beedle, M., van Bennekum, A., Cockburn, A., Cunningham, W., Fowler, M., Grenning, J., Highsmith, J., Hunt, A., Jeffries, R., Kern, J., Marick, B., Martin, R. C., Mellor, S., Schwaber, K., Sutherland, J., & Thomas, D. (2001). Manifesto for agile software development [Laman daring]. http://agilemanifesto.org/
Damij, N., & Damij, T. (2024). An approach to optimizing Kanban board workflow and shortening the project management plan. IEEE Transactions on Engineering Management, 71, 13266–13273. https://doi.org/10.1109/TEM.2021.3120984
DataReportal. (2025, January). Digital 2025: Indonesia [Laporan daring]. https://datareportal.com/reports/digital-2025-indonesia
Firmansyah, Y., Maulana, R., & Fatin, N. (2020). Sistem informasi pengaduan warga berbasis website (studi kasus: Kelurahan Siantan Tengah). Jurnal Cendikia, 19, 397–404.
Jones, M., Bradley, J., & Sakimura, N. (2015, May). JSON Web Token (JWT) (RFC 7519) [Standar internet]. Internet Engineering Task Force. https://datatracker.ietf.org/doc/html/rfc7519
Lubis, B. O., Ridwan, M., Sari, Y., Rahmawati, D., & Pratama, A. (2023). Implementasi metode Kanban pada rancangan sistem informasi helpdesk pada kantor imigrasi berbasis website. Jurnal Infortech, 5(2), 106–117. https://doi.org/10.31294/infortech.v5i2.17163
Maspupah, A. (2024). Literature review: Advantages and disadvantages of black box and white box testing methods. Jurnal Techno Nusa Mandiri, 21(2), 151–162. https://doi.org/10.33480/techno.v21i2.5776
Maulidi, R., & Kusuma, B. H. (2023). Pengembangan sistem monitoring perangkat jaringan menggunakan metode agile dan Kanban. Tematik, 10(1), 137–145. https://doi.org/10.38204/tematik.v10i1.1303
Neon. (2024). Neon serverless PostgreSQL documentation [Dokumentasi daring]. https://neon.tech/docs
Nidhra, S., & Dondeti, J. (2012). Black box and white box testing techniques: A literature review. International Journal of Embedded Systems and Applications, 2(2), 29–50.
Pressman, R. S., & Maxim, B. R. (2019). Software engineering: A practitioner's approach (9th ed.). McGraw-Hill.
Prisma. (2024). Prisma ORM documentation [Dokumentasi daring]. https://www.prisma.io/docs
Putra, O. D. (2025). Rancang bangun aplikasi web pengelolaan statistik sosial BPS Provinsi Jambi menggunakan metode Kanban [Skripsi sarjana, Universitas Jambi].
Roslin, P. F. (2024). Penerapan metode Kanban dalam rancang bangun sistem informasi manajemen rapat (studi kasus: PT Angkasa Pura II KC Sultan Thaha Jambi) [Skripsi sarjana, Universitas Jambi].
Schwaber, K., & Sutherland, J. (2020, November). The Scrum guide [Panduan daring]. Scrum.org. https://scrumguides.org/scrum-guide.html
Sumarudin, A., Amirrudin, & Suheryadi, A. (2021). Penerapan sistem informasi penelitian internal di Politeknik Negeri Indramayu menggunakan metode Kanban. JITSI: Jurnal Ilmiah Teknologi Sistem Informasi, 2(4), 103–107. https://doi.org/10.30630/jitsi.2.4.42
Tailwind Labs. (2024). Tailwind CSS documentation [Dokumentasi daring]. https://tailwindcss.com/docs
Vercel Inc. (2024). Next.js documentation [Dokumentasi daring]. https://nextjs.org/docs
Wijoyo, A., Suprianto, B., Alamsah, I., Kustiawan, I., Putra, B. E., & Yana, R. R. (2024). Manajemen proyek rancang bangun aplikasi e-commerce berbasis website untuk batik khas Tangerang. OKTAL: Jurnal Ilmu Komputer dan Ilmu Komputer, 3(2), 381–388.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Jurnal Publikasi Teknik Informatika
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
