DATA MART DESIGN FOR Y CLOTHING STORE SALES

Authors

Angeline Carolina Wijaya Universitas Tarumanagara, Jakarta, Indonesia
Jap Tji Beng Universitas Tarumanagara
Desi Arisandi Universitas Tarumanagara, Jakarta, Indonesia
Sri Tiatri Universitas Tarumanagara, Jakarta, Indonesia
Vienchenzia Oeyta Dwitama Dinatha INTI International University, Malaysia
Rahmiyana Nurkholiza Universitas Tarumanagara, Jakarta, Indonesia
Fasia Meta Sefira Universitas Tarumanagara, Jakarta, Indonesia

DOI:

Abstract

The data mart design for Y Clothing store aims to integrate scattered sales data to simplify analysis and speed up business decision making. Using the Kimball Nine-Step method and ETL process, sales transaction data from 2019 to 2023 is managed in a star schema. As a result, these data marts enable faster and more accurate analysis, identifying customer purchasing patterns, sales trends and promotional effectiveness. Implementation of this data mart increased inventory management efficiency by 15% and reduced sales report generation time from hours to minutes. However, challenges such as significant resource allocation for initial implementation and a learning curve for employees slowed down the maximum benefit gain somewhat. However, overall, these data marts contribute greatly to improved business decisions and more effective sales strategies.

Keywords: Data Mart, Y Clothing Store, Kimball Nine-Step Method, ETL Process, Star Schema.

References

Atmojo, W. T., Ocktavia, S., & Ayunda, A. T. (2024). Implementasi Nine Step Methodology Dalam Perancangan Data Warehouse. Jurnal Teknologi Informasi Dan Komunikasi (TIKomSiN), 12(1), 18-25.

Butar Butar, F. A. A., et al. (2022). Seminar Nasional Fakultas Teknik Universitas Malikussaleh Tahun 2022 [Conference proceedings]. Universitas Malikussaleh.

Kimball, R., & Caserta, J. (2004). The data warehouse ETL toolkit. John Wiley & Sons.

Leovin, A., Beng, J. T., & Dewayani, E. (2020, December). Business to business e-commerce sales system using web-based quotation: A case study on company x. In IOP Conference Series: Materials Science and Engineering (Vol. 1007, No. 1, p. 012156). IOP Publishing.

Maswanganyi, N. G., Fumani, N. M., Khoza, J. K., Thango, B. A., & Matshaka, L. (2024). Evaluating the impact of database and data warehouse technologies on organizational performance: A systematic review.

Melladia, M., Annisa, I. F., & Karnefo, S. K. (2024). Perancangan Data Mart Analisis Data Nilai Siswa pada SMAN 2 Tebo. JUMINTAL: Jurnal Manajemen Informatika dan Bisnis Digital, 3(1), 18-30.

Pratama, I. P. A. E., & Raharja, I. M. S. (2023). 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, 4(2), 135-144.

Ramadhan, A. D., & Wirawan, R. (2023, December). Sistem Informasi Penjualan dan Pembelian Pada Toko Baju Kania Jaya. In Prosiding Seminar Nasional Mahasiswa Bidang Ilmu Komputer dan Aplikasinya (Vol. 4, No. 2, pp. 233-245).

Salsabila, T. M., Caroline, A., Marcydiaz, A. H., Trisnawarman, D., & Beng, J. T. (2024). Perancangan data mart untuk manajemen data penjualan pada kedai kopi X di Jakarta [Data mart design for sales data management at coffee shop X in Jakarta]. Journal of Information Technology and Computer Science (INTECOMS), 7(6). https://www.datachannel.co/blogs/what-is-etl

Syaputra, M. D., Nazir, A., Gusti, S. K., Sanjaya, S., & Syafria, F. (2022). Data warehouse design for sales transactions on CV. Sumber Tirta Anugerah. Jurnal CoreIT: Jurnal Hasil Penelitian Ilmu Komputer dan Teknologi Informasi, 8(2), 88. https://doi.org/10.24014/coreit.v8i2.19800

Wijaya, A. C., Marcydiaz, A. H., Fitriya, F. N., Arisandi, D., & Beng, J. T. (2024). Perancangan Sistem Dashboard Penjualan Berbasis Web untuk Toko Online Caro Cara. Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, 13(3).

Wu, L., Li, Z., & AbouRizk, S. (2022). Automating common data integration for improved data-driven decision-support system in industrial construction. Journal of Computing in Civil Engineering, 36(2), 04021037.