Difference between revisions of "ISSS608 2017-18 T3 Assign Xie Zhimao Method"
Jump to navigation
Jump to search
(2 intermediate revisions by the same user not shown) | |||
Line 62: | Line 62: | ||
|| | || | ||
*Use filter and pivot table function in Microsoft Excel extract out the data we need and rename them as revised value(μg/l). | *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| | + | *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
|