Difference between revisions of "ISSS608 2017-18 T3 Assign Weijie Jay Zheng"
(14 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
<div style=background:#5DADE2 border:#A3BFB1> | <div style=background:#5DADE2 border:#A3BFB1> | ||
− | <b><font size = 6; color="#8B4513"> VAST Challenge | + | <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:# | + | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:#F2E9A0; text-align:center;" width="25%" | |
; | ; | ||
− | [[ISSS608_2017- | + | [[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:# | + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" | |
; | ; | ||
− | [[ISSS608_2017- | + | [[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:# | + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" | |
; | ; | ||
− | [[ISSS608_2017- | + | [[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:# | + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F2E9A0; text-align:center;" width="25%" | |
; | ; | ||
− | [[ISSS608_2017- | + | [[ISSS608_2017-18_T3_Assign_Weijie_Jay_Zheng_Findings| <b><font size="2"><font color="#0B0B0B">Findings</font></font></b>]] |
| | | | ||
Line 26: | Line 26: | ||
<br/> | <br/> | ||
− | <font size="5"><font color="#8B4513">'''Stop Polluting the Boonsong Lekagul Wildlife | + | <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. | 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. | ||
Line 33: | Line 33: | ||
+ | == 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 | ||
− | + | </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 /> | |
− | <p>[[File: | + | # 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 /> | ||
− | |||
− | |||
− | + | 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 /> |
− | < | ||
− | <br> | ||
− | <br> | ||
− | + | === 3. The Joint Dataset === | |
− | <p>[[File: | + | 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 21:10, 8 July 2018
Link to go back to MITB class page
VAST Challenge 2018: Suspense at the Wildlife Preserve
|
|
|
|
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.
Contents
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
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
- Id
- Value
- Location
- Sample date
- Measure
The dataset of Chemical Unit of Measures contain 2 categories
- Measure
- Unit
3. The Joint Dataset
Tableau Prep is used to joint the 2 dataset provided to provide a single dataset file.