Data-Driven Decision Making in MSMEs: Leveraging Free Analytics Tools for Financial Planning and Efficiency
DOI:
https://doi.org/10.51903/jmi.v4i1.146Keywords:
Data-Driven Decision-Making (DDDM), Financial Planning, Micro, Small, and Medium Enterprises (MSMEs), Google Data StudioAbstract
As a key enabler of enhancement in financial performance and sustainability, Data-Driven Decision-Making (DDDM) within the digital transformation discourse has been helpful for MSMEs. It is unfortunate that in many developing economies, MSMEs become hindered by informal practices due to limited resources, low digital literacy, and complicated perceptions of analytics tools. In this study, we will investigate the practical application of free digital platforms- Microsoft Excel, Google Data Studio, and Canva Analytics support financial planning and operational efficiency in MSMEs. The research applies a descriptive-applicative approach to create realistic financial data representing the fictitious operations of an MSME-from daily sales, operational costs, to promotional expenses over 30 days. Results show that simple dashboards can lead to some critical insights, for instance, weekly net cash flow that peaked at IDR 2,150,000 in Week 3 and IDR 1,980,000 in Week 5, which means greater operational efficiency. A simulated digital promotion campaign saw a Return On Investment (ROI) of 220%, thereby reinforcing the importance of sales and marketing analytics. Furthermore, the operational expense accounted for about 65% of the total expenses, thus showing room for cost optimization. The findings substantiate the fact that with a little training, MSMEs can now take their financial decisions away from intuition and into data-driven decisions using tools that are freely available online. This study presents a framework that is replicable and scalable in the same resource-constrained environments, with enough practical insights for policymakers and MSME development programs who wish to promote digital financial literacy and performance monitoring.
References
Adi, S., Setyawan, R., & Sumarlin, T. (2024). The Influence of Digital Marketing Strategies on Brand Loyalty: A Cross-Cultural Study Using A/B Testing. Journal of Management and Informatics, 3(3), 414–433. https://doi.org/10.51903/jmi.v3i3.51
Al-Fattal, A. (2024). Entrepreneurial Aspirations and Challenges among Business Students: A Qualitative Study. Administrative Sciences, 14(5), 101. https://doi.org/10.3390/admsci14050101
Amornkitvikai, Y., Tham, S. Y., Harvie, C., & Buachoom, W. W. (2022). Barriers and Factors Affecting the E-Commerce Sustainability of Thai Micro-, Small- and Medium-Sized Enterprises (MSMEs). Sustainability, 14(14), 8476. https://doi.org/10.3390/su14148476
Dal Mas, F., Massaro, M., Paoloni, P., & Kianto, A. (2023). Translating Knowledge in New Entrepreneurial Ventures: The Role of Business Plan Development. VINE Journal of Information and Knowledge Management Systems, 53(6), 1159–1177. https://doi.org/10.1108/vjikms-04-2021-0060
De Bruijn, E. J., & Antonides, G. (2022). Poverty and Economic Decision Making: A Review of Scarcity Theory. Theory and Decision, 92(1), 5–37. https://doi.org/10.1007/s11238-021-09802-7
Díaz-Arancibia, J., Hochstetter-Diez, J., Bustamante-Mora, A., Sepúlveda-Cuevas, S., Albayay, I., & Arango-López, J. (2024). Navigating Digital Transformation and Technology Adoption: A Literature Review from Small and Medium-Sized Enterprises in Developing Countries. Sustainability, 16(14), 5946. https://doi.org/10.3390/su16145946
Dineva, K., & Atanasova, T. (2022). Cloud Data-Driven Intelligent Monitoring System for Interactive Smart Farming. Sensors, 22(17), 6566. https://doi.org/10.3390/s22176566
Eberhard, K. (2023). The Effects of Visualization on Judgment and Decision-Making: A Systematic Literature Review. In Management Review Quarterly (Vol. 73, Issue 1). Springer International Publishing. https://doi.org/10.1007/s11301-021-00235-8
Elragal, A., & Elgendy, N. (2024). A Data-Driven Decision-Making Readiness Assessment Model: The Case of a Swedish Food Manufacturer. Decision Analytics Journal, 10, 100405. https://doi.org/10.1016/j.dajour.2024.100405
Gautam, R. S., Rastogi, S., Rawal, A., Bhimavarapu, V. M., Kanoujiya, J., & Rastogi, S. (2022). Financial Technology and Its Impact on Digital Literacy in India: Using Poverty as a Moderating Variable. Journal of Risk and Financial Management, 15(7), 311. https://doi.org/10.3390/jrfm15070311
Gul, R., Leong, K., Mubashar, A., Al-Faryan, M. A. S., & Sung, A. (2023). The Empirical Nexus between Data-Driven Decision-Making and Productivity: Evidence from Pakistan’s Banking Sector. Cogent Business and Management, 10(1), 2178290. https://doi.org/10.1080/23311975.2023.2178290
Hargyatni, T., Purnama, K. D., & Aninditiyah, G. (2024). Impact Analysis of Artificial Intelligence Utilization in Enhancing Business Decision-Making in the Financial Sector. Journal of Management and Informatics, 3(2), 282–296. https://doi.org/10.51903/jmi.v3i2.36
Hinchcliff, M., & Mehmet, M. (2023). Embedding Canva into the Marketing Classroom: A Dialogic and Social Learning Approach to Classroom Innovation. Higher Education, Skills and Work-Based Learning, 13(6), 1174–1186. https://doi.org/10.1108/heswbl-11-2022-0230
Hjelle, S., Mikalef, P., Altwaijry, N., & Parida, V. (2024). Organizational Decision Making and Analytics: An Experimental Study on Dashboard Visualizations. Information and Management, 61(6), 104011. https://doi.org/10.1016/j.im.2024.104011
Karaev, A. K., Gorlova, O. S., Sedova, M. L., Ponkratov, V. V., Shmigol, N. S., & Demidova, S. E. (2022). Improving the Accuracy of Forecasting the TSA Daily Budgetary Fund Balance Based on Wavelet Packet Transforms. Journal of Open Innovation: Technology, Market, and Complexity, 8(3), 107. https://doi.org/10.3390/joitmc8030107
Keke, M. E. (2022). The Use of Digital Marketing in Information Transport in Social Media: The Example of Turkish Companies. Transportation Research Procedia, 63, 2579–2588. https://doi.org/10.1016/j.trpro.2022.06.297
Le, T. D., Le-Dinh, T., & Uwizeyemungu, S. (2024). Search Engine Optimization Poisoning: A cybersecurity Threat Analysis and Mitigation Strategies for Small and Medium-Sized Enterprises. Technology in Society, 76, 102470. https://doi.org/10.1016/j.techsoc.2024.102470
Lontchi, C. B., Yang, B., & Shuaib, K. M. (2023). Effect of Financial Technology on SMEs Performance in Cameroon amid COVID-19 Recovery: The Mediating Effect of Financial Literacy. Sustainability, 15(3), 2171. https://doi.org/10.3390/su15032171
Moslem, S., Farooq, D., Esztergár-Kiss, D., Yaseen, G., Senapati, T., & Deveci, M. (2024). A Novel Spherical Decision-Making Model for Measuring the Separateness of Preferences for Drivers’ Behavior Factors Associated with Road Traffic Accidents. Expert Systems with Applications, 238, 0–3. https://doi.org/10.1016/j.eswa.2023.122318
Mustafa, W. M. W., Islam, M. A., Asyraf, M., Hassan, M. S., Royhan, P., & Rahman, S. (2023). The Effects of Financial Attitudes, Financial Literacy and Health Literacy on Sustainable Financial Retirement Planning: The Moderating Role of the Financial Advisor. Sustainability, 15(3), 2677. https://doi.org/10.3390/su15032677
Ragazou, K., Passas, I., Garefalakis, A., & Zopounidis, C. (2023). Business Intelligence Model Empowering SMEs to Make Better Decisions and Enhance Their Competitive Advantage. Discover Analytics, 1(1), 2. https://doi.org/10.1007/s44257-022-00002-3
Stuebs, M., Bryant, S. M., Edison, C., & Stanley, C. (2022). Brittney’s Boutique: Tailoring Financial Statements for Function as Well as Fashion. Journal of Accounting Education, 58, 100768. https://doi.org/10.1016/j.jaccedu.2022.100768
Su, J., Zhang, Y., & Wu, X. (2023). How Market Pressures and Organizational Readiness Drive Digital Marketing Adoption Strategies’ Evolution in Small and Medium Enterprises. Technological Forecasting and Social Change, 193, 122655. https://doi.org/10.1016/j.techfore.2023.122655
Susanto, E., & Khaq, Z. D. (2024). Enhancing Customer Service Efficiency in Start-Ups with AI: A Focus on Personalization and Cost Reduction. Journal of Management and Informatics, 3(2), 267–281. https://doi.org/10.51903/jmi.v3i2.34
Yazdi, M., Zarei, E., Adumene, S., & Beheshti, A. (2024). Navigating the Power of Artificial Intelligence in Risk Management: A Comparative Analysis. Safety, 10(2), 42. https://doi.org/10.3390/safety10020042
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Journal of Management and Informatics
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License (CC BY-SA 4.0).
This license allows others to copy, distribute, display, and perform the work, and derivative works based upon it, for both commercial and non-commercial purposes, as long as they credit the original author(s) and license their new creations under identical terms.
Licensed under CC BY-SA 4.0: https://creativecommons.org/licenses/by-sa/4.0/
