From Visual Analytics and Applications
Jump to navigation
Jump to search
2018 Mini-Challenge 2 Method
- 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.
 
- 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
|
|