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