ISSS608 2018-19 T1 Assign Wang Yixuan Data Preparation
Air Pollution Analysis in Sofia City
|
|
|
|
|
|
|
Official Air Quality Measurements(EEA Data)
The EEA data set consist of the air quality data of 6 different air quality stations in Sofia city, as well as the metadata including the longitude and latitude, code information of the 6 air quality stations. The data is collected from Jan 2013 to Sep 2018. To better analyse the past and most recent situation of air quality in Sofia city, we need to join all the separate worksheet together with metadata using Tableau.
Drag and drop all the air quality data into Tableau.
Because the worksheets share same columns, they will be concatenated together. And then we join the concatenated worksheet with metadata table with left joint method. Take note that we need to set a main key to make sure the data is joint properly.
Here we use "Air Quality Station" as the key to left join two table.
