Perancangan Dashboard Penjualan Pakaian di Toko Cleo dengan Power BI
Abstract
The dashboard has become an essential tool in supporting strategic decision-making in the retail sector, such as at Toko Cleo, with the primary goal of understanding sales performance and consumer purchasing trends. This research aims to design an interactive dashboard that presents sales data to support data-driven decision-making at Toko Cleo. The methodology employed includes the nine-step Kimball approach for dashboard design, along with the ETL (Extract, Transform, Load) process to process sales data from 2021 to 2023, and Power BI for data visualization. The testing results show that this dashboard successfully provides in-depth analysis based on product categories and time periods, improving accuracy and speeding up the decision-making process at Toko Cleo, thus maximizing operational effectiveness in the business.
Kata kunci: Dashboard; Clothing Store; Power Bi
Abstrak
Dashboard menjadi alat penting dalam mendukung pengambilan keputusan strategis di sektor ritel, seperti Toko Cleo, dengan tujuan utama untuk memahami performa penjualan dan tren pembelian konsumen. Penelitian ini bertujuan merancang dashboard interaktif yang menyajikan data penjualan untuk mendukung keputusan berbasis data di Toko Cleo. Metode yang digunakan mencakup pendekatan sembilan langkah Kimball dalam perancangan dashboard, serta proses ETL (Extract, Transform, Load) untuk pengolahan data penjualan dari 2021 hingga 2023, dan visualisasi data menggunakan Power BI. Hasil pengujian menunjukkan bahwa dashboard ini berhasil menyediakan analisis mendalam berdasarkan kategori produk dan periode waktu, meningkatkan akurasi, serta mempercepat proses pengambilan keputusan di Toko Cleo, sehingga memaksimalkan efektivitas operasional bisnis.
Keywords
References
T. Jap, & J. Pér, "Preliminary investigation on the effectiveness of a thinking skill training in Indonesia: 'Thinking skills training with digital technology,'" Journal of Psychological and Educational Research, vol. 23, no. 2, pp. 41-53, Nov. 2015.
Kusnardi, H., Beng, J. T., & Sutrisno, T. (2023). Dashboard design for predicting the investment value of houses at region Y using database analysis through the DES method. AIP Conference Proceedings, vol. 2680, no. 1, p. 20141. https://doi.org/10.1063/5.0127641
E. D. Madyatmadja, A. S. Putri, S. S. Hiqna, and W. Pratita, “Data dashboard for decision support systems for intrapreneurship in a company,” Advances in Science, Technology and Engineering Systems, vol. 4, no. 6, pp. 177–182, 2019, doi: 10.25046/aj040622.
Nazuli, M. F., Utami, N. A., & Putri, S. R. (2021). Information Dashboard Penjualan Produk Fashion Muslim di DKI Jakarta Sebagai Pendukung Strategi Pemulihan Ekonomi Nasional. Seminar Nasional Official Statistics, vol. 2021, no. 1. Pp. 1025–1035. https://doi.org/10.34123/semnasoffstat.v2021i1.1009
A. P. Ayuningsih, N. Y. Setiawan, & S. H. Wijoyo, "Analisis prediksi penjualan obat hewan menggunakan metode regresi linier melalui visualisasi dashboard (Studi Kasus PT. Satwa Jawa Jaya)," Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 6, no. 4, pp. 1568-1575, Apr. 2022. [Online]. Tersedia: http://j-ptiik.ub.ac.id.
D. H. Jayadinata, A.T. Pratama, and T. D. Sofianti, "Development of performance monitoring dashboard for product packaging manufacturer by using waterfall methodology," Jurnal Ilmiah Teknik Industri, vol. 23, no. 1, pp. 151–161, Jun. 2024, doi: 10.23917/jiti.v23i1.2551.
R. Sandi and D. Trisnawarman, "Desain dashboard untuk analisis harga pangan di Indonesia: Dashboard design for food price analysis in Indonesia," Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 3, pp. 151–161, 2024.
F.Y. Alfiansyah, & D. Arisandi, Perancangan DashPerancangan Dashboard Monitoring Status Gizi Balita di Puskesmas Sukanagalihoard Monitoring Status Gizi Balita di Puskesmas Sukangalih. Jutisi: Jurnal Ilmiah Teknik Informatika Dan Sistem Informasi, vol. 12, no. 3, pp. 1579-1589, 2023
D. I. Anggraini, H. T. Sibero, M. Yusran, and A. Fauzi, “Pencegahan Dan Deteksi Dini Penyakit Kondiloma Akuminata Pada Human Immunodefficiency Virus/Acquired Immunodefficiency Syndrome,” Jambura Journal of Health Sciences and Research, vol. 3, no. 2, pp. 314-324, 2021, [Online]. Available: http://ejurnal.ung.ac.id/index.php/jjhsr/index
A. Mulyani, Visualisasi Data Ticketing Servicedesk Dengan Dashboard Pada Pt Brantas Abipraya (Persero) Ticketing Servicedesk Data Visualization with Dashboard at PT Brantas Abipraya (Persero),” Journal of Information System, Applied, Management, Accounting and Research, vol. 7, no. 2, pp. 289–300, 2023, doi: 10.52362/jisamar.v7i2.1074.
T. Purwani, A. Wahyuni, A.P. Wicaksono, & H.D. Charunia, Dashboard Untuk Visualisasi Data Penjualan Barang Pada Toko Puppets Skateboard Semarang Menggunakan Tableau. KOMPUTAKI, vol. 7, no. 1, pp. 69-81, 2021.
V. Prischila, D. Trisnawarman, & J. Hendryli, “Dashboard Penjualan Dan Pengiklanan Tokopedia Pada Cbp General. Computatio : Journal of Computer Science and Information Systems, vol. 5, no. 2, pp. 73-84, 2022. https://doi.org/10.24912/computatio.v5i2.16561
M. Anis, “Perancangan Sistem Business Intelligence Menggunakan Olap Sebagai Decision Financial Support Berbasis Web dengan Metode Waterfall. Jurnal Sosial Teknologi, vol. 10, no. 1, pp. 13-22, 2021. https://doi.org/10.59188/jurnalsostech.v1i10.217
R. Kimball and M.Ross, “The Data Warehouse Toolkit : The Definitive Guide to Dimensional Modeling, 3rd Edition” John Wiley & Sons, Inc., Indianapolis, 2013.
R. Kimball and J. Caserta, “The Data Warehouse ETL Toolkit,” Wiley Publishing, Inc.
Indianapolis, 2004.
I. P. A. E. Pratama and I. M. S. Raharja, “Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market,” International Journal of Advances in Data and Information Systems, vol. 4, no. 2, pp. 135–144, Sep. 2023, doi: 10.25008/ijadis.v4i2.1301.
How To Cite This :
Refbacks
- There are currently no refbacks.
