ISSS608 2016-17 T3 Assign Jan Patrick Mabilangan Gosioco Data Prep
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
Dashboard Design
1. Map Overview 2. The Chemical Trends 3. Location Analysis 4. Measure Analysis 5. Dataset Anomaly