Peningkatan Kapasitas SDM di RSJ. HB. Saanin dalam Pengolahan Data Kesehatan Menggunakan Pivot Table dan Dashboard Ms Excel
Main Article Content
Abstract
HB Saanin Psychiatric Hospital faces challenges in health data management that is still conducted manually, limiting efficiency and accuracy in decision-making. A major constraint lies in the limited understanding of healthcare professionals and administrative staff regarding data analysis tools, such as Pivot Tables and Dashboards in Microsoft Excel. To address this issue, this Community Service Program (PKM) aimed to enhance the capacity of human resources at HB Saanin Hospital in health data processing through training and mentoring on Excel features. The program consisted of preparation, training implementation, evaluation, and mentoring stages. The training focused on two key aspects: (1) data analysis using Pivot Tables for faster and more accurate information presentation, and (2) the development of interactive Dashboards as data visualization tools to support evidence-based decision-making. Evaluation was carried out through pre-tests and post-tests, as well as direct observation of participants’ application in their workplace. Results showed an increase in participants’ understanding, with an average pre-test score of 73.64 compared to a post-test score of 85. The outcomes indicate improved skills of healthcare staff in efficient data management and analysis, thereby supporting service optimization at HB Saanin Hospital through Excel-based information technology.
Downloads
Article Details
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
References
Ammenwerth, E., Gräber, S., Herrmann, G., Burkle, T., & Kutscha, U. (2019). Evaluation of Health IT: Methods and Practical Applications. International Journal of Medical Informatics, 78(1), 47-56.
Braun, V., & Clarke, V. (2006). Using thematic analysis in psychology. Qualitative Research in Psychology, 3(2), 77-101.
Brooke, J. (1996). SUS: A Quick and Dirty Usability Scale. Usability Evaluation in Industry, 189(194), 4-7.
Creswell, J. W. (2014). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches. Sage Publications.
Field, A. (2013). Discovering Statistics Using IBM SPSS Statistics. Sage Publications.
Haux, R., Ammenwerth, E., Winter, A., & Brigl, B. (2018). Strategic Information Management in Hospitals. Springer Science & Business Media.
Kruse, C. S., Stein, A., Thomas, H., & Kaur, H. (2018). The Benefits and Barriers of Electronic Health Records and Patient Portals. JMIR Medical Informatics, 6(3), e34.
Menachemi, N., & Collum, T. H. (2011). Benefits and drawbacks of electronic health record systems. Risk Management and Healthcare Policy, 4, 47-55.
Neuman, W. L. (2014). Social Research Methods: Qualitative and Quantitative Approaches. Pearson Education.
Nguyen, L., Bellucci, E., & Nguyen, L. T. (2014). Electronic health records implementation: An evaluation of information system impact and contingency factors. International Journal of Medical Informatics, 83(11), 779-796.
Pallant, J. (2020). SPSS Survival Manual: A Step by Step Guide to Data Analysis Using IBM SPSS. Routledge.
Zhang, X., Yu, P., Yan, J., & Ton, A. M. (2020). The Impact of Electronic Health Records on Healthcare Quality: A Systematic Review. International Journal of Medical Informatics, 136, 104112.