ISSS608 2017-18 T3 Assign Weijie Jay Zheng Problem Statement

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

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
   

The dataset of Chemical Unit of Measures contain 2 categories

1. Measure
   
2. Unit
   

3. The Joint Dataset

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