ISSS608 2017-18 T3 Assign Xie Zhimao Method

From Visual Analytics and Applications
Jump to navigation Jump to search

Zhimao2.jpg    2018 Mini-Challenge 2 Method

Overview

Data Preparation

Visualization

Conclusion



Tools Description

  • SAS JMP Pro
  • Microsoft Excel
  • Tableau

No.

 Approach

  Description

1.

SAS JMP Pro
( Data Understanding)

  • Use SAS JMP Pro to open the metadata and check the ditribution and validity of the data.
    Zhimao3.pngZhimao4.png
  • We found the missing data is 0 and there is no obviously unreasonable skewed distribution, so our initial clean step is complete.
  • However, when it refers to chemical units of measure, we noticed there are different units, such as mg/l and μg/l. Therefore, we need further data wrangling by use Microsoft Excel.

2.

Microsoft Excel
(Data Wrangling)

3.

  Tableau