Implementation of Business Intelligence for Material Deviation Analysis Using Looker Studio (Case Study: PT Telkom Akses Bengkulu)
DOI:
https://doi.org/10.70656/ijcse.v3i01.936Keywords:
Business Intelligence, Data Cleaning, Looker Studio, Data Visualization, Deviation AnalysisAbstract
This study is motivated by challenges in managing data for fiber optic network construction projects, which are stored in multiple separate files and are not yet integrated, making analysis and monitoring inefficient. In addition, discrepancies between planning data and actual field data affect both work volume and project costs. This research aims to integrate project data into a structured dataset, analyze deviations between planning and actual data, and present the results through interactive visualization. The study employs a descriptive analysis approach within a business intelligence framework, including data cleaning, transformation, and aggregation using Microsoft Excel, followed by visualization using Looker Studio. The dataset consists of fiber optic project data from 2024–2025, including attributes such as designators, volume, material costs, service costs, and total costs. The results indicate significant deviations between planning and actual data in both volume and cost for several work items. The interactive dashboard effectively presents these deviations, improving data clarity and facilitating monitoring and analysis. This study contributes to enhancing the efficiency of project data processing and supports data-driven decision-making through the implementation of an interactive and user-friendly dashboard.
Downloads
References
[1] Nurul Aini and Muhammad Irwan Padli Nasution, "ACCURACY OF INFORMATION DATA QUALITY IN MANAGEMENT SYSTEMS," JOURNAL OF MANAGEMENT AND ECONOMICS, vol. 2, no. 1, pp. 40–50, Dec.
2024, doi: 10.61722/jrme.v2i1.3259.
[2] D. L. Halim, N. Calim, A. Tamalate, and W. Felicia, "Business Performance Evaluation Based on Business Intelligence Dashboard at UD. Central," JDMIS: Journal of Data Mining and Information Systems, vol. 3, no. 2,
pp. 54–63, 2025, doi: 10.54259/jdmis.v3i2.4216.
[3] I. Purnama, Y. Setiani, and F. A. N. Wibisono, "Data Analysis and Visualization Using Looker Studio on the New York City Property Sales Dataset," Journal of Minfo Polgan, vol. 13, no. 2, pp. 2222–2234, Jan. 2025, doi: 10.33395/jmp.v13i2.14421.
[4] T. N. Khasanah, N. Hanindya Putri, S. Amalia, R. P. Rahmadani, B. Sujarwo, and M. Arifin, "IMPLEMENTATION OF BUSINESS INTELLIGENCE DASHBOARD USING LOOKER STUDIO TO EVALUATE ELECTRONIC SALES PERFORMANCE," Journal of Information Systems (TEKNOFILE), vol. 3, pp. 940–945, 2025.
[5] R. Oktavia, "Application of Business Intelligence for Analysis of User Satisfaction and Complaints of Looker Studio-Based Internet Star.net Services," Karapan Network Journal, vol. 2, no. 01, 2026, doi:
10.20473/KNJ.2.01.65-74.
[6] S. Hidayatullah, L. A. Nissa, C. A. Setiawan, and S. Supriyatna, "Design of an Interactive Dashboard-Based Project Performance Monitoring Information System," Multidisciplinary Scientific Journal, vol. 1, no. 2, 2025.
[7] Z. Ardian and W. N. Ainy, "Analysis and Visualization of Monitoring Data Using Google Looker Studio," Journal of Informatics and Computer Science, vol. 11, no. 1, 2025.
[8] A. Yulianto, "Optimizing Data Warehouse Performance with Data Mart," Remik: Research and E-Journal of Computer Informatics Management, vol. 8, no. 4, 2024, doi: 10.33395/remik.v8i4.14152.
[9] A. F. Amanda and B. Waspodo, “Implementation of Extract, Transform, Load (ETL) Method for Sales Data Visualization Using Google Looker Studio,” Scientific Journal of Sisfo Media, vol. 19, no. 2, pp. 124–134, Oct.
2025, doi: 10.33998/mediasisfo.2025.19.2.2547.
[10] Y. Oslan and D. H. Kristanto, "ETL (EXTRACT TRANSFORMATION LOADING) DATA WAREHOUSE PROCESS TO IMPROVE BIODATA PERFORMANCE IN PRESENTING STUDENT PROFILES FROM THE
DIMENSION OF SCHOOL ORIGIN Case Study: UKDW Student Biodata," vol. 3, no. 1, 2019.
[11] E. P. Wicaksono and Paniran, "Visualization of Public Opinion Data Using Looker Studio (Case Study of the 2024 Indonesian Presidential Election)," Journal of Scientific Informatics, vol. 12, no. 2, pp. 89–95, 2024, doi: 10.33884/jif.v12i02.8918.



.png)
.png)



.png)
.png
)


