ISSS608 2017-18 T3 Assign VISHALI REDDY NALLA - Visualisations
VAST Mini Challenge 2 – Like a Duck to Water
|
|
|
|
|
|
| CONTENT |
|---|
1. Visualisations
I created the following visuals in Tableau to study the chemical contamination in Boongsong Lekagul Wildlife Preserve.
1) Groups
I created Chemical Groups Overview graph inspired from Tiles Chart that I used it as a filter to drill down to list of only those chemicals which belong to that group.
To create the Tiles with Chemical groups, I manually assigned X & Y Coordinates to all the Chemical groups using the calculated fields Group_Xcoor & Group_Ycoor. Then mapped the chemicals groups according to the coordinates assigned and colored using chemical groups.
2) Trend of Chemical Contamination Over Years
To analyze the trend of chemical measures from past to most recent, I grouped consecutive 4 years into single Year group from 1998-2016.
Then I plotted a line graph with percentage change of average value of measure readings from previous year group which shows if the chemical measures have increased or decreased or remained constant in recent times (2014-2016). This graph is to quickly analyze the chemicals of concern and ignore chemicals which have remained stable over years.
3) Drill Down for the details in Trend
This is a replica of the “Trend of Chemical Contamination Over Years” which a few modifications. This chart has detail analysis on Year -> Quarter -> Month for the selected Chemical Measure and Year Group.
Challenges – Not all chemical measures have readings every month or every year, therefore for few chemical measures, we can see blank spaces which means no readings were taken in that time period.
4) Which Locations have higher contamination?
To see Areas which are more contaminated, I plotted the average value of the chemical measure with respect to the Locations as an Area Graph. In the Area Graph, each Location is colored separately so we can clearly analyze which Locations have higher values.
Challenges - For few locations which don’t have readings are not reflected in the graph.
5) Waterways Map
To see which waterways are most effected I plotted the average values over a specified time period for a chemical measure with the background image as Waterways Map against Xcoord and Ycoord derived in the data preparation. With this Map, we can also see the effect of a chemical measure for the surrounding locations. Additionally, we can see the proximity of location to the dumping site.
6) Are there sufficient readings taken to analyze the trend?
Now that we have seen the locations which are most effected by a chemical measure, now the question is to see if the recordings are sufficient enough to say that the location is actually effected by the chemical. To see the number of readings taken for a chemical over a time period, I plotted a heat map showing number of readings Location wise.
