Perancangan Dashboard Visualisasi Data Key Performance Indicator (KPI) Menggunakan Looker Data Studio Studi Kasus PT. Sicepat Ekspres
Keywords:
Data Visualization, Key Performance Indicators, Looker Data Studio, Google Data Studio, Google Sheets, Sicepat Ekspres, It Helpdesk, Sentiment Analysis, Data Analyst.Abstract
At PT. Sicepat Ekspres KPI (Key Performance Indicator) system and mechanism have not been formed in a structured and systematic manner, so it is not flexible in conducting data analysis. With the KPI dashboard information find out the performance of each member of the IT Helpdesk team. Based on the Key Performance Indicators (KPI), information on the results of the decision will automatically appear whether members of the IT Helpdesk team have good performance or not. The method used in this study is quantitative because the research is descriptive and focuses on data analysis and data visualization. The results of the complaint tickets handled by the IT helpdesk team from November 6, 2022, to November 13 2022 were 2,477 tickets, and 275 tickets were escalated. complaints are on the "MAPPING TMS" ticket tag, the most complaint tickets that enter via the WhatsApp channel. The average response time for all agents is 7 minutes 39 seconds. The average resolution time for all agents is 1 hour 16 minutes 24 seconds. a high percentage of tickets was obtained by an agent named Yuda with a CNT of 351 tickets with a percentage of 175.5%. And the total tickets obtained and a low percentage of tickets were obtained by an agent named Alif with CNT of 70 tickets with a percentage of 116.67%. The highest percentage is a positive sentiment as much as 89.8%, then neutral sentiment as much as 8.1%, and the least percentage is a negative sentiment as much as 2.1%, out of a total of 7,939 conversations. The most ticket tags are MAPPING TMS with a positive sentiment of 224 tickets, neutral sentiment of 51 tickets, and negative sentiment of 19 tickets, while the lowest ticket tag is UMS with a positive sentiment of 15 tickets, neutral sentiment of 2 tickets, negative sentiment 2 tickets. The agent name that received the most sentiment from users was named Yuda with a total of 1,099 conversation sentiments which included 987 positive feedback sentiments, 97 conversation neutral feedback sentiments, and 15 negative feedback sentiment conversations. Meanwhile, the agent who received the least sentiment from the user was named Herdian with a total of 150 conversation sentiments which included 132 positive feedback sentiments, 14 neutral feedback sentiments, and 4 negative feedback sentiments. In conclusion, Looker Data Studio can display the Key Performance Indicator (KPI) dashboard online and is easy to share with just the generated link. suggestions for the Looker Data Studio Dashboard KPI program can be developed to display map data or GeoMaps for PT. Sicepat Ekspres branch locations.
References
Amazon. (2023, January 18). Apa itu Analisis Sentimen. Https://Aws.Amazon.Com/Id/WhatIs/Sentiment-Analysis/.
Banerjee, J., & Buoti, C. (2012). General specifications of KPIs. International Telecomunication Union.
Baykasoglu, A., Atalay, Z. N., & Golcuk, I. (2019). Analysis of key performance indicators in a manufacturing plant via fuzzy cognitive maps. 2019 Innovations in Intelligent Systems and Applications Conference (ASYU), 1–4. https://doi.org/10.1109/ASYU48272.2019.8946387
Biro Administrasi Mutu Akademik Dan Informasi Universitas Medan Area. (2022, August 2). Apa itu Analisis Data : Pengertian, Jenis-jenis, Fungsi, dan Contohnya. Https://Bamai.Uma.Ac.Id/2022/08/02/Apa-Itu-Analisis-Data-Pengertian-Jenis-Jenis-Fungsi-Dan-Contohnya/.
Brice Praslicka. (2023, January 13). Data Discrepancies in GA4 and Looker Studio. Https://Www.Seerinteractive.Com/Insights/Data-Discrepancies-Ga4-Looker-Studio.
Busrah, Z., & Pathuddin, H. (2021). Ethnomathematics: Modelling the volume of solid of revolution at Buginese and Makassarese traditional foods. JRAMathEdu (Journal of Research and Advances in Mathematics Education), 6(4), 331–351.
https://doi.org/10.23917/jramathedu.v6i4.15050
Caecilia Ruli, & Heru Kristanto. (2021). IMPLEMENTATION OF BALANCE SCORECARD AND KEY PERFORMANCE INDICATOR ON CUSTOMER SERVICE EMPLOYEE PRODUCTIVITY. EUREKA: Social and Humanitie, 26–32.
Desy Apriani, Muhamad Aan, & Widanto Eka Saputra. (2022). Data Visualization Using Google Data Studio. International Journal of Cyber and IT Service Management (IJCITSM), 11–19.
Gabcanova, I. (2012). Human Resources Key Performance Indicators. Journal of Competitiveness, 4(1), 117–128. https://doi.org/10.7441/joc.2012.01.09
Google. (2023). Welcome to Looker Studio. Https://Support.Google.Com/LookerStudio/Answer/6283323?Hl=en.
Google Cloud Tech. (2022). Looker Studio: Business Insights Visualizations. Diakses Pada 21 November 2022. Https://Cloud.Google.Com/Looker-Studio.
Google Sheets. (2023). Ambil keputusan berdasarkan data di Google Sheets. Https://Www.Google.Com/Intl/Id/Sheets/About/.
Jessalynne Madden. (2020, February). 10 Qualities Every Help Desk Technician Should Have. Comptia.Org.
Jurnal Enterpreneur. (n.d.). Mengenal KPI (Key Performance Indicator) Perusahaan. Https://Www.Jurnal.Id/Id/Blog/Mengenal-Kpi-Key-Performance-Indicator/.
Monsivais, P., Francis, O., Lovelace, R., Chang, M., Strachan, E., & Burgoine, T. (2018). Data visualisation to support obesity policy: case studies of data tools for planning and transport policy in the UK. International Journal of Obesity, 42(12), 1977–1986.
https://doi.org/10.1038/s41366-018-0243-6
Nizar Rabbi Radliya. (2016). DATA MINING.
Njunge, & Christopher. (2022). Data Analysis and Visualization with Google Data Studio. Association for Information Systems AIS Electronic Library (AISeL), 1–5.
Parmenter, & David. (2007). Key Performance Indicators. New Jersey: John Wiley & Sons.
Pervaiz Akhtar, Jedrzej George Frynas, & Kamel Mellahi. (2019). Big Data-Savvy Teams’ Skills, Big. British Journal of Management, 252–271.
Prakoso Dimas. Wawancara. 1 Desember. (2022). Interview.
Rony Setiawan. (2021, November 17). Black Box Testing Untuk Menguji Perangkat Lunak. Https://Www.Dicoding.Com/Blog/Black-Box-Testing/.
Santika, I. G. N. (2020). Optimalisasi Peran Keluarga Dalam Menghadapi Persoalan Covid- 19. Sebuah Kajian Literatur. Jurnal Ilmiah Ilmu Sosial, 6(2), 127–137.
Sicepat Ekspres. (2020). https://www.linkedin.com/company/sicepat-ekspres-indonesia/. Diakses Pada 17, September, 2022.
Staff RevoU. (n.d.). Panduan Lengkap Data Analytics di Asia Tenggara bagi Pemula. Https://Journal.Revou.Co/Panduan-Data-Analytics/.
Tri Aristi Saputri, Sita Muharni, Andreas Perdana, & Sulistiyanto. (2021). Pemanfaatan Google Data Studio Untuk Visualisasi Data Bagi Kepala Gudang UD Salim Abadi. Ilmu Komputer Untuk Masyarakat, 67–72.
Warren. (2011). Key performance indicators (KPI) – definition and action : Integrating KPIs into your company’s strategy. ATI.
Yance Gusnadi, & Aditiya Hermawan. (2020). Designing Employee Performance Monitoring Dashboard. Bit-Tech, 82–88. island,
Yanto, Livneh, B., & Rajagopalan, B. (2017). Development of a gridded meteorological dataset over Java Indonesia 1985–2014.
