PERANCANGAN DATA MART PELUANG PROYEK MENGGUNAKAN METODOLOGI NINE-STEP KIMBALL PADA PERUSAHAAN RISET “R”

Tiara Zahro; Jap Tji Beng; Dedi Trisnawarman; Sri Tiatri; Rahmiyana Nurkholiza

doi:10.31539/kqtmey20

Authors

Tiara Zahro Universitas Tarumanagara
Jap Tji Beng Universitas Tarumanagara
Dedi Trisnawarman Universitas Tarumanagara
Sri Tiatri Universitas Tarumanagara
Rahmiyana Nurkholiza Universitas Tarumanagara

DOI:

https://doi.org/10.31539/kqtmey20

Abstract

Penerapan metodologi Nine-Step Kimball dalam perancangan data mart peluang proyek pada Perusahaan Riset “R” terbukti efektif dalam mengintegrasikan data internal dan mendukung analisis operasional yang komprehensif. Melalui tahapan sistematis mulai dari pemilihan proses bisnis hingga desain ETL, penelitian ini berhasil menghasilkan model star schema yang memfasilitasi analisis berdasarkan dimensi waktu, kategori riset, klien, serta nilai proyek. Secara fungsional, data mart ini meningkatkan efisiensi pelaporan dan konsistensi informasi antar departemen, sementara secara strategis memberikan dasar bagi penerapan Business Intelligence dan analitik prediktif di masa depan. Penelitian ini menegaskan relevansi metodologi Kimball tidak hanya untuk sektor komersial, tetapi juga dalam konteks lembaga riset. Model ini dapat dikembangkan lebih lanjut melalui integrasi dengan dashboard analytics dan machine learning guna memperkuat proses pengambilan keputusan berbasis data.

Kata kunci: Data Mart, Nine-Step Kimball, Peluang Proyek, Business Intelligence, Integrasi Data

References

Awan, U., Shamim, S., Khan, Z., Zia, N. U., Shariq, S. M., & Khan, M. N. (2021). Big data analytics capability and decision-making: The role of data-driven insight on circular economy performance. Technological Forecasting and Social Change, 168, 120766. https://doi.org/10.1016/j.techfore.2021.120766

Corr, L., & Stagnitto, J. (2014). Agile data warehouse design : collaborative dimensional modeling, from whiteboard to star schema. DecisionOne Press.

Dimara, E., Zhang, H., Tory, M., & Franconeri, S. (2022). The Unmet Data Visualization Needs of Decision Makers Within Organizations. IEEE Transactions on Visualization and Computer Graphics, 28(12), 4101–4112. https://doi.org/10.1109/TVCG.2021.3074023

Golfarelli, M., & Rizzi, S. (2009). Data warehouse design : modern principles and methodologies. McGraw-Hill.

Hevner, M, P., & Ram. (2004). Design Science in Information Systems Research. MIS Quarterly, 28(1), 75. https://doi.org/10.2307/25148625

Joseph, J., & Gaba, V. (2020). Organizational Structure, Information Processing, and Decision-Making: A Retrospective and Road Map for Research. Academy of Management Annals, 14(1), 267–302. https://doi.org/10.5465/annals.2017.0103

Osaysa, K. E. (2022). IMPROVING THE QUALITY OF MARKETING ANALYTICS SYSTEMS. International Journal for Quality Research, 16(1), 119–132. https://doi.org/10.24874/IJQR16.01-08

Kimball, R., & Caserta, J. (2011). The Data WarehouseETL Toolkit : Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. John Wiley & Sons, Inc.

Kimball, R., & Margy R. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling Third Edition. Wiley.

Korherr, P., Kanbach, D. K., Kraus, S., & Jones, P. (2023). The role of management in fostering analytics: the shift from intuition to analytics-based decision-making. Journal of Decision Systems, 32(3), 600–616. https://doi.org/10.1080/12460125.2022.2062848

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.

Limbor, E. G., Putri, T. A., Qadriah, S. A. R., Arisandi, D., & Beng, J. T. (2024). Perancangan Dashboard Penjualan Pakaian di Toko Cleo dengan Power BI. Jutisi : Jurnal Ilmiah Teknik Informatika Dan Sistem Informasi, 13(3). https://doi.org/10.35889/jutisi.v13i3.2383

Ling, G. H. T., Leng, P. C., Rusli, N., & Ho, W. S. (2021). A DSR Methodology for Conceptual Solution Development of Public Open Space Governance. Journal of Regional and City Planning, 32(1), 15–35. https://doi.org/10.5614/jpwk.2021.32.1.2

