ISSS608 2017-18 T3 Assign Kaushik Jaganathan - Methodology and Design

ISSS608 2017-18 Mini Challenge 2 - Kaushik Jaganathan

Introduction

Methodology & Design

Insights & Conclusion

Assignment Dropbox

Data description & preparation

File Name	Variables
Boonsong Lekagul waterways readings (.csv file)	The given data file has reading of 106 chemicals at 10 different locations from 1998 - 2016. i. id (numeric , unique) ii. value (numeric) iii. location (string) iv. sample date (string) v. measure (string)
chemical units of measure (.csv file)	The given data file has the unit of each measure (106 measures) in which the readings were taken. i. measure (string, unique) ii. unit (string)
Waterways Final (.jpg file)	The Waterways Final is a map image that shows the location of dumping site and the waterways.

Steps	Image
Adding Data and Background Image Open Boonsong Lekagul waterways readings (.csv file) in Tableau, right click on Location Dimension, click on Geographic Role and select ZIP Code / Postcode. This will generate Latitude and Longitude in Measures. Add the generated fields to Columns and Rows respectively. Go to Map options and click on Background Images. In the dialogue box, browse the Waterways Final (.jpg file). In the X Field set Right value to 499 and in the Y Field set the Top value to 499. Go to options and select Always show entire image option and Apply.
Annote Point Create a new excel file Locations, add a column named Location and manually enter the places. Add other two column named X and Y. Right click on the tip of the arrow on map, click on Annotate and select Point. In the dialog box, insert fields Latitude(generated) and Longitude(generated). Manually copy paste the annotated values in the Location.xlsx file, X and Y columns. Do this for all the locations.

Dashboard Design
View the interactive Tableau design here: Link to tableau dashboard

1.Chemical Trends

This dashboard is aimed to uncover the trends in chemical values across Boonsong Preserve Waterway.Sampling sites and time period are used as filters.

The map shows the average value of a chemical for a selected time period. Box plot gives the variation in values for the chemical and date range chosen. The trend plot takes the selected location from map,time and measure from the filter and shows the variation over time.

2.Chemical Anomalies

3.Sample Collection

4.Sampling Frequency

5.Sampling trends and anomalies