Using Microsoft© Power BI© to visualise Rustenburg Local Municipality’s Air Quality Data

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. Here, we explored the use of Power BI Desktop© to visualise and interpret air quality data for the Rustenburg Local Municipality. Rustenburg is located in the Waterberg-Bojanala Priority Area – the third air pollution priority area for air quality management. Ambient PM₁₀ data for three cities, namely, Thlabane, Marikana and Boiketlong, were obtained for six years (2013-2018). 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, PM₁₀ 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.