Difference between revisions of "ISSS608 2017-18 T3 Assign Weijie Jay Zheng Findings"

From Visual Analytics and Applications
Jump to navigation Jump to search
(Created page with "Link to go back to MITB class page <div style=background:#5DADE2 border:#A3BFB1> <b><font size = 6; color="#8B4513"> VAST Challenge 2018: Suspense a...")
 
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
[[Assignment_Dropbox_G2|Link to go back to MITB class page]]
+
[[Assignment_Dropbox_G1|Link to go back to MITB class assignment page (Group 1)]]
 
<div style=background:#5DADE2 border:#A3BFB1>
 
<div style=background:#5DADE2 border:#A3BFB1>
  
Line 12: Line 12:
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Dataset_Visulisation|<b><font size="2"><font color="#0B0B0B">Dataset Visualisation</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Dataset_Visulisation|<b><font size="4"><font color="#0B0B0B">Dataset Visualisation</font></font></b>]]
  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Data_Analysis_Proceeding|<b><font size="2"><font color="#0B0B0B">Data Analysis Proceeding</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Data_Analysis_Proceeding|<b><font size="4"><font color="#0B0B0B">Data Analysis Proceeding</font></font></b>]]
  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Findings| <b><font size="2"><font color="#0B0B0B">Findings</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Findings| <b><font size="4"><font color="#0B0B0B">Findings</font></font></b>]]
  
 
|  &nbsp;
 
|  &nbsp;
Line 26: Line 26:
 
<br/>
 
<br/>
  
−
<font size="5"><font color="#8B4513">'''Stop Polluting the Boonsong Lekagul Wildlife Preserves'''</font></font>
+
The finding is presented in Tableau's Dashboard [https://public.tableau.com/profile/jay8819#!/vizhome/MC2-WJZSolution/Dashboard1?publish=yes]<br />
  
