MSME Data Integration and Visualization Dashboard for Commodity Distribution Analysis Using ETL Approach (Case Study: Bank Indonesia Representative Office of Bengkulu Province)
DOI:
https://doi.org/10.70656/ijcse.v3i01.910Keywords:
data integration, data visualization, ETL, MSME, power BIAbstract
Bank Indonesia Representative Office of Bengkulu Province manages MSME data collected from multiple heterogeneous sources, including internal databases, G-Form e-catalogue responses, and internal systems. However, this data remains unintegrated and stored in fragmented formats, hindering effective monitoring and data-driven decision-making. The lack of a structured integration pipeline and visualization tool further limits the unit's ability to analyze MSME commodity distribution across Bengkulu Province. This study aims to (1) integrate MSME data from three heterogeneous sources into a unified dataset, (2) perform data transformation and cleaning from 82 raw records into 53 valid MSME entries, and (3) develop an interactive Power BI dashboard for analyzing commodity distribution, regional spread, and featured products. The ETL (Extract, Transform, Load) approach was implemented using Python and the Pandas library in Google Colab for data extraction and transformation, while Microsoft Power BI was used for data loading and interactive visualization, covering 53 MSMEs across 9 districts/cities in Bengkulu Province. The integration process successfully unified data from three sources, reducing 82 raw records to 53 validated entries through duplicate removal, incomplete data filtering, and irrelevant record elimination. The dashboard reveals that 66% of MSMEs are concentrated in the food and beverage sector, 54.7% are located in Kota Bengkulu, and coffee processing dominates as the leading commodity. This study contributes a replicable ETL-based framework for multi-source MSME data integration and visualization to support Bank Indonesia Bengkulu in more efficient, data-driven MSME development and policy decisions.
Downloads
References
[1] I. Rahayu, Siti Kurnia; Budiarti, “Digitalization and Informal MSME: Digital Financial Inclusion for MSME Development in The Formal Economy,” vol. 10, no. 1, 2023.
[2] B. Khan, S. Jan, W. Khan, and M. I. Chughtai, “An Overview of ETL Techniques , Tools , Processes and Evaluations in Data Warehousing,” 2024, doi: 10.32604/jbd.2023.046223.
[3] N. Famiera, A. Razali, S. Baharom, S. Abdullah, and N. Indriaty, “Improving Data Reliability Assessment in ETL Processes through Quality Scoring Technique in Data Analytics,” vol. 8, no. December, pp. 2195–2202, 2024.
[4] T. Gonçalves and M. Jos, “Developing Integrated Performance Dashboards Visualisations Using Power BI as a Platform,” 2023.
[5] K. G. Sanabia-lizarraga, B. Carballo-mend, A. Arellano-gonz, and A. Bueno-solano, “Business Intelligence for Agricultural Foreign Trade : Design and Application of Power BI Dashboard,” 2024.
[6] F. N. Arifin, A. A. Cahyarani, and M. A. Furqon, “Small Medium Enterprise Data Visualization Analysis as Strategic Business Development,” vol. 18, pp. 1–7, 2023.
[7] K. Ragazou, I. Passas, A. Garefalakis, and C. Zopounidis, “Business intelligence model empowering SMEs to make better decisions and enhance their competitive advantage,” Discov. Anal., 2023, doi: 10.1007/s44257-022-00002-3.
[8] S. Raschka, J. Patterson, and C. Nolet, “Machine Learning in Python : Main Developments and Technology Trends in Data Science , Machine Learning , and Artificial Intelligence,” 2020, doi: 10.3390/info11040193.
[9] O. Alotaibi and E. Pardede, “Cleaning Big Data Streams : A Systematic Literature Review,” pp. 1–24, 2023.
[10] I. M. Putrama and P. Martinek, “Heterogeneous data integration : Challenges and opportunities,” Data Br., vol. 56, p. 110853, 2024, doi: 10.1016/j.dib.2024.110853.
[11] T. Horak, P. Strelec, M. Kebisek, P. Tanuska, and A. Vaclavova, “Purposes of Analysis within Industry 4 . 0 Concept,” 2022.
[12] F. Ashardiono and A. Trihartono, “Optimizing the potential of Indonesian coffee : a dual market approach,” Cogent Soc. Sci., vol. 10, no. 1, p., 2024, doi: 10.1080/23311886.2024.2340206.
[13] Y. Sarvina, T. June, S. H. Sutjahjo, R. Nurmalina, and E. Surmaini, “International Journal of Sustainable Development and Planning Projection of Robusta Coffee ’ s Climate Suitability for Sustainable Indonesian Coffee Production,” vol. 18, no.
4, pp. 1069–1078, 2023.
[14] G. García-vidal, A. Sánchez-rodríguez, L. Guzmán-vilar, and R. Martínez-vivar, “Exploring MSME Owners ’ Expectations of Data-Driven Approaches to Business Process Management,” 2025.



.png)
.png)



.png)
.png
)


