Implementation of a Business Intelligence Dashboard for Monitoring Crimes at the Siak Hulu Police, Kampar
AbstractSiak Hulu Police, Kampar is the command structure of the Indonesian National Police at the sub district level, namely the Siak Hulu sub-district. The Siak Hulu Sector Police handles various criminal cases. Based on the results of interviews with the Siak Hulu Police, Kampar, Siak Hulu is one area that has a fairly high crime rate in Riau. Reported criminal case data is managed by the administration of the Siak Hulu Sector Police. Every month, the Siak Hulu Sector Police conducts evaluation studies or regular meetings, in which they need historical data to assist in making decisions. Until now, the Siak Hulu, Kampar Sector Police store data on criminal cases using Microsoft Excel, so that they are overwhelmed in reading the existing data and make it difficult for them to classify criminal cases. Therefore, a business intelligence dashboard was built to monitor criminal cases at the Siak Hulu Police, Kampar so that the police can easily make the right decisions. The business intelligence system is built using the codeigniter framework and uses the PHP and MySQL programming languages â€‹â€‹as databases. The system is tested using data transformations testing, efficiency, black box testing and user acceptance test (UAT) and so that it can find out the improvements desired by the user. Based on the user acceptance test (UAT) that has been carried out, it shows that 98.95% of the system that has been built has been accepted by users and can help the Siak Hulu Kampar Sector Police in making decisions.
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.