Vol. 2 No. 4 (2026): Agustus
Articles

DESIGN AND ANALYSIS OF A DATA VISUALIZATION DASHBOARD FOR PT KERETA API INDONESIA (PERSERO) REGIONAL DIVISION III PALEMBANG USING THE PROTOTYPE METHOD

PDF
  • Nia Rahmawati,
  • Deni Fikari
Nia Rahmawati
UIN Raden Fatah Palembang
Deni Fikari
UIN Raden Fatah Palembang

Published 2026-08-13

Keywords

  • data visualization, dashboard, Prototype method, Microsoft Excel, decision support

Abstract

The management of operational data at PT Kereta Api Indonesia (Persero) Regional Division III Palembang still relies on Microsoft Excel as the primary medium for storing, processing, and presenting data. All data analysis is carried out manually, and information is still displayed in tabular form, making it difficult for users to quickly and comprehensively understand large volumes of data, identify patterns, or observe trends. This condition results in an inefficient and time-consuming monitoring and decision-making process, as the company has not yet had an automated dashboard capable of transforming Excel data into visual information. This study aims to analyze user requirements and design a web-based data visualization dashboard using the Prototype method, which consists of five stages: Communication, Quick Plan, Modeling Quick Design, Construction of Prototype, and Deployment, Delivery and Feedback. Data were collected through observation, interviews, and discussions with the Information Systems Division. System modeling was carried out using Business Process Model and Notation (BPMN) and Unified Modeling Language (UML), including Use Case Diagrams, Activity Diagrams, and Class Diagrams, while the user interface prototype was designed using Figma. The results show that the proposed dashboard is able to accommodate the functional and non-functional requirements identified, including Excel/CSV file upload, automatic data processing, data visualization in the form of bar charts, line charts, and pie charts, as well as statistical analysis (minimum, maximum, average, and sum). The resulting dashboard prototype is expected to serve as a reference for further system development, enabling faster, clearer, and more effective data monitoring and decision-making at PT Kereta Api Indonesia (Persero) Regional Division III Palembang.

PDF

References

  1. Bell, D. (2004). UML basics: The class diagram. IBM developerWorks, The Rational Edge, September 2004.
  2. Febrianty, R., Restyandito, & Chrisantyo, L. (2023). Analisis dan perancangan dashboard data karyawan pada PT Solen System Indonesia di Yogyakarta. Jurnal Teknologi Informasi dan Komunikasi, 14(1), 19–33. https://doi.org/10.51903/jtikp.v14i1.362
  3. Few, S. (2006). Information dashboard design: The effective visual communication of data. O'Reilly Media.
  4. Hidayat, M. (2023). Perancangan dashboard untuk visualisasi data jumlah penumpang Transjakarta. INSANtek, 4(1), 32–36.
  5. Noviyana, N., & Nasution, M. I. P. (2024). Implementasi database dalam meningkatkan efektivitas pengelolaan data mahasiswa. Kohesi: Jurnal Sains dan Teknologi, 3(11), 51–60. https://ejournal.warunayama.org/index.php/kohesi/article/view/4263
  6. Priskilla, V. G., Oslan, Y., & Ernawati, L. (2021). Implementasi dashboard untuk visualisasi data penerimaan mahasiswa baru studi kasus: Universitas Kristen Duta Wacana. Jurnal Terapan Teknologi Informasi, 5(2), 11–23. https://doi.org/10.21460/jutei.2021.52.234
  7. Rosa, A. S., & Shalahuddin, M. (2019). Rekayasa perangkat lunak terstruktur dan berorientasi objek. Informatika.
  8. Wartika. (2020). Materi 3 – Use Case Diagram [Bahan ajar]. Analisis dan Perancangan Sistem Informasi, Universitas Komputer Indonesia. http://kuliahonline.unikom.ac.id.