ISSS608 2017-18 T3 Assignment SHI CHEN Data Exploratory
Contents
Methodology
Workflow
I. Data preparation: Combine three tables together to get full picture of changes in all observation years, observation location and chemicals. (pic 1) II. Geographical preparation: there is a topographic map in this area. But there’s no other information like latitude and longitude. It should only be used to generate relative coordinates for each observation location. (pic 2)
III. Data exploration: The geography, the number of species, the number and type of measurement, the number of detections, and the timeline are combined together to explore, to discover their associations and identify the potential factors affecting birds.
IV. Statistical application: To find out the abnormal chemical elements faster, in addition to looking at the change values of each substance in turn, I also introduced the concept of Z-score to assist the judgment. (pic 3)
The larger the value of z score, the greater the volatility that represents it.
V. Final deliverable: This challenge analysis was done in tableau. Link:
Tool
- Tableau
- JMP
References
Hydrological measurements - published by Important India | https://ocw.tudelft.nl/courses/hydrological-measurements/ |
TBC - published by Data2X | TBC |