Pollution Data Analysis

Key Requirement: Given a dataset, provide key observations on data integrity and conclusions on environmental behavior.

Delivered: Data cleansing and report using PowerBI for visualisations.

A dataset was used from the US Environmental Pollution Agency (EPA) containing measurements taken in 7 US Counties of the level of pollutants and their Air Quality Index for Ozone, Carbon Monoxide, Nitrogen Dioxide and Sulphur Dioxide. Z-Score consolidation was processed and results visualised to show data gaps within groupings although these didn’t detract from conclusions showing inverse dependency of Ozone to the other 3 pollutants.

  • Exploratory Data Analysis (EDA)
  • PowerBI with data cleansing
  • Z-Score consolidation of non-homogenous metrics for comparison of variances
  • Visualisation shows patterns enabling conclusions on dependencies