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

From Visual Analytics and Applications
Jump to navigation Jump to search
 
(25 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<div style=background:#F6CECE border:#A3BFB1>
+
[[Assignment_Dropbox_G2|Link to go back to MITB class page]]
−
[[Image:Potential impacted areas.jpg|165px]]
+
<div style=background:#5DADE2 border:#A3BFB1>
−
<b><font size = 6; color="#8B4513"> VAST Challenge 2017:Mystery at the Wildlife Preserve </font></b>
+
 
 +
<b><font size = 6; color="#8B4513"> VAST Challenge 2018: Suspense at the Wildlife Preserve </font></b>
 
</div>
 
</div>
 
<!--MAIN HEADER -->
 
<!--MAIN HEADER -->
 
{|style="background-color:#FFF0F5;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 
{|style="background-color:#FFF0F5;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
−
| style="font-family:Century Gothic; font-size:100%; solid #000000; background:#FFF0F5; text-align:center;" width="25%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #000000; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2016-17_T3_Assign_GUAN_YIFEI|<b><font size="4"><font color="#8B4513">Background</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Problem_Statement|<b><font size="4"><font color="#0B0B0B">Problem Statement</font></font></b>]]
  
−
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2016-17_T3_Assign_GUAN_YIFEI_Data_Preparation|<b><font size="2"><font color="#BC8F8F">Methodology & Dashboard Design</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Dataset_Visulisation|<b><font size="2"><font color="#0B0B0B">Dataset Visualisation</font></font></b>]]
  
−
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2016-17_T3_Assign_GUAN_YIFEI_Visualization|<b><font size="2"><font color="#BC8F8F">Insights</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Data_Analysis_Proceeding|<b><font size="2"><font color="#0B0B0B">Data Analysis Proceeding</font></font></b>]]
  
−
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" |  
+
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" |  
 
;
 
;
−
[[ISSS608_2016-17_T3_Assign_GUAN_YIFEI_Conclusion| <b><font size="2"><font color="#BC8F8F">Conclusion</font></font></b>]]
+
[[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Findings| <b><font size="2"><font color="#0B0B0B">Findings</font></font></b>]]
  
 
|  &nbsp;
 
|  &nbsp;
Line 25: Line 26:
 
<br/>
 
<br/>
  
−
<font size="5"><font color="#8B4513">'''Problem Statement'''</font></font>
+
<font size="5"><font color="#8B4513">'''Stop Polluting the Boonsong Lekagul Wildlife Preserves'''</font></font>
 +
 
 +
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.
 +
 
 +
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.
 +
 +
 
 +
== Mini Challenge 2 - What do we have and what do we want to find out ==
 +
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. 
 +
 
 +
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
  
−
The Boonsong Lekagul Nature Preserve is used by local residents and tourists for day-trips, overnight camping or sometimes just passing through to access mai
+
</gallery>
  
 +
=== 2. Overview of the Dataset ===
 +
Tableau Prep is used for data overview and initial data cleaning.<br />
  
−
==Mini Challenge 1 Background==
+
The Boonsong Lekagul Waterways Reading dataset contains 5 categories<br />
−
View the interactive Tableau design here: [https://public.tableau.com/profile/yifei2012#!/vizhome/Updated1/VASTChallenge2017MC1 Link to tableau dashboard]
+
# 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 />
  
−
<br> <b> Before we start, what do you need to know? </b>
 
  
−
1. The Gates
+
The dataset of Chemical Unit of Measures contain 2 categories <br />
−
<br>Based on the data description and reserve map, the restricted gates are highlighted in red.
+
# Measure<br />
−
<p>[[File:GYF_the_gates.png|600px|center]]</p>
+
# Unit<br />
 +
<br />
  
−
2. The time
+
<p>[[File:Dataset OVerview - Chemical Units of Measures.jpg|300px|left]]</p><br />
−
<p>[[File:GYF_timeframe.png|250px|center]]</p>
+
<br />
  
−
3. The Cars
+
=== 3. The Joint Dataset ===
−
<p>[[File:gyf_cars.png|200px|center]]</p>
+
Tableau Prep is used to joint the 2 dataset provided to provide a single dataset file.<br />
  
−
4. The Visitors
 
−
The visitors were segmented as follows based on the nature of their movements in the reserve.
 
−
<p>[[File:gyf_m_1.png|400px|center]]</p>
 
−
The graph below shows the composition of each cluster by car types.
 
−
<p>[[File:gyf_m_10.png|400px|center]]</p>
 
  
−
5. The Data
+
<p>[[File:Tableau Data Joining.jpg|800px |left]]</p><br />
−
<br> Timestamp: the date and time the sensor reading was taken
 
−
<br> Car-id:  the assigned car ID from the entry gate
 
−
<br>Car-type: Vehicle type as enumerated above.  “P” is appended when it is a park vehicle
 
−
<br>Gate-name:  name of the sensors taking the reading.  See the map
 
  
−
6. The Reserve Map
+
<br />
−
<p>[[File:gyf_map_background.png|450px|center]]</p>
 

Latest revision as of 21:10, 8 July 2018

Link to go back to MITB class page

VAST Challenge 2018: Suspense at the Wildlife Preserve

Problem Statement

Dataset Visualisation

Data Analysis Proceeding

Findings

 


Stop Polluting the Boonsong Lekagul Wildlife Preserves

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.(MC2 Challenge Overview). The soil has since not been able to use for evidence, as construction work was conducted on the site.

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.


Mini Challenge 2 - What do we have and what do we want to find out

2 Datasets are provided by Mistford College Hydrology
- Boonsong Lekagul Waterway Readings
- Chemical Units of Measures

In addition, the College has also provided a map of the Preserve with named sampling sites indicated on the map.

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.

All the dataset and maps have been incorporated into Tableau available via: WJZ's MC2 Tableau

1. The Map

The map provides a few key infomation
- the location of dump waste
- the sampling point
- the streams of waterflow
The information above will help form an understanding the business context

  • Preserve Waterway Map

2. Overview of the Dataset

Tableau Prep is used for data overview and initial data cleaning.

The Boonsong Lekagul Waterways Reading dataset contains 5 categories

  1. Id
  2. Value
  3. Location
  4. Sample date
  5. Measure


Dataset Overview - Boonsong Lekagul Waterways Readings.jpg





The dataset of Chemical Unit of Measures contain 2 categories

  1. Measure
  2. Unit


Dataset OVerview - Chemical Units of Measures.jpg



3. The Joint Dataset

Tableau Prep is used to joint the 2 dataset provided to provide a single dataset file.


Tableau Data Joining.jpg



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