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. From the view of trend change, we can oberserve there are two dramaticlly increase in both 2003 and 2009. In addition, 2 locations were taken into consideration of sampling extraction site since 2009. Especillay in Tansanee, it always occupies the largest value of chemical contamination in recent years. To prove whether the Kasios Furniture Company caused environmental damage to the Boonsong Lekagul Wildlife Preserve, we select the sample from recent 3 years and combined them with the maps. To be specific, we would like to view the measure performances in different locations in a treemap.