A Data Visualization Training Using Microsoft Excel for Village Government Officials: Enhancing Data Management and Evidence-Based Decision Making
DOI:
https://doi.org/10.5281/zenodo.24012234Keywords:
Data Visualization Microsoft Excel, Village Government, Data Literacy, Dashboard DevelopmentAbstract
Village governments are increasingly required to utilize accurate and timely data to support administrative services, development planning, financial accountability, and evidence-based policymaking. However, many village government officials still have limited competencies in organizing, analyzing, and presenting data effectively. Most administrative reports are prepared manually, making it difficult to interpret information and communicate development achievements to stakeholders. This community service program aimed to enhance the data visualization competencies of village government officials through hands-on training using Microsoft Excel. The training employed a participatory learning approach consisting of four stages: needs assessment, instructional workshops, guided practice, and performance evaluation. Twenty-five village officials participated in practical sessions covering data organization, data cleaning, Pivot Tables, Pivot Charts, conditional formatting, dashboards, and interactive visual reports. Participants completed pre-tests and post-tests to measure improvements in knowledge and technical skills. The evaluation results demonstrated a substantial increase in participants' competencies, with the average assessment score improving from 56.4 before the training to 86.7 after the program, representing an increase of 53.7%. Participants also showed greater confidence in producing graphical reports, summarizing village demographic and financial data, and developing dashboards that support administrative transparency. Feedback collected through questionnaires indicated a high level of participant satisfaction with the relevance of the training materials and the practical learning approach. The novelty of this community service program lies in integrating practical Microsoft Excel dashboard development with village administrative datasets to strengthen data-driven governance at the local government level. The program demonstrates that structured digital capacity-building activities can significantly improve data literacy and support better decision-making processes within village administrations.
References
1] C. N. Knaflic, Storytelling with Data: A Data Visualization Guide for Business Professionals. Hoboken, NJ, USA: Wiley, 2015.
[2] S. Few, Show Me the Numbers: Designing Tables and Graphs to Enlighten, 2nd ed. Burlingame, CA, USA: Analytics Press, 2012.
[3] B. Chambers, Rural Development: Putting the Last First. London, UK: Routledge, 2014.
[4] D. A. Kolb, Experiential Learning: Experience as the Source of Learning and Development, 2nd ed. Upper Saddle River, NJ, USA: Pearson Education, 2015.
[5] M. T. Hansen and T. H. Davenport, "Data-driven decision making in organizations," MIT Sloan Management Review, vol. 63, no. 2, pp. 1–9, 2022.
[6] A. Aminullah, A. U. Wusko, and D. T. Loreño, "How digital governance networks shape community empowerment: A multilevel study of Indonesian villages," Jurnal Ilmu Sosial, vol. 25, no. 1, pp. 37–58, 2026.
[7] B. Sabella, Y. Prastyaningsih, M. N. Ridha, and R. Sayyidati, "Peningkatan Kapasitas Aparatur Desa melalui Pelatihan Microsoft Word dan Excel untuk Mendukung Administrasi yang Efisien," Jurnal Inovasi Terapan Abdimas, vol. 1, no. 1, pp. 1–12, 2026.
[8] M. Ladini, T. Yuwono, and Yuwanto, "Multi-Level Governance in the Making of Smart Villages: Policy Alignment and Digital Transformation in Central Java, Indonesia," ACTA Innovations, pp. 29–38, 2026.
[9] I. Islamiati, M. W. Askar, and H. R. Aisyah, "Empowering Rural Transformation: The Role of Good Governance in Developing Smart Villages in Indonesia," Public Integrity, 2026.
[10] M. R. R. Razak et al., "Bridging Global Evidence and Local Realities: The Rais-MR3 Digital Governance Model for Transforming Village Fund Management," Frontiers in Sustainability, vol. 7, 2026.
[11] A. F. Manuain et al., "Penguatan Tata Kelola Desa Berbasis Nilai Lokal Madene dan Inovasi Digital di Desa Busalangga Barat," Society: Jurnal Pengabdian dan Pemberdayaan Masyarakat, vol. 6, no. 1, 2026.
[12] "Visualization of Village Fund Budget Realization to Improve Transparency of Information to the Community," Jurnal Abmas Negeri (JAGRI), 2025.
[13] M. D. Supriatna, D. Wibisono, and I. Fatima, "Redesigning Performance Management Systems to Strengthen Village Governance: A Systematic Literature Review," Cogent Business & Management, vol. 13, 2026.
[14] L. Ming, "Research on the Impact of Digital Literacy on the Governance Capacity of Village Cadres: Empirical Analysis Based on the Survey Data of 675 Village Cadres," Journal of Yunnan Agricultural University (Social Science), vol. 20, no. 1, pp. 74–82, 2026.
[15] C. L. Borgman and P. E. Bourne, "Why It Takes a Village to Manage and Share Data," Patterns, vol. 2, no. 10, 2021.
[16] Microsoft Corporation, Microsoft Excel Documentation. Microsoft Learn, 2024.
[17] Microsoft Corporation, Create Dashboards in Excel Using PivotTables and PivotCharts. Microsoft Learn, 2024.
[18] OECD, The Path to Becoming a Data-Driven Public Sector. Paris: OECD Publishing, 2023.
[19] United Nations, E-Government Survey 2024: Accelerating Digital Transformation for Sustainable Development. New York: United Nations, 2024.
[20] World Bank, World Development Report 2021: Data for Better Lives. Washington, DC: World Bank, 2021.
