Difference between revisions of "ISSS608 2017-18 T3 Assign VISHALI REDDY NALLA - Visualisations"
Line 59: | Line 59: | ||
To analyze the trend of chemical measures from past to most recent, I grouped consecutive 4 years into single Year group from 1998-2016. | To analyze the trend of chemical measures from past to most recent, I grouped consecutive 4 years into single Year group from 1998-2016. | ||
+ | |||
+ | [[Image:Picture10 Vi.png|800px]] | ||
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. | 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. | ||
+ | |||
+ | [[Image:Picture11 Vi.png|800px]] | ||
<b>3) Drill Down for the details in Trend</b> | <b>3) Drill Down for the details in Trend</b> | ||
Line 67: | Line 71: | ||
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. | 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. | ||
+ | |||
+ | [[Image:Picture12 Vi.png|800px]] | ||
<b>4) Which Locations have higher contamination?</b> | <b>4) Which Locations have higher contamination?</b> | ||
Line 73: | Line 79: | ||
Challenges - For few locations which don’t have readings are not reflected in the graph. | Challenges - For few locations which don’t have readings are not reflected in the graph. | ||
+ | |||
+ | [[Image:Picture13 Vi.png|800px]] | ||
<b>5) Waterways Map</b> | <b>5) Waterways Map</b> | ||
Line 78: | Line 86: | ||
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. | 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. | 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. | ||
+ | |||
+ | [[Image:Picture14 Vi.png|400px]] | ||
<b>6) Are there sufficient readings taken to analyze the trend?</b> | <b>6) Are there sufficient readings taken to analyze the trend?</b> | ||
Line 83: | Line 93: | ||
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. | 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. | 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. | ||
+ | |||
+ | [[Image:Picture15 Vi.png|800px]] | ||
Revision as of 11:49, 8 July 2018
|
|
|
|
|
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.