Mumtaz, J. A., Komariansyah, K. K., Pratama, R., Gumelar, M. G., Holik, W., Mindara, G. P., & Wicaksono, A. (2025). Pembuatan Website UpSite dengan Integrasi Fitur Business Intelligence Menggunakan Metode Prototyping. Techno.Com, 24(2), 566–581. https://doi.org/10.62411/tc.v24i2.12802

Neang, A. B., Sutherland, W., Beach, M. W., & Lee, C. P. (2021). Data Integration as Coordination. Proceedings of the ACM on Human-Computer Interaction, 4(CSCW3), 1–25. https://doi.org/10.1145/3432955

Pambudi, I. A. S., Roswinanto, W., & Meiria, C. H. (2023). Pengaruh Perceived Ease Of Use, Perceived Usefulness, Dan Perceived Enjoyment Terhadap Minat untuk Terus Menggunakan Aplikasi Investasi di Indonesia. Journal of Management and Business Review, 20(3), 482–501. https://doi.org/10.34149/jmbr.v20i3.577

Pan, M., Chandrasekaran, A., Hill, J., & Rungtusanatham, M. (2022). Multidisciplinary R&D project success in small firms: The role of multiproject status and project management experience. Production and Operations Management, 31(7), 2806–2821. https://doi.org/10.1111/poms.13716

Priyana, E. (2020). Analisis Kelayakan Pembukaan Prodi Baru Terintegrasi Kebutuhan Pasar di Lingkungan Gresik dengan Pendekatan Statistik. Jurnal INTECH Teknik Industri Universitas Serang Raya, 6(2), 132–140. https://doi.org/10.30656/intech.v6i2.2417

Razouk, H., & Kern, R. (2022). Improving the Consistency of the Failure Mode Effect Analysis (FMEA) Documents in Semiconductor Manufacturing. Applied Sciences, 12(4), 1840. https://doi.org/10.3390/app12041840

Rialti, R., Marzi, G., Caputo, A., & Mayah, K. A. (2020). Achieving strategic flexibility in the era of big data. Management Decision, 58(8), 1585–1600. https://doi.org/10.1108/MD-09-2019-1237

Samunderu, E., & Murahwa, Y. T. (2021). Return Based Risk Measures for Non-Normally Distributed Returns: An Alternative Modelling Approach. Journal of Risk and Financial Management, 14(11), 540. https://doi.org/10.3390/jrfm14110540

Shabbir, M. Q., & Gardezi, S. B. W. (2020). Application of big data analytics and organizational performance: the mediating role of knowledge management practices. Journal of Big Data, 7(1), 47. https://doi.org/10.1186/s40537-020-00317-6

Sholeh, Q. N., Syarief, R., Suwandi, R., & Hidayat, T. (2022). Strategi Pengembangan Bisnis Olahan Ikan Beku di PT XYZ. Jurnal Pengolahan Hasil Perikanan Indonesia, 25(2), 226–234. https://doi.org/10.17844/jphpi.v25i2.38833

Souibgui, M., Atigui, F., Zammali, S., Cherfi, S., & Yahia, S. Ben. (2019). Data quality in ETL process: A preliminary study. Procedia Computer Science, 159, 676–687. https://doi.org/10.1016/j.procs.2019.09.223

Szukits, Á., & Móricz, P. (2024). Towards data-driven decision making: the role of analytical culture and centralization efforts. Review of Managerial Science, 18(10), 2849–2887. https://doi.org/10.1007/s11846-023-00694-1

Trisnawarman, D., & Imam, M. C. (2020). business intelligence framework for performance measurement in higher education study programs. jurnal muara sains, teknologi, Kedokteran Dan Ilmu Kesehatan, 4(2), 249. https://doi.org/10.24912/jmstkik.v4i2.8877

Watson, H. J. (2014). Tutorial: Big Data Analytics: Concepts, Technologies, and Applications. Communications of the Association for Information Systems, 34. https://doi.org/10.17705/1CAIS.03465

Xu, M., Zhang, Y., Sun, H., Tang, Y., & Li, J. (2024). How digital transformation enhances corporate innovation performance: The mediating roles of big data capabilities and organizational agility. Heliyon, 10(14), e34905. https://doi.org/10.1016/j.heliyon.2024.e34905

Yusanto, Y. (2020). Ragam Pendekatan Penelitian Kualitatif. journal of scientific communication (jsc), 1(1). https://doi.org/10.31506/jsc.v1i1.7764