ISSS608 2016-17 T3 Assign Jan Patrick Mabilangan Gosioco Data Prep

VAST Challenge 2018: Suspense at the Wildlife Preserve

Background
Data Preparation & Dashboard Design
Insights
Conclusion

Data Preparation & Dashboard Design

Data Preparation

1. Create a Location.csv with the following fields and input starting values for the map borders LL, LR, UR, and UL. location: location of the water sensor reading X: x coordinate of the location with respect to the waterways map Y: y coordinate of the location with respect to the waterways map

2. Derive the X and Y coordinates of the locations by loading the map into Tableau and annotating the points.

3. Update Location.csv with the derived coordinates

4. Import the Location.csv, Boonsong Lekagul waterways readings.csv, and chemical units of measure.csv files to Tableau, performing the join as follows:

- Join on equal location fields for Location.csv

- Join on equal measure fields for chemical units of measure.csv