Difference between revisions of "ISSS608 2017-18 T3 Assign ONG WAH JIE Data Preparation"
Line 16: | Line 16: | ||
[[File:Owj-d_(5).png|250px|center|border]] | [[File:Owj-d_(5).png|250px|center|border]] | ||
[[File:Owj-d_(6).png|250px|center|border]] | [[File:Owj-d_(6).png|250px|center|border]] | ||
+ | |||
+ | ==2. Import data into tableau== | ||
+ | The “Boonsong Lekagul waterways readings” file and the “Location” file mentioned above were connected to tableau. | ||
+ | |||
+ | The “left join” function was used to join these 2 data sets together. | ||
+ | [[File:Owj-d_(7).png|400px|center|border]] | ||
+ | |||
+ | ==3. Calendar Plot== | ||
+ | The calendar plot can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below. | ||
+ | |||
+ | The year(sample date) was filtered for the period 2011 – 2016. | ||
+ | [[File:Owj-d_(8).png|400px|center|border]] | ||
+ | |||
+ | ==4. Chemical (readings)== | ||
+ | A calculated field 3_times_SD was created to calculate the value 3 times of standard deviation. | ||
+ | [[File:Owj-d_(9).png|250px|center|border]] | ||
+ | |||
+ | The chemical (readings) can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below. | ||
+ | [[File:Owj-d_(10).png|800px|center|border]] | ||
+ | |||
+ | To add in the average line and 3 x standard deviation line above, right click on the y-axis and select add in reference line. The box below will appear. | ||
+ | |||
+ | Do this for average line | ||
+ | [[File:Owj-d_(11).png|250px|center|border]] | ||
+ | |||
+ | Do this for 3x standard deviation line | ||
+ | [[File:Owj-d_(12).png|250px|center|border]] | ||
+ | |||
+ | ==5. Chemical (readings by location)== | ||
+ | The chemical (readings by location) can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below. | ||
+ | [[File:Owj-d_(13).png|800px|center|border]] | ||
+ | |||
+ | ==6. Chemical Overview Dashboard== | ||
+ | This was created by dragging the “chemical (readings)” and “chemical (readings by locations)” worksheets into the dashboard as shown in the diagram below. | ||
+ | [[File:Owj-d_(14).png|800px|center|border]] |
Revision as of 21:52, 8 July 2018
Contents
Data Prep
1. Creating waterway map and location.csv
Import a location.csv file as shown below into tableau.
Select according to the print-screen below to get the image of the waterway to appear in tableau.
Click ok
Drag line which appears with the box to the tip of the arrows to get the x and y coordinates of the locations.
Populate the locations with the x and y coordinates obtained.
2. Import data into tableau
The “Boonsong Lekagul waterways readings” file and the “Location” file mentioned above were connected to tableau.
The “left join” function was used to join these 2 data sets together.
3. Calendar Plot
The calendar plot can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below.
The year(sample date) was filtered for the period 2011 – 2016.
4. Chemical (readings)
A calculated field 3_times_SD was created to calculate the value 3 times of standard deviation.
The chemical (readings) can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below.
To add in the average line and 3 x standard deviation line above, right click on the y-axis and select add in reference line. The box below will appear.
Do this for average line
Do this for 3x standard deviation line
5. Chemical (readings by location)
The chemical (readings by location) can be created by following the “filters”, “marks”, “columns” and “rows” fields as shown in the diagram below.
6. Chemical Overview Dashboard
This was created by dragging the “chemical (readings)” and “chemical (readings by locations)” worksheets into the dashboard as shown in the diagram below.