Abstract:
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 PM10, 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.
