Air pollution is not only an environmental issue but also a pressing public health concern. The need to integrate air quality and health data has become increasingly important to better understand how air quality affects disease occurance and to develop early warning systems that enable faster and more ffective preventive measures.
As part of this effort, RCCC UI, with the support of ViriyaENB, held a capacity-building training on integrated data analysis using Microsoft Excel for stakeholders who work with air quality and health-related data. The training aimed to enhance participants’ ability to process and utilize data, strengthening cross-sector collaboration in addressing air pollution and its health impacts.
Participants included representatives from the Pusat Data dan Informasi (Pusdatin) Kementerian Kesehatan, Direktorat Kesehatan Lingkungan Kementerian Kesehatan, Direktorat Perlindungan dan Pengelolaan Mutu Udara Kementerian Lingkungan Hidup, BPJS Kesehatan, BMKG, Badan Riset dan Inovasi Nasional (BRIN) Pusat Riset Iklim dan Atmosfer dan Dinas Kesehatan Provinsi DKI Jakarta, dan Dinas Lingkungan Hidup Provinsi DKI Jakarta.
The training 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., covering both theoritical foundations and practical exercises on integrated data analysis.
Throughout the two-day sessions, participants explored:
Fundamental concepts of outliers, normality tests, correlation, and simple regression.
Practical applications of Excel in cleaning and analyzing health and air quality datasets.
Projections and data visualization, including trendlines and interpretation of results.
Group exercises on integrating disease data with air quality parameters.
The training provided hands-on experience and emphasized the importance of integrating health and environmental data to strengthen evidence-based policymaking. By enhancing these analytical skills, participants are better equipped to contribute to improving air quality and protecting public health.
