Perancangan Data Mart Penjualan Pada PT. XYZ
Abstract
Di era digital, pengelolaan data penjualan menjadi vital bagi perusahaan dalam menghadapi dinamika pasar dan meningkatkan daya saing. Penelitian ini bertujuan merancang data mart penjualan di PT. XYZ untuk mengintegrasikan data penjualan sekaligus menyediakan sistem informasi yang mendukung pengambilan keputusan. Data mart berfungsi sebagai repositori terpusat yang memungkinkan penyajian informasi secara real-time, mempercepat pengumpulan data, serta meningkatkan aksesibilitas dan kecepatan analisis. Metode yang digunakan adalah Kimball Nine-Step Methodology, yang meliputi identifikasi proses bisnis, perancangan skema bintang, serta proses ETL (Extract, Transform, Load) menggunakan Pentaho Data Integration dan Microsoft SQL Server Management Studio. Pengumpulan data dilakukan dengan menganalisis data penjualan tahun 2022-2023. Hasil implementasi menunjukkan peningkatan efisiensi dalam pengelolaan data penjualan, yang mendukung PT. XYZ dalam mencapai efisiensi operasional dan memperkuat proses pengambilan keputusan.
Kata Kunci: Data Mart, Nine-Step Kimball, Extract Transform Load (ETL), Penjualan
References
Belov, V., Kosenkov, A. N., & Nikulchev, E. (2021). Experimental characteristics study of data storage formats for data marts development within data lakes. Applied Sciences (Switzerland), 11(18). https://doi.org/10.3390/app11188651
Chatterjee, S., Chaudhuri, R., & Vrontis, D. (2022). Big data analytics in strategic sales performance: mediating role of CRM capability and moderating role of leadership support. EuroMed Journal of Business, 17(3), 295–311. https://doi.org/10.1108/EMJB-07-2021-0105
Coté, C., Lah, M., & Saitakhmetova, M. (2020). ETL with Azure Cookbook: Practical recipes for building modern ETL solutions to load and transform data from any source. Packt Publishing Ltd.
Dahr, J. M., Hamoud, A. K., Najm, I. A., & Ahmed, M. I. (2022). Implementing sales decision support system using data mart based on olap, kpi, and data mining approaches. Journal of engineering science and technology, 17(1), 275–293.
Gaol, F. L., Abdillah, L., & Matsuo, T. (2020). Adoption of Business Intelligence to Support Cost Accounting Based Financial Systems-Case Study of XYZ Company. Open Engineering, 11(1), 14–28. https://doi.org/10.1515/eng-2021-0002
Hamoud, A. K., Hussein, M. K., Alhilfi, Z., & Sabr, R. H. (2021). Implementing data-driven decision support system based on independent educational data mart. International Journal of Electrical and Computer Engineering, 11(6), 5301–5314. https://doi.org/10.11591/ijece.v11i6.pp5301-5314
Kimball, R., & Ross, M. (2013). The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons.
McCausland, T. (2021). Digital Transformation. Dalam Research Technology Management (Vol. 64, Nomor 6, hlm. 64–67). Routledge. https://doi.org/10.1080/08956308.2021.1974783
Nambiar, A., & Mundra, D. (2022). An Overview of Data Warehouse and Data Lake in Modern Enterprise Data Management. Dalam Big Data and Cognitive Computing (Vol. 6, Nomor 4). MDPI. https://doi.org/10.3390/bdcc6040132
Ndyanabo, A., Footer, K., Ahmed, T., Glogowski, A., Whalen, C., Ssekasanvu, J., Ssentongo, L., Lutalo, T., Nalugoda, F., Ha, G. K., & Rosenthal, A. (2022). Establishing a centralized data mart from the Rakai community cohort study to improve HIV research in Rakai, Uganda. JAMIA Open, 5(2). https://doi.org/10.1093/jamiaopen/ooac032
Priono, T. R., Purnomo, W., & Setiawan, N. Y. (2021). Pengembangan Data Warehouse menggunakan Metode Kimball (Studi Kasus: Ekspor & Impor Fauna dan Flora Hias Air Laut) (Vol. 5, Nomor 8). http://j-ptiik.ub.ac.id
Setiyani, L., Tjandra, E., Studi Sistem Informasi, P., & Rosma Karawang, S. (2020). PERANCANGAN DAN IMPLEMENTASI DATA WAREHOUSE UNTUK PERPUSTAKAAN KAMPUS (STUDI KASUS : STMIK ROSMA KARAWANG) DESIGN AND IMPLEMENTATION DATA WAREHOUSE FOR CAMPUS (CASE STUDY: STMIK ROSMA KARAWANG). Dalam IJIS Indonesian Journal on Information System.
Slamet Riyadi No, J. (2020). Warehouse Data System Analysis PT. Kanaan Global Indonesia 1 st Tino Feri Efendi, 2 nd Mutiya Krisanty 12 Institut Teknologi Bisnis AAS Indonesia Surakarta. Dalam International Journal of Computer and Information System (IJCIS) Peer Reviewed-International Journal (Vol. 01, Nomor 03). https://ijcis.net/index.php/ijcis/index
Sugiarto, D., & Siswanto, T. (2021). Perancangan Data Warehouse Harga Pangan di Wilayah Perumda Pasar Jaya. Explore: Jurnal Sistem Informasi dan Telematika, 12(1), 47–55.
Warnars, H. L. H. S., Warnars, L. S., Ramadhan, A., Siswanto, T., & Doucet, A. (2024). Data Warehouse Design for Firefighters Operational at the DKI Jakarta Fire Department. TEM Journal, 13(1), 365–376. https://doi.org/10.18421/TEM131-38
Copyright (c) 2024 Jerrico Alan Mok, Dedi Trisnawarman
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
