Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"
Jump to navigation
Jump to search
(4 intermediate revisions by the same user not shown) | |||
Line 48: | Line 48: | ||
1. | 1. | ||
|| | || | ||
− | SAS JMP Pro<br> ( Data | + | SAS JMP Pro<br> |
+ | ( Data Exploration) | ||
|| | || | ||
*Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data.<br>[[File:Zhimao3.png|500px]][[File:Zhimao4.png|500px]] | *Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data.<br>[[File:Zhimao3.png|500px]][[File:Zhimao4.png|500px]] | ||
Line 60: | Line 61: | ||
(Data Wrangling) | (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.[[File:Zhimao5.png|200px]] | ||
|- | |- | ||
| | | | ||
3. | 3. | ||
|| | || | ||
− |   Tableau | + |   Tableau<br> |
+ | (Data Analysis) | ||
|| | || | ||
− | + | *Import raw data into Tableau and inner join the geo-code.[[File:Zhimao6.png|500px]] | |
+ | <br> | ||
+ | *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.<br> | ||
+ | [[File:Zhimao7.png|800px|center]] | ||
+ | <br> | ||
+ | *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.<br> | ||
+ | [[File:Zhimao8.png|800px|center]] | ||
+ | <br> | ||
+ | *To be specific, we would like to view the measure performances in different locations in a treemap. | ||
+ | [[File:Zhimao9.png|800px|center]] | ||
|- | |- | ||
|} | |} | ||
</div> | </div> |
Latest revision as of 22:02, 7 July 2018
|
|
|
|
Tools Description
|