DEVELOPMENT OF A DATA VISUALIZATION DASHBOARD AT PT KAI REGIONAL DIVISION III PALEMBANG

Abstract

PT Kereta Api Indonesia (Persero) Regional Division III Palembang still processes and presents operational data manually in Microsoft Excel. This practice is time-consuming and prone to error, particularly when large datasets are handled. This study aims to implement a previously designed data visualization dashboard as a web-based application and to test its main functions. The system was developed by combining the Prototype method for analysis and design with Rapid Application Development (RAD) for implementation, applying an object-oriented programming paradigm based on use case, activity, class, and entity relationship diagrams. Data were collected through direct observation during the internship. Functional testing used black-box testing with the equivalence partitioning technique. The result is a web-based dashboard comprising ten modules, namely authentication, analytical dashboard, data explorer, data visualization, data calculator, workbook management, account management, audit log, data storage, and settings. It reads Excel and CSV files and automatically converts them into six chart types. Black-box testing on five features showed that all valid and invalid test classes produced the expected results, so the system satisfies the specified functional requirements. The dashboard is therefore functionally feasible as an alternative to manual data processing in Excel.