ISSS608 2016-17 T3 Assign Chen Fan Data Preparation

VAST Challenge 2018:Like a Duck to Water

Background

Finding Clues

Insights

Conclusion

Finding Clues

We want to see the change between the past and most recent situation, so we can conduct heat map to do the visualization analysis. Firstly we can see the overall trend of all the chemical contaminants and then input another variable location to see in different location, whether we can see different changes. And the second way to do the visualization is to use the geo-map, which can give us a more direct visualization.

Processing Confusing Clues

Description	Illustration
1.Overview of the measures by year The measure values are changing in different year, trends can be spotted by making a chart of measure against year.It's an overview and an easily spotted dark blue can been observed in Iron. The value is extremely high
2. Handling the abnormal data By further exploring the details of the data, the abnormal data are collected in the same day and these high values(highlighted in blue) can't happen in the real world, these error data can be deleted because we using the average value, so it will not much influence our analysis.
3. Preparing the data for heat map For each measure, calculate the percentile because the values are different from measure to measure and we only want to see the trend. choose the complete data, which will better help us doing the analysis

Dashboard Design

Description	Illustration
1.Finding the Geo-code By giving the Geo-Code of the border of background image, then in the background image, we can by adding annotation to add Geo-code to each location. And we get the Geo-code of each location.
2.Join Tables Join the Geo-code table with the revised data table, then in the map, show the measure value of different measure. And because we have map, whether the station has influence on the water can be clearly seen.