Optimalisasi Pengelolaan Data Material PT Berkah Anugerah Inti Semesta Melalui Pengembangan Dashboard Inventory dengan Tableau
Keywords:
Inventory, Dashboard, ETL, Tableau, Data ManagementAbstract
Optimal inventory management is essential for companies to ensure that materials are available when needed and to reduce the risk of shortages or overstocking. PT Berkah Anugerah Inti Semesta faces challenges in managing inventory data optimally. This study aims to develop an inventory dashboard using Tableau as a data visualisation tool for the company's inventory management. The research method uses the ETL process to process inventory data from different sources. The processed data is then visualised into an interactive dashboard that displays information about the company's materials. The research results show a summary through the dashboard with a total of 4,119 incoming materials, 3,648 outgoing materials and 471 remaining units. Monthly trends show that activity peaks in August-September. The material with the highest turnover rate is SIKU 50MM X 6M. This inventory dashboard provides an effective solution for improving the efficiency of the company's inventory management. The study recommends the integration of real-time data and predictive analysis for further development.
References
[1] Z. N. Dianto and E. Widati, “Analisis Management Inventory Untuk Menghindari Death Stock Product di TB. Sinar Baru,” J. Ilm. Akunt. Keuang. dan Bisnis, vol. 4, no. 1, 2023.
[2] M. F. Rahman and S. Nursyamsiah, “Pengaruh Praktik Manajemen Persediaan terhadap Kinerja Perusahaan yang Dimediasi oleh Pengetahuan Manajemen Persediaan: Studi Empiris pada Toko Ritel di D.I. Yogyakarta,” Sel. Manaj. J. Mhs. Bisnis Manaj., vol. 02, no. 05, pp. 194–206, 2023, [Online]. Available: https://journal.uii.ac.id/selma/article/view/32947%0Ahttps://journal.uii.ac.id/selma/article/download/32947/16406
[3] D. G. Rambe, D. Febriawan, and F. N. Hasan, “Implementasi Visualisasi Dashboard Business Intelligence Untuk Analisa Data Penumpang KAI Menggunakan Tableau,” J. Penerapan Sist. Inf. (Komputer Manajemen), vol. 4, no. 4, pp. 1134–1147, 2023, [Online]. Available: https://jurnal.umj.ac.id/index.php/semnastek/article/view/2002
[4] W. W. Sihombing, H. Aryadita, and D. S. Rusdianto, “Perancangan Dashboard Untuk Monitoring Dan Evaluasi (Studi Kasus : FILKOM UB),” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 3, no. 1, pp. 434–441, 2019, [Online]. Available: http://j-ptiik.ub.ac.id
[5] G. S. Nurohim, A. Fauzi, M. F. Akbar, and F. F. Wati, “Perancangan Dashboard Untuk Manajemen Penjualan Produk Pada Perusahaan XYZ Dalam Pengambilan Keputusan Bisnis,” JASIKA (Jurnal Sist. Inf. Akuntansi), vol. 04, no. 01, pp. 34–41, 2024, [Online]. Available: http://jurnal.bsi.ac.id/index.php/jasika34
[6] S. Alfeno, Sutrisno, and M. D. Soleman, “Implementasi Dashboard Informasi Sistem Sebagai Model Alat Ukur Tingkat Penjualan PT Sumber Sekar Sejahtera,” J. Sisfotek Glob., vol. 10, no. 1, pp. 1–12, 2020.
[7] A. R. Basar and E. Safira, “Rancang Bangun Dashboard Untuk Monitoring Invetory Barang Pada Perusahaan T-Obenk Kaos Batam,” JR J. Responsive Tek. Inform., vol. 4, no. 2, pp. 51–59, 2020, doi: 10.36352/jr.v4i02.179.
[8] N. L. D. E. Wahyudiari, “Sistem Informasi Inventory Berbasis Web Pada CV Bali Batik,” Infotech J., vol. 5, no. 1, pp. 38–43, 2019.
[9] A. Triwijaya, “Analisis Penerapan Inventory Management Pada Siklus Produksi Untuk Meningkatkan Efisiensi Dan Efektifitas Dalam Mengelola Persediaan CV. X,” Al Qodiri J. Pendidikan, Sos. dan Keagamaan, vol. 20, no. 2, 2022.
[10] R. A. Brahmantyo, J. Wibowo, and V. Nurcahyawati, “Manajemen Persediaan Menggunakan Metode Safety Stock dan Reorder Point,” J. Sains dan Inform., vol. 9, no. 1, pp. 89–99, 2023, doi: 10.34128/jsi.v9i1.431.
[11] D. Januarita and T. Dirgahayu, “Pengembangan Dashboard Information System (DIS),” J. INFOTEL - Inform. Telekomun. Elektron., vol. 7, no. 2, p. 165, 2015, doi: 10.20895/infotel.v7i2.44.
[12] M. Silvana, R. Akbar, and R. Tifani, “Penerapan Dashboard System di Perpustakaan Universitas Andalas Menggunakan Tableau Public,” Semin. Nas. Sains dan Teknol. 2018, no. November, p. 3, 2017, [Online]. Available: https://jurnal.umj.ac.id/index.php/semnastek/article/view/2002
[13] F. Shofiyah and Y. Wirani, “Analisis dan Implementasi Dashboard Monitoring Program Link and Match Perguruan Tinggi Berbasis Google Sheet,” J. Inform. Terpadu, vol. 7, no. 2, pp. 53–61, 2021, doi: 10.54914/jit.v7i2.351.
[14] T. I. Muarif and R. D. Dana, “Implementasi Tableau Untuk Pengembangan Visualisasi Data Pada Aplikasi Open Data Di Diskominfo Kabupaten Cirebon,” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 1, pp. 902–909, 2024, doi: 10.36040/jati.v8i1.8868.
[15] P. R. W. Negoro and R. Imanda, “Implementasi Business Intelligence dengan Tableau untuk Optimasi Pengambilan Keputusan Perusahaan Freight Forwarder,” J. Ilm. KOMPUTASI, vol. 23, no. 3, pp. 301–310, 2024.
Downloads
Published
Issue
Section
License
Copyright (c) 2024 Ubaidillah, Rusindiyanto (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
