Services on Demand
Article
Indicators
Related links
- Cited by Google
- Similars in Google
Share
Clean Air Journal
On-line version ISSN 2410-972X
Print version ISSN 1017-1703
Abstract
WRIGHT, Caradee Y. and WERNECKE, Bianca. Using Microsoft© Power BI© to visualise Rustenburg Local Municipality's Air Quality Data. Clean Air J. [online]. 2020, vol.30, n.1, pp.1-5. ISSN 2410-972X. http://dx.doi.org/10.17159/caj/2020/30/1.7512.
Microsoft© Power BI© is a business analytics tool that visualises data in an accessible manner. It creates visual data reports quickly in a series of panels to give an overview of data while still offering access to more sophisticated visualisation methods too. While statistical tools, like R and MatLab, remain the 'gold standard' for analysing air quality data, simple methods to visualise data are also helpful. Here, we explored the use of Power BI Desktop© to visualise and interpret air quality data for the Rustenburg Local Municipality. Rustenburg is in the Waterberg-Bojanala Priority Area - the third air pollution priority area for air quality management. Ambient PM10 data for three towns, namely, Thlabane, Marikana and Boiketlong, were obtained for six years (2013-2018) in South Africa. Data underwent quality control before being imported into Power BI©. A four-panel dashboard was generated to show (in) compliance with the daily and annual average South African National Ambient Air Quality Standard for PM, annual and average concentrations, frequency of exceedances and a summary of data availability by site. Generally, PM10 data quantity and quality were poor and where data were available, concentrations were high. This type of data visualisation tool can be applied with relative ease by Air Quality Officers and Environmental Health Practitioners for a snapshot overview of the air quality in their area of jurisdiction. The interactive dashboard is also useful for making graphics for policy documents and reports.
Keywords : air pollution; environmental health; South Africa; Waterberg Priority Area.