Implementasi Media Interaktif Tableau Untuk Pengembangan Visualisasi Data ASN Menggunakan Metode ETL

Authors

  • Nikhlatul Maolah STMIK IKMI Cirebon
  • Bambang Siswoyo STMIK IKMI Cirebon

Keywords:

Visualization, Interactive Media, ETL (Extract, Transform, Load) Tableau, ASN

Abstract

The State Civil Apparatus is a profession for Civil Servants (PNS) and government employees with work agreements who serve government agencies who are appointed by civil service development officials and entrusted with other state duties and are paid based on statutory regulations and provide professional and quality public services. However, the large amount of data from the number of State Civil Apparatus in the Cirebon district government office makes it difficult for decision-makers to understand and analyze the data. This study aims to develop data visualization for State Civil Apparatus (ASN) in sub-district offices through the application of interactive media Tableau using the ETL (Extract, Transform, Load) method. The extract stage is the data collection stage from the Cirebon district communications and information services office in the form of State Civil Apparatus (ASN) data, spatial group, education, age and religion. Transform is the process of changing data from a previous format to the desired format. At this stage, the data relationship process is carried out to adjust several types of variables. Load is the final process that functions to enter the data into the final target, namely into the Source data in Tableau. The aim of this research is to design ASN data visualization using the interactive media Tableau. Data visualization displays some visual data in the form of bar graphs. With the availability of information in data visualization, it can make it easier for stakeholders to make decisions. In this era of digitalization, the need for efficient and transparent data processing has become very important, especially in government agencies. Utilizing Tableau as an interactive data visualization tool and exploring a more informative dashboard presentation

References

A. Rahman and R. Bakri, “Penataan Pengelolaan Aparatur Sipil Negara (ASN) melalui Dynamic Governance,” J. Konstituen, vol. 1, no. 1, pp. 1–22, 2019, doi: 10.33701/jk.v1i1.309.

R. Y. Sifa, “Visualisasi Data Pengunjung Dan Peminjaman Buku Di Perpustakaan Daerah Menggunakan Power Bi,” J. Sist. Inf., vol. 2, no. 3, pp. 142–151, 2024.

M. Ariandi and S. Rahma Puteri, “Analisis Visualisasi Data Kecamatan Kertapati menggunakan Tableau Public,” JUPITER (Jurnal Penelit. Ilmu dan Tek. Komputer), vol. 14, no. 2, pp. 366–373, 2022, [Online]. Available: https://jurnal.polsri.ac.id/index.php/jupiter/article/view/5141

A. A. Novany, D. Hartama, M. R. Lubis, H. S. Tambunan, and I. Syajidan, “Analisa Visualisasi Data Perkembangan Covid-19 Menggunakan Tableau Big Data Dengan Metode Forecasting,” Pros. Semin. Nas. Teknol. Komput. dan Sains, vol. 1, no. 1, pp. 631–639, 2023, [Online]. Available: https://covid19.sumutprov.go.id/.

S. Angreini and E. Supratman, “Visualisasi Data Lokasi Rawan Bencana Di Provinsi Sumatera Selatan Menggunakan Tableau,” J. Nas. Ilmu Komput., vol. 2, no. 2, pp. 135–147, 2021, doi: 10.47747/jurnalnik.v2i2.528.

S. H. A. El-Sappagh, A. M. A. Hendawi, and A. H. El Bastawissy, “A proposed model for data warehouse ETL processes,” J. King Saud Univ. - Comput. Inf. Sci., vol. 23, no. 2, pp. 91–104, 2011, doi: 10.1016/j.jksuci.2011.05.005.

A. S. Wibowo and A. Andri, “Dashboard Business Intelligence Vusialisasi Data Akreditasi Sekolah Pada SMP Negeri 1 Sembawa,” J. Nas. Ilmu Komput., vol. 2, no. 4, pp. 249–256, 2021, doi: 10.47747/jurnalnik.v2i4.536.

J. R. Almeida, A. Pazos, and J. L. Oliveira, “BIcenter-AD: Harmonising Alzheimer’s Disease cohorts using a common ETL tool,” Informatics Med. Unlocked, vol. 35, no. July, p. 101133, 2022, doi: 10.1016/j.imu.2022.101133.

V. S. Silva, L. Matas, T. Moreira, and W. C. Segundo, “An ETL strategy for integrating the la Referencia platform and VIVO for the Brazilian CRIS,” Procedia Comput. Sci., vol. 211, no. C, pp. 111–117, 2022, doi: 10.1016/j.procs.2022.10.182.

Downloads

Published

2024-10-27

How to Cite

Nikhlatul Maolah, & Bambang Siswoyo. (2024). Implementasi Media Interaktif Tableau Untuk Pengembangan Visualisasi Data ASN Menggunakan Metode ETL. Prosiding SISFOTEK, 8(1), 419 - 426. Retrieved from http://seminar.iaii.or.id/index.php/SISFOTEK/article/view/525

Issue

Section

Sistem Informasi dan Teknologi