Designing a Data Mart at the Indonesian Psychological Healthcare Center Using Pentaho
Abstract
Critical data is essential for organisational success, providing essential information for decision-making. This study focuses on the Indonesian Mental Health Centre (IndoPsyCare), which utilises data to improve service performance. The research aims to design a data mart to support analytical needs by transforming the Online Transaction Processing (OLTP) database into Online Analytical Processing (OLAP). This design follows Kimball's Nine-Step Approach and integrates the Extract, Transform, Load (ETL) process. Data was collected from August 2023 to August 2024 through interviews and electronic documentation. The system was implemented using Microsoft SQL Server Management Studio 18 and Pentaho Data Integration. The resulting data mart uses a star schema with fact and dimension tables tailored to stakeholder needs, particularly in appointment analysis. Findings indicate that the data mart facilitates efficient access, targeted analysis, and improved query performance, thereby supporting IndoPsyCare's decision-making and overall service optimisation.
Keywords
References
R. Sutanto, Wasino, and J. T. Beng, “Developing a sales system for Ko Ginhan’s special chicken porridge with point of sale system,” AIP Conference Proceedings, vol. 2680, no. 1, Dec. 2023. [Online]. Available: /aip/acp/article/2680/1/020061/2928475/Developing-a-sales-system-for-Ko-Ginhan-s-special. [Accessed: Aug. 30, 2024].
J. Louis, D. Trisnawarman, and N. J. Perdana, “Perancangan dashboard business intelligence untuk data piutang pada Apotek X,” Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, vol. 12, no. 3, pp. 1767–1776, 2023.
M. Akbar and Y. Rahmanto, “Desain data warehouse penjualan menggunakan Nine Step methodology untuk business intelegency,” Jurnal Informatika dan Rekayasa Perangkat Lunak (JATIKA), vol. 1, no. 2, pp. 137–146, 2020. [Online]. Available: http://jim.teknokrat.ac.id/index.php/informatika.
O. Angela, R. Nurkholiza, V. Lawrence, D. Trisnawarman, and J. T. Beng, “Rancang bangun dashboard appointment pada layanan kesehatan mental X dengan metode prototyping,” Journal of Information Technology and Computer Science (INTECOMS), vol. 7, no. 6, pp. 2011–2020, 2024.
K. Nisa, D. Sugiarto, and T. Siswanto, “Perancangan data warehouse harga pangan di wilayah Perumda Pasar Jaya,” Jurnal Sistem Informasi dan Telematika (Telekomunikasi, Multimedia dan Informatika), vol. 12, no. 1, pp. 47–55, 2021.
“About IndoPsyCare - Indonesian Psychological Healthcare Center.” [Online]. Available: https://indopsycare.com/about-us/#vm. [Accessed: Jul. 24, 2024].
Biro Komunikasi dan Pelayanan Publik KKR, “Menjaga kesehatan mental para penerus bangsa,” Sehat Negeriku, Oct. 12, 2023. [Online]. Available: https://sehatnegeriku.kemkes.go.id/baca/rilis-media/20231012/3644025/menjaga-kesehatan-mental-para-penerus-bangsa/. [Accessed: Jul. 24, 2024].
O. K. Sari, N. Ramdhani, and S. Subandi, “Kesehatan mental di era digital: Peluang pengembangan layanan profesional psikolog,” Media Penelitian dan Pengembangan Kesehatan, vol. 30, no. 4, pp. 337–348, Dec. 2020. [Online]. Available: https://garuda.kemdikbud.go.id/documents/detail/1996729. [Accessed: Sep. 3, 2024].
R. J. F. Guanco, L. K. Y. Delgra, U. E. Dotimas, K. B. Dumas, E. R. D. Lumpay, “Mediating role of coping strategies on the symptoms of complicated grief and psychological well-being during COVID-19 pandemic,” Human Behavior, Development and Society, vol. 24, no. 1, pp. 84–92, Apr. 2023. [Online]. Available: https://www.researchgate.net/publication/370229603.
T. R. Priono, W. Purnomo, and N. Y. Setiawan, “Pengembangan data warehouse menggunakan metode Kimball (studi kasus: ekspor & impor fauna dan flora hias air laut),” Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 5, no. 8, pp. 3383–3392, 2021. [Online]. Available: http://j-ptiik.ub.ac.id.
R. M. Stair and G. W. Reynolds, Principles of Information Systems. Boston, MA, USA: Cengage Learning, 2018.
A. K. Hamoud, M. K. Hussein, Z. Alhilfi, and R. H. Sabr, “Implementing data-driven decision support system based on independent educational data mart,” International Journal of Electrical and Computer Engineering, vol. 11, no. 6, pp. 5301–5314, Dec. 2021.
V. Banja, M. Ilić, L. Kopanja, D. Zlatković, M. Trajković, and D. Ćurguz, “Microsoft SQL Server and Oracle: Comparative performance analysis,” in Proc. 7th Int. Conf. Knowledge Management and Informatics, 2021, pp. 33–40.
N. Leite, I. Pedrosa, and J. Bernardino, “Open source business intelligence on a SME: A case study using Pentaho,” in Proc. 14th Iberian Conf. Information Systems and Technologies (CISTI), Coimbra, Portugal, 2019, pp. 1–7.
Charlie, J. T. Beng, and D. Arisandi, “Website-based information system for mapping restaurants or eating places in DKI Jakarta using Google Maps,” IOP Conference Series: Materials Science and Engineering, vol. 1007, no. 1, Dec. 2020. [Online]. Available: https://iopscience.iop.org/article/10.1088/1757-899X/1007/1/012157. [Accessed: Aug. 30, 2024].
M. J. Finandi, Fauziah, and I. D. Sholihati, “Sistem informasi pendataan pelayanan kesehatan penderita diabetes mellitus menggunakan metode Online Analytical Processing (OLAP),” KLIK: Kajian Ilmiah Informatika dan Komputer, vol. 4, no. 1, pp. 53–61, 2023.
D. Sihombing, “Academic data warehouse modeling in higher education using Nine-Step design methodology,” Journal of Information Systems and Informatics, vol. 4, no. 4, pp. 1126–1134, Dec. 2022. [Online]. Available: https://www.journal-isi.org/index.php/isi/article/view/399.
A. Delgado, F. Rosas, and C. Carbajal, “System of business intelligence in a health organization using the Kimball methodology,” in 2019 IEEE Chilean Conf. Electrical, Electronics Engineering, Information and Communication Technologies (CHILECON), 2019, pp. 1–5.
S. Anshari and S. Retno, “Penerapan metode Nine-Step Kimball dalam pengolahan data history menggunakan data warehouse dan business intelligence,” Jurnal Ilmu Komputer, vol. 16, pp. 69–79, Sep. 2023.
M. Madhikerrni and K. Främling, “Data discovery method for extract-transform-load,” in 2019 IEEE 10th Int. Conf. Mechanical and Intelligent Manufacturing Technologies (ICMIMT), 2019, pp. 205–212.
N. Biswas, A. Sarkar, and K. C. Mondal, “Efficient incremental loading in ETL processing for real-time data integration,” Innovations in Systems and Software Engineering, vol. 16, no. 1, pp. 53–61, 2020. [Online]. Available: https://doi.org/10.1007/s11334-019-00344-4.
M. Venkateswarlu and T. G. Vasista, “Extraction, transformation and loading process in the cloud computing scenario,” International Journal of Engineering Applied Sciences and Technology, vol. 8, no. 1, pp. 232–236, 2023.
R. Saputra and D. Trisnawarman, “Perancangan dashboard inventory e-commerce Anicca menggunakan Microsoft Power BI,” Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, vol. 12, no. 3, pp. 1475–1483, 2023.
F. Z. D. Wardhani and J. Wiratama, “Improving the quality of service: ETL implementation on data warehouse at pharmacy industry,” Jurnal Tekno Kompak, vol. 18, no. 1, pp. 1–14, Feb. 2024, doi: 10.33365/JTK.V18I1.3211.
How To Cite This :
Refbacks
- There are currently no refbacks.
