ISSS608 2017-18 T3 Assign Xie Zhimao Method

   2018 Mini-Challenge 2 Method

Overview

Data Preparation

Visualization

Conclusion

Tools Description

SAS JMP Pro Microsoft Excel Tableau

No.	Approach	Description
1.	SAS JMP Pro ( Data Exploration)	Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data. We found the missing data is 0 and there is no obviously unreasonable skewed distribution, so our initial clean step is complete. However, when it refers to chemical units of measure, we noticed there are different units, such as mg/l and μg/l. Therefore, we need further data wrangling by use Microsoft Excel.
2.	Microsoft Excel (Data Wrangling)	Use filter and pivot table function in Microsoft Excel extract out the data we need and rename them as revised value(μg/l). Given thr geographical analysis we also record the geo-code of background image in the data file.
3.	Tableau (Data Analysis)	Import raw data into Tableau and inner join the geo-code.