Indonesia currently ranks 15th among the countries with the highest levels of air pollution. With PM2.5 concentrations reaching 7.1 times above the World Health Organization (WHO) recommended limit, air pollution has become a serious public health concern. In Bandung, the urgency is even more evident, as the city is recorded as the third most polluted in Indonesia according to IQAir, underscoring the need for stronger response mechanisms and data-informed intervention strategies.
Stakeholders across sectors have shown strong commitment to working together to improve air quality, enhance public health, and increase the overall quality of life. One strategic step is the integration of air quality parameters with health data to develop an early warning system, enabling faster policy response and timely community action—such as using masks or limiting outdoor activities during periods of hazardous air quality.
As part of these efforts, the Research Center for Climate Change Universitas Indonesia (RCCC UI), in collaboration with LPPM ITENAS and supported by Yayasan Visi Indonesia Raya Emisi Nol Bersih (ViriyaENB), organized a capacity -building workshop titled:
Capacity Building on Integrated Data Analysis for Air Quality and Related Diseases Using Microsoft Excel held in Bandung on 13–14 November 2025.
The workshop aimed to strengthen the technical capacity of participants in integrating and processing air quality and disease-related health data, while also enhancing coordination and shared understanding among institutions involved in data management to support the development of an effective early warning system.
Participants included representatives from Bandung City Health Office, BPJS Kesehatan Bandung Regional Branch, BRIN, and Environmental Engineering departments from several universities in Bandung.
Over the two-day workshop, participants learned key skills in data processing and integration, including policy brief review, data transformation, integration, cleaning, and identification of outliers. They also practiced basic statistical analysis in Microsoft Excel, such as normality testing using Kolmogorov-Smirnov and Shapiro-Wilk, correlation analysis with Spearman’s Rank and Pearson methods, simple regression analysis, and health data projection. In addition, the training covered data visualization and interpretation techniques, enabling participants to create meaningful charts, trendlines, and equations, culminating in group presentations where they analyzed selected disease indicators alongside relevant air quality parameters. Group presentations at the end of the workshop demonstrated participants’ understanding and practical application of the concepts taught throughout the sessions.
The sessions were delivered by Prof. Budi Haryanto, Prof. Indang Trihandini, Fajar Nugraha, M.K.M., Sifa Fauzia, M.K.M., and Eky Pramitha, S.K.M., combining theoretical insights with hands-on exercises to build practical skills in integrated data analysis.
One BPJS Kesehatan participant highlighted the impact of the workshop, saying:
“This training is very helpful and applicable to our daily work, providing new experience in processing data through Excel.”
Following its successful implementation in Jakarta and now Bandung, this program will also be expanded to other cities, including Surabaya, to continue strengthening local data capacity and accelerate the development of regional early warning systems for air quality and health risks.
