IMPLEMENTASI DASHBOARD BERBASIS WEB UNTUK MENINGKATKAN EFISIENSI PENGELOLAAN DATA TILANG ELEKTRONIK (ETLE) PADA OPERASIONAL MOTOR LISTRIK PT SEPEDA UNTUK INDONESIA
Abstract
This study aims to describe the implementation of a web-based dashboard using Google Apps Script to improve the efficiency of Electronic Traffic Law Enforcement (ETLE) data management at PT Sepeda Untuk Indonesia. The previous ETLE data management process relied on Google Sheets, making data retrieval, monitoring, and management less efficient as operational data volumes continued to increase. This research employed a Research and Development (R&D) method with a qualitative approach, following the Waterfall model across five stages: Requirements Analysis, System Design, Implementation, Testing, and Maintenance. Ten operational staff members were selected through purposive sampling as research informants. Data were collected through participatory observation, open-ended questionnaires, documentation, operational time measurements, and Black Box Testing. The findings indicate that the web-based dashboard successfully integrated ETLE data searching, monitoring, and management into a structured system. The dashboard simplified information retrieval, supported access via computers and smartphones, and improved operational effectiveness. Operational time measurements showed that average data retrieval time decreased significantly from approximately 5–20 minutes to 4–7 seconds after dashboard implementation, yielding an average efficiency improvement of ±98.9% across 10 informants. These results demonstrate that the Google Apps Script-based web dashboard effectively enhanced ETLE data management efficiency and supported operational activities at PT Sepeda Untuk Indonesia.
References
Adisti, K. P., & Nugraha, I. (2025). Implementasi Sistem Dashboard untuk Visualisasi Data Monitoring Penagihan dengan Menggunakan Google Looker Studio. JATI, 9(2), 1854–1861.
APJII. (2024). Survei Penetrasi Internet Indonesia 2024. https://databoks.katadata.co.id
APJII. (2025). Survei Penetrasi Internet Indonesia 2025. https://apjii.or.id
Creswell, J. W. (2014). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches (4th ed.). SAGE Publications.
Daft, R. L. (2021). Management (14th ed.). South-Western Cengage Learning.
Digital Transformation Indonesia. (2024). Revolusi Teknologi dalam Transportasi Indonesia. https://digitaltransformation.co.id
Few, S. (2006). Information Dashboard Design: The Effective Visual Communication of Data. O'Reilly Media.
Haryadina Putra, B. A. F., & Dirgahayu, R. T. (2025). Google Apps Script untuk Pengembangan Sistem Informasi Laboratorium. JATISI, 12(1).
Laudon, K. C., & Laudon, J. P. (2022). Management Information Systems: Managing the Digital Firm (17th ed.). Pearson.
Miles, M. B., Huberman, A. M., & Saldaña, J. (2014). Qualitative Data Analysis: A Methods Sourcebook (3rd ed.). SAGE Publications.
Nurfadhilah, A., Pitriya, A., & Hidayat, W. (2025). Desain Dashboard Web untuk Pemantauan dan Pelaporan Status Produksi di PT. Care Spunbond. Saturnus: Jurnal Teknologi dan Sistem Informasi, 3(4), 191–201.
O'Brien, J. A., & Marakas, G. M. (2018). Introduction to Information Systems (16th ed.). McGraw-Hill Education.
Perdana, A. N., Prasetya, A. R., & Ikasari, I. H. (2025). Peran Sistem Informasi Manajemen dalam Meningkatkan Efisiensi Operasional. Journal of Science Education and Management Business, 2(10), 1917–1920.
Pressman, R. S. (2010). Software Engineering: A Practitioner's Approach (7th ed.). McGraw-Hill.
Republik Indonesia. (2009). Undang-Undang Nomor 22 Tahun 2009 tentang Lalu Lintas dan Angkutan Jalan.
Republik Indonesia. (2023). Peraturan Presiden Nomor 79 Tahun 2023 tentang Percepatan Program Kendaraan Bermotor Listrik Berbasis Baterai untuk Transportasi Jalan.
Rianto, I., Pratasik, S., Maru, M. G., & Pardanus, R. H. W. (2023). Pengembangan Dashboard Sistem Informasi di Universitas Negeri Manado. CogITo Smart Journal, 9(1), 120–134.
Robbins, S. P., & Coulter, M. (2022). Management (15th ed.). Pearson Education.
Sugiyono. (2023). Metode Penelitian Kualitatif. Alfabeta.
Sutiono, S., & Dirgahayu, T. (2024). Pengembangan Sistem Informasi Pendanaan Sumber Daya Manusia Menggunakan Google Apps Script. EDUSAINTEK, 11(4), 2238–2254.
Taylor, F. W. (1911). The Principles of Scientific Management. Harper & Brothers.
Tempo. (2024). 414 Ribu Pelanggaran Lalu Lintas Tertangkap Kamera ETLE, Denda Tembus Rp121,7 M. https://www.tempo.co
Wijaya, T. (2024). Pemanfaatan Google Apps Script dalam Merancang Aplikasi Web Guna Meningkatkan Efisiensi Biaya. Jurnal IGNITE, 2(3), 8–20.
