Difference between revisions of "ISS608 2017-18 T3 G2 Assign ChenYanchong Visualization"
Ycchen.2017 (talk | contribs) |
Ycchen.2017 (talk | contribs) |
||
Line 32: | Line 32: | ||
==1 map== | ==1 map== | ||
Purpose of this worksheet: making use of the map and using the location information properly<br/> | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
− | [[Image:Cyc_wh_1.png| | + | [[Image:Cyc_wh_1.png|500px]] <br/> |
− | Steps to take: | + | Steps to take:<br/> |
# Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord | # Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord | ||
# Adding a background map in Tableau | # Adding a background map in Tableau | ||
# Using annotation to get the coordinate of each location on the map | # Using annotation to get the coordinate of each location on the map | ||
# Using the prepared data table to left join the location table by the column "location" | # Using the prepared data table to left join the location table by the column "location" | ||
− | [[Image:Cyc_wh_prep_1.jpg| | + | [[Image:Cyc_wh_prep_1.jpg|400px]] |
==2 measure count overall== | ==2 measure count overall== |
Revision as of 21:56, 8 July 2018
The final visualisation story board is available through Chen Yanchong's Tableau Public
This page will give a brief introduction of how the story board was prepared
Preparation of worksheets
There are total 11 worksheets are used.
1 map
Purpose of this worksheet: making use of the map and using the location information properly
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
2 measure count overall
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
3 measure count detailed
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
4 measure value per loc
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
5 measure value
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
6 measure value trend by year
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
7 heat map
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
8 seasonality trend
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
9 percentage diff
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
10 0.3 principle
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"
11 intuitive line graph
Purpose of this worksheet: making use of the map and using the location information properly
550px
Steps to take:
- Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
- Adding a background map in Tableau
- Using annotation to get the coordinate of each location on the map
- Using the prepared data table to left join the location table by the column "location"