IS428 2018-19 T1 Assign Cliff Halim Tirtamaya
Revision as of 17:22, 3 November 2018 by Cliffhalimt.2014 (talk | contribs)
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
WIP
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/)