−
In MC Challenge 2017, the Kasios Furniture Company was implicated in environment damage to the Boonsong Lekagul Wildlife for both dumping toxic waste and polluting the air with chemicals from its manufacturing process.([http://vacommunity.org/VAST+Challenge+2018+MC2 MC2 Challenge Overview]). The soil has since not been able to use for evidence, as construction work was conducted on the site.
+
== Objectives Review ==
  
−
With a hope to find out alternative evidence for Kasio's environment damage, the Mistford College Hydrology Department has provided a dataset of water sensor readings from rivers and streams in the preserve. The assignment is simple and clear - analyse the dataset to find any evidence to support the claim against Kasio's environment damage.
+
3 major focuses of the study
−
+
* Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways.<br />
 +
* Any anomalies from the dataset? How does it affect the analysis?<br />
 +
* Would any of the finders cause particular concern for the Pipit or other wildlife.<br />
  
−
== Mini Challenge 2 - What do we have and what do we want to find out ==
+
The exercise started by analyzing the historical trend for all locations and all chemicals in the last 20 years. As the data analysis proceeded, the focus was gradually narrowed down to what matters - is there any evidence contamination. At the end, the investigation narrowed down to 3 chemicals (Anionic active surfactants, Chemical Oxygen Demand(Cr), and Methylosmoline) for the Kohsoom area, which happen to be the closest sampling point to the dump waste. From the chart below, it is evident that these 3 chemical experienced substantial increase after 2010, as compared to its historical levels.
−
2 Datasets are provided by Mistford College Hydrology<br />
 
−
- Boonsong Lekagul Waterway Readings<br />
 
−
- Chemical Units of Measures<br />
 
  
−
In addition, the College has also provided a map of the Preserve with named sampling sites indicated on the map.
+
It is likely that Kohsoom may have been contaminated by dump waste, with the evidence of the elevated readings for the 3 chemicals. The findings could however be insufficient for evidence establishment purpose. There is no evidence whether the upward trend was an independent event, e.g. natural change of the water; neither is there any evidence that the dump waste had any correlation for these 3 chemicals. Subject experts will need to be brought in to
 +
* validate the scientific factors behind the trend, e.g. due to inherenent change, or due to external impact<br />
 +
* validate if the dump waste has any scientific relationship with the 3 chemicals. <br />
  
−
3 major focuses of the study<br />
 
−
- Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways.<br />
 
−
- Any anomalies from the dataset? How does it affect the analysis?<br />
 
−
- Would any of the finders cause particular concern for the Pipit or other wildlife.<br />
 
  
−
All the dataset and maps have been incorporated into Tableau available via: [https://public.tableau.com/profile/jay8819#!/vizhome/MC2-WJZSolution/Dashboard1?publish=yes WJZ's MC2 Tableau]<br />
 
−
<br />
 
  
−
=== 1. The Map ===
 
−
The map provides a few key infomation<br />
 
−
- the location of dump waste<br />
 
−
- the sampling point<br />
 
−
- the streams of waterflow<br />
 
−
The information above will help form an understanding the business context
 
−
<gallery>
 
−
File:WJZ Waterway Pic.jpg|Preserve Waterway Map
 
  
−
</gallery>
 
  
−
=== 2. Overview of the Dataset ===
 
−
Tableau Prep is used for data overview and initial data cleaning.<br />
 
  
−
The Boonsong Lekagul Waterways Reading dataset contains 5 categories<br />
 
−
# Id<br />
 
−
# Value<br />
 
−
# Location<br />
 
−
# Sample date <br />
 
−
# Measure<br />
 
−
<br />
 
−
<p>[[File:Dataset Overview - Boonsong Lekagul Waterways Readings.jpg|300px|left]]</p><br />
 
−
<br />
 
−
<br />
 
  
−
 
+
<p>[[File:WJZ MC2 Findings.jpg|800px |left]]</p><br />
−
The dataset of Chemical Unit of Measures contain 2 categories <br />
 
−
# Measure<br />
 
−
# Unit<br />
 
−
<br />
 
−
 
 
−
<p>[[File:Dataset OVerview - Chemical Units of Measures.jpg|300px|left]]</p><br />
 
−
<br />
 
−
 
 
−
=== 3. The Joint Dataset ===
 
−
Tableau Prep is used to joint the 2 dataset provided to provide a single dataset file.<br />
 
−
 
 
−
 
 
−
<p>[[File:Tableau Data Joining.jpg|800px |left]]</p><br />
 
−
 
 
−
<br />
 

Latest revision as of 23:36, 8 July 2018

Link to go back to MITB class assignment page (Group 1)

VAST Challenge 2018: Suspense at the Wildlife Preserve

Problem Statement

Dataset Visualisation

Data Analysis Proceeding

Findings

 


The finding is presented in Tableau's Dashboard [1]

Objectives Review

3 major focuses of the study

  • Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways.
  • Any anomalies from the dataset? How does it affect the analysis?
  • Would any of the finders cause particular concern for the Pipit or other wildlife.

The exercise started by analyzing the historical trend for all locations and all chemicals in the last 20 years. As the data analysis proceeded, the focus was gradually narrowed down to what matters - is there any evidence contamination. At the end, the investigation narrowed down to 3 chemicals (Anionic active surfactants, Chemical Oxygen Demand(Cr), and Methylosmoline) for the Kohsoom area, which happen to be the closest sampling point to the dump waste. From the chart below, it is evident that these 3 chemical experienced substantial increase after 2010, as compared to its historical levels.

It is likely that Kohsoom may have been contaminated by dump waste, with the evidence of the elevated readings for the 3 chemicals. The findings could however be insufficient for evidence establishment purpose. There is no evidence whether the upward trend was an independent event, e.g. natural change of the water; neither is there any evidence that the dump waste had any correlation for these 3 chemicals. Subject experts will need to be brought in to

  • validate the scientific factors behind the trend, e.g. due to inherenent change, or due to external impact
  • validate if the dump waste has any scientific relationship with the 3 chemicals.




WJZ MC2 Findings.jpg


Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Findings&oldid=9363’