Difference between revisions of "ISS608 2017-18 T3 G2 Assign ChenYanchong Visualization"
Ycchen.2017 (talk | contribs) |
Ycchen.2017 (talk | contribs) |
||
Line 29: | Line 29: | ||
=Preparation of worksheets= | =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<br/> | ||
+ | [[Image:Cyc_wh_1.png|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | ==2 measure count overall== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==3 measure count detailed== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==4 measure value per loc== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==5 measure value== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==6 measure value trend by year== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==7 heat map== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==8 seasonality trend== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==9 percentage diff== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==10 0.3 principle== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
+ | |||
+ | ==11 intuitive line graph== | ||
+ | Purpose of this worksheet: making use of the map and using the location information properly<br/> | ||
+ | [[Image:Cyc_wh_1.jpg|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" | ||
+ | [[Image:Cyc_wh_prep_1.jpg]] | ||
=Preparation of dashboard= | =Preparation of dashboard= | ||
=Preparation of story board= | =Preparation of story board= |
Revision as of 21:49, 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"