Development of a Dashboard-Based Information System to Improve Prospective Customer Engagement at PLN UP3 Bima
Keywords:
System Dashboad, Data Visualization, PLN UP3 Bima, Spatial Information System, Data IntegrationAbstract
PT PLN (Persero) UP3 Bima faces challenges in effectively managing and analyzing prospective customer data, resulting in delays in decision-making and suboptimal utilization of potential connected power. This study aims to develop an interactive dashboard system using Looker Studio and Google Sheets to improve operational efficiency and support digital transformation within PLN. The methodology includes user needs analysis, real-time data integration from Google Sheets, and the design of data visualizations in Looker Studio based on key parameters such as customer growth trends, sector classification, and potential connected power. The implementation results show that the system effectively delivers accurate and timely information, assisting management in identifying opportunities to increase new customer connections. The impact of this system includes enhanced effectiveness in managing prospective customer data, faster decision-making processes, and stronger support for data-driven strategies to increase customer acquisition in a measurable way.
Downloads
References
[1] N. Rosetto and V. Reif, “Digitalization of the electricity infrastructure: a key enabler for the decarbonization and decentralization of the power sector,” A Mod. Guid. to Digit. Infrastruct., 2021, doi: 10.4337/9781839106057.00015.
[2] H. Pratiwi, N. Fitriani, E. Junirianto, and M. I. Sa’ad, “Development of Web and Android Based Employee Attendance Monitoring Application,” J. Artif. Intell. Eng. Appl., 2025, [Online]. Available: https://api.semanticscholar.org/CorpusID:276400218
[3] M. A. Komara, A. Y. Salim, and M. Firdaus, “Automated Attendance System for Contract-Based Employees at Purwakarta Communication and Informatics Agency,” Sinkron, 2025, [Online]. Available: https://api.semanticscholar.org/CorpusID:278112566
[4] E. Meilinda, “Rancang Bangun Sistem Informasi Presensi Pegawai Dengan Memanfaatkan Metode Pengembangan Prototype,” J. Tek. Inf. dan Komput., vol. 4, no. 2, p. 191, 2021, doi: 10.37600/tekinkom.v4i2.339.
[5] R. Samsinar, J. E. Suseno, and C. E. Widodo, “Power Distribution Analysis for Electrical Usage in Province Area Using Olap (Online Analytical Processing),” E3S Web Conf., vol. 31, pp. 1–5, 2018, doi: 10.1051/e3sconf/20183111010.
[6] N. Junaidi and M. Shaaban, “Big Data Applications in Electric Energy Systems,” 2018 Int. Conf. Comput. Approach Smart Syst. Des. Appl. ICASSDA 2018, p. 94300, 2018, doi: 10.1109/ICASSDA.2018.8477607.
[7] N. Ahmed and K. Mueller, “EnergyScout: A Consumer Oriented Dashboard for Smart Meter Data Analytics,” 2019.
[8] E. Hepifesti and J. Siswanto, “Pengembangan Model Dashboard Kinerja Perusahaan Pemasok Daya Listrik ke Perusahaan,” J. Telemat., vol. 9, no. 1, p. 26, 2014, doi: 10.61769/telematika.v9i1.86.
[9] R. Bento et al., “Innovative Smart Grid Solutions for Network Planning and Access,” no. June, pp. 11–12, 2014.
[10] J. S. Guerrero-Prado, W. Alfonso-Morales, E. Caicedo-Bravo, B. Zayas-Pérez, and A. Espinosa-Reza, “The power of big data and data analytics for AMI data: A case study,” Sensors (Switzerland), vol. 20, no. 11, pp. 1–27, 2020, doi: 10.3390/s20113289.
[11] R. Wickramasuriya, J. Ma, V. Somashekar, P. Perez, and M. Berryman, “SMART Infrastructure Dashboard: A Fusion between Business Intelligence and Geographic Information Systems,” 2014, doi: 10.14453/isngi2013.proc.49.
[12] Y. Arvio, I. B. Sangadji, H. Sikumbang, and M. D. Anjarwati, “Pendekatan Implementasi Model Substractive Clustering Dalam Memetakan Dan Klasifikasi Data Perilaku Konsumen Listrik Tegangan Rendah Studi Kasus : Pelanggan PT PLN (Persero) UP3 Cengkareng,” Petir, vol. 12, no. 2, pp. 251–261, 2019, doi: 10.33322/petir.v12i2.553.
[13] A. Rahim and A. Selao, “Sistem Monitoring Kontrak Pt. Pln Up3 (Unit Pelaksana Pelayanan Pelanggan) Parepare Berbasis Web,” J. Sintaks Log., vol. 3, no. 1, pp. 28–33, 2023, doi: 10.31850/jsilog.v3i1.2091.
[14] M. C. Annosi, F. Brunetta, and L. Peichan, “The impact of digitalization,” How is Digit. Aff ecting Agri-food?, pp. 11–24, 2020, doi: 10.4324/9780429203701-3.
[15] G. E. Asimakopoulou, Y. Papagrigorakis, A. L. Dimeas, P. Aristidou, and N. D. Hatziargyriou, “A review of customer management tools: The energy industry,” Lect. Notes Inst. Comput. Sci. Soc. Telecommun. Eng. LNICST, vol. 54, pp. 64–72, 2011, doi: 10.1007/978-3-642-19322-4_8.
[16] M. A. Komara, A. Y. Salim, and M. Firdaus, “Automated Attendance System for Contract-Based Employees at Purwakarta Communication and Informatics Agency,” Sinkron, vol. 9, no. 2, pp. 709–720, 2025, doi: 10.33395/sinkron.v9i2.14648.
