IS428 2018-19 T1 Assign Cliff Halim Tirtamaya
Contents
Problem & Motivation
WIP
Dataset Analysis & Transformation Process
Official Air Quality (EEA Data)
The EEA Dataset comprises of air quality data for Sofia in separate spread sheets according to years.
- Need to combine datasets
- Similar headings
- Use Command Prompt copy function
Link: http://www.tomnash.eu/how-to-combine-multiple-csv-files-into-one-using-cmd/
- Daily Air data and Metadata are left-joined to Daily Air data on Air Quality Station - the unique identifier for each of the 6 stations.
- Changed DateTime Begin and End dimensions to Date & Time type of dimension
Link of Google Map of Sofia: https://www.google.com.sg/maps/place/Sofia+City+Province,+Bulgaria/@42.6860472,23.3214962,10.96z/data=!4m5!3m4!1s0x40aa868332a0a5a3:0x300a01269bf4d70!8m2!3d42.7570109!4d23.4504683
Dataset Import Structure & Process
WIP
Interactive Visualization
WIP
| Table Example | WIP | WIP |
|---|---|---|
|
| ||
|
| ||
|
|
Home Dashboard
WIP
Main Tasks
WIP
Task 1: Spatio-temporal Analysis of Official Air Quality
Based on the Official Air Quality data (EEA dataset), the average pollutant concentration levels of 5 out of the 6 stations have been on a decreasing trend since the beginning of 2018. With the exception of a spike at the end of January 2018, the trend has been on a general decline as showcased by the trendline in the chart below. This implies that air quality has generally improved in Sofia city.
From the start of February 2018, average concentration levels have remained below 50 μg/m3, the limit of EU standard. These levels have been fluctuating within a range of 10-40 μg/m3 till beginning of September 2018.
Both concentration line charts here
Anomalies found in dataset are:
- Weekly and hourly data for year of 2017 is missing.
- Spikes are usually at the end and beginning of the year
Task 2: Spatio-temporal Analysis of Citizen Science Air Quality Measurements
WIP
Task 3: External Factors
WIP
References
In the completion of the analysis, the following references have been extremely useful:
- Tableau Training Video - Polygon Maps (http://www.tableau.com/learn/tutorials/on-demand/polygon-maps-8.2)
- Tableau Training Video - Background Images (http://www.tableau.com/learn/tutorials/on-demand/background-images-8)
- Creating Custom Polygons On A Background Image (https://tableauandbehold.com/2015/04/13/creating-custom-polygons-on-a-background-image/)
- Dynamically Switch Images Using Filters (https://community.tableau.com/message/182926#182926)
- Tableau Tip Week - Dashboard Navigation Buttons (http://www.thedataschool.co.uk/niccolo-cirone/tableau-tip-week-wednesday-creating-dashboard-navigator-buttons/)
