MU FUYAO Data Preparation

ISSS608 Assignment MU FUYAO - MC2

Overview

Data Preparation

Analytical Results

Questions-answer

Data Preparation

Tools

1.JMP

Problems	Solutions
1.Missing value and repetitive value There are some measures having value of 0, I can’t decide whether the measurement is 0 or didn’t have measure. So, I regard it as missing value and delete. There are some strange values in this dataset. For same location, same time and same measure, but there are different values. I think it’s repetitive value. So, I get average of them.
2.Wrong format of years In JMP, it can’t recognize year before 2000. So, for year 1998 and 1999 it will show 2098 and 2099, I have to recode it by myself.

2.Tableau

Method	Graph
1.Combine different tables I use three different excel (csv) table in tableau, first I should combine them together then I can use them to draw graph
2.Make a map for location If I want to make sure of location for different cities, I have to do telltale mark. And connect it with other tables. Then I can find exactly location for these 10 cities.