APPLICATION OF DATA WAREHOUSE FOR ANALYZING THE EFFECT OF FINANCIAL RATIOS ON STOCK PRICES IN CONSUMER NON-CYCLICALS COMPANIES LISTED ON THE INDONESIA STOCK EXCHANGE FROM 2022 TO 2024
DOI:
https://doi.org/10.58432/ksw6pz37Keywords:
Data Warehouse, ETL, ROA, DER, EPS, Stock Price, IDXAbstract
This study aims to examine the effect of financial ratios on stock prices of primary consumer goods companies listed on the Indonesia Stock Exchange during the 2022 2024 period, utilizing a Data Warehouse as a data integration platform. Secondary data in the form of financial reports and stock prices were processed through an ETL (Extract, Transform, Load) process to produce a structured and consistent historical dataset. Multiple linear regression (OLS) analysis using SPSS was applied to assess the effect of ROA, TATO, DER, and EPS on stock prices. The results showed that all variables had a significant simultaneous effect, but partially only EPS had a significant positive effect. Conversely, ROA, TATO, and DER did not show a significant effect on stock price variations in the primary consumer goods sector. This finding confirms that earnings per share is a key indicator for investors, while asset efficiency and funding structure do not have a direct impact. Furthermore, this study confirms that implementing a Data Warehouse can improve the effectiveness of financial data integration and analysis across periods.
Downloads
References
Bursa Efek Indonesia. (2023). Laporan Statistik Pasar Modal 2023. https://www.idx.co.id/
Fan, C., Zeng, L., & Huang, K. (2022). Research Landscape, Emerging Trends and New Developments in Data Warehouse: A Scientometric Analysis (1985 - 2021). 2022 12th International Workshop on Computer Science and Engineering, WCSE 2022, Wcse, 126–136. https://doi.org/10.18178/wcse.2022.06.019
Gafiarty, G. B., Samosir, M., Nainggolan, R. P., Siagian, F. L., & Dewi, D. S. (2025). THE EFFECT OF RETURN ON EQUITY (ROE), EARNINGS PER SHARE (EPS), AND DEBT TO EQUITY RATIO (DER) ON THE STOCK PRICES OF ENERGY SECTOR COMPANIES ON THE INDONESIA STOCK EXCHANGE. Jurnal Akuntansi & Perpajakan Jayakarta, 7(1). https://doi.org/https://doi.org/10.53825/japjayakarta.v7i01.391
Halim, S., Mubarokah, I., & Hidayanto, A. N. (2020). Rank Critical Success Factors (CSFs) of Data Warehouse and Business Intelligence (DW/BI) Implementation in Banking Sector Using Analytical Hierarchy Process (AHP). Proceedings - 2nd International Conference on Informatics, Multimedia, Cyber, and Information System, ICIMCIS 2020, 313–318. https://doi.org/10.1109/ICIMCIS51567.2020.9354331
Haryono, E. M., Fahmi, Tri W, A. S., Gunawan, I., Nizar Hidayanto, A., & Rahardja, U. (2020). Comparison of the E-LT vs ETL Method in Data Warehouse Implementation: A Qualitative Study. Proceedings - 2nd International Conference on Informatics, Multimedia, Cyber, and Information System, ICIMCIS 2020, 115–120. https://doi.org/10.1109/ICIMCIS51567.2020.9354284
Haryono, K. (2020). PENERAPAN DATA WAREHOUSE DALAM PENGELOLAAN SISTEM KEUANGAN DAERAH (STUDI KASUS PEMERINTAH PROVINSI XYZ). Teknomatika: Jurnal Informatika Dan Komputer, 6(2), 1–16.
Hery. (2023). Analisis Laporan Keuangan : Intergrated and comperhesive edtion. Gramedia Widiasarana.
Hidayat, A. Y., Zahro, N. I., & Handayani, T. R. (2025). Impact of Financial Ratios on Stock Returns of Industrial Companies in Indonesia. Indikator: Jurnal Ilmiah Manajemen Dan Bisnis, 9(1), 32. https://doi.org/10.22441/indikator.v9i1.28070
Imansyah, & Mustafa. (2019). Pengaruh CR, NPM, ROE, DY terhadap harga saham perusahaan consumer goods (Kompas100).
Kumar, J. (2024). Data Warehouse and Data Mining Concepts, techniques and real life applications. https://helion.pl/pobierz-fragment/data-warehouse-and-data-mining-dr-jugnesh-kumar,e_41q9/pdf?srsltid=AfmBOooiSMXB4ty8uBz-fDljomY_YpP0RhQhsmVSwTaOsJTdz5oGl__k
Marindra, W. A., Simbolon, E. I., Anjelia, L., & Dini, S. (2021). Pengaruh Return On Asset, Current Ratio, Debt to Equity Ratio dan Inventory Turnover Terhadap Return Saham pada Perusahaan Sektor Barang Konsumsi yang Terdaftar di Bursa Efek Indonesia Tahun 2017-2019. Ekonomis: Journal of Economics and Business, 5(2), 392. https://doi.org/10.33087/ekonomis.v5i2.340
Melisa Yuana, & Taudlikhul Afkar. (2020). Analisis Pengaruh Rasio Keuangan Terhadap Harga Saham Pada Perusahaan Industri Barang Konsumsi Yang Terdaftar Di Bei. Journal of Sustainability Bussiness Research (JSBR), 1(1), 268–274. https://doi.org/10.36456/jsbr.v1i1.2994
Nambiar, A., & Mundra, D. (2022). An Overview of Data Warehouse and Data Lake in Modern Enterprise Data Management. Big Data and Cognitive Computing, 6(4). https://doi.org/10.3390/bdcc6040132
Pradnyana, I. M. A. (2021). MSIM4315 – Data Warehouse (1st ed.). Tangerang Selatan: Universitas Terbuka.
Reis, J., & Housley, M. (2022). Fundamentals of data engineering. 204.
Saragih, F. N. A., & Ermalina, E. (2021). Pengaruh Return On Equity Ratio, Current Ratio, Dan Dividend Yield Terhadap Harga Saham Perusahaan Industri Barang Konsumsi Yang Terdaftar Di Bursa Efek Indonesia (BEI). Jurnal Akuntansi Dan Keuangan Kontemporer (JAKK). https://doi.org/10.30596/jakk.v4i1.6761
Shiramshetty, S. K. (2023). Data Warehousing Solutions for Business Intelligence. International Journal of Computer Science and Mobile Computing, 12(3), 49–62. https://doi.org/10.47760/ijcsmc.2023.v12i03.006
Sihombing, P., & Zakchona, E. (2024). Determinants of profitability, liquidity, solvency, and activity ratios on the stock price with dividend payout as moderating variable. Jurnal Ekonomi Dan Bisnis, 27(2), 1–24. https://doi.org/10.24914/jeb.v27i2.10268
Sintawati, S., Setiawan, R., & Aspirandi, R. M. (2025). The Effect of Financial Ratios on Stock Prices with Profitability as a Moderating Variable in Food Companies Listed on the Indonesia Stock Exchange. Journal Of Management Finance, 2(4). https://doi.org/https://doi.org/10.62017/finance.v2i4.84
Tamanam, P. (2023). The Evolution of Smart Data Warehousing : How AI Is Taking Business Intelligence to Unimaginable Heights. 3(3), 133–143. https://doi.org/10.56472/25832646/JETA-V3I7P117
Wahyudi, R., Fatimah, F., & Ladewi, Y. (2025). Effect of Debt to Equity Ratio, Return on Assets, and Inflation Level on Stock Prices: Empirical Study of Manufacturing Firms in the Consumer Good Industry Listed on the Indonesia Stock Exchange (IDX) from 2019 to 2023. International Journal of Finance Research, 6(2), 160–169. https://doi.org/10.47747/ijfr.v6i2.2879
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Oktavian Luthfi Khairan Somali, Muhammad Aghnat Mumtaz, Ahmad Abdul Faqih, Muhammad Jafni Abbas, Rido Dwi Kurniawan, Muh Masri Sari (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
