ISSS608 2017-18 T3 Assign Yang Zhengyan Methdology
Mini-Challenge 2 : Like a Duck to Water
|
|
|
|
|
|
Methodology
|
Methodology |
Description |
|
|
Compare with average |
There are different average levels of each measure and it is easier and more accurate to compare with average level at different locations. If some measures values are more than average and increase consistently. There is a potential probability of pollution at specific locations. We edit the formula in tableau and add one measure variable, called “more than average" and "less than average", the formula as below:
| |
|
Waterway Analysis |
There are some four main waterways in Boonsong Lekagual map. First one is Decha, second is Tansanee, the third one includes Somchair, Achara, Somchair, Sakda, and remaining 5 is one path. If there is a potential contaminant, it may impact the locations in the same path with water flow. But we still need to consider the soil absolution will reduce the values along the waterways.  | |
|
Time Analysis |
Different measures in a different location with time changes are the main method to be applied. We can incorporate the reading values changing along with time analysis to find out insights. In tableau, the following formula are able to add <50%, >50%, >75%, >90% respectively.  |
