Difference between revisions of "ISS608 2017-18 T3 G2 Assign ChenYanchong Visualization"
Ycchen.2017 (talk | contribs) |
Ycchen.2017 (talk | contribs) |
||
Line 58: | Line 58: | ||
# Remove '''first or last''' from filter | # Remove '''first or last''' from filter | ||
− | ==4 measure value per loc== | + | ==4. measure value per loc== |
Purpose of this worksheet: using with the map to perform point source<br/> | Purpose of this worksheet: using with the map to perform point source<br/> | ||
[[Image:Cyc_wh_4.png|550px]]<br/> | [[Image:Cyc_wh_4.png|550px]]<br/> | ||
Line 69: | Line 69: | ||
− | ==5 measure value== | + | ==5. measure value trend by year== |
− | Purpose of this worksheet: | + | Purpose of this worksheet: how single measure changes in each location by year<br/> |
− | [[Image: | + | [[Image:Cyc_wh_6.png|550px]]<br/> |
− | Steps to take: | + | Steps to take:<br/> |
− | # | + | # '''sample date''' on column shelf and drill down to month |
− | # | + | # Put value on row shelf and choose average as aggregating method |
− | # | + | # Choose '''area''' for marks |
− | # | + | # Insert '''measure''' in title |
− | ==6 measure value | + | ==6. measure value== |
− | Purpose of this worksheet: | + | Purpose of this worksheet: giving more intuitive feeling of the difference of single measure between the start year and the end year <br/> |
− | [[Image: | + | [[Image:Cyc_wh_5.png|550px]]<br/> |
− | Steps to take: | + | Steps to take:<br/> |
− | # | + | # Duplicate the second slope chart |
− | # | + | # Add '''measure''' on filter |
− | # | + | # Double click the title and insert ''' measure ''' on the title |
− | # | + | # in the tooltip card, format it a bit and insert above chart to drill down more details |
− | ==7 heat map== | + | ==7. heat 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.jpg|550px]] | [[Image:Cyc_wh_1.jpg|550px]] |
Revision as of 22:36, 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: to should the tendency from the start to the end
Steps to take:
- Create a calculated field measure count , using formula : COUNTD([Measure])
- Create a calculated field first or last , using formula: FIRST() == 0 OR LAST() == 0
- Drag sample date to the column shelf, and measure count to row shelf
- first or last and location as filter, and choose True only
- measure count on row shelf again, and choose dual axis
- location on color card, measure count and location on label card
3. measure count detailed
Purpose of this worksheet: showing more detailed measure count than the slope chart above
Steps to take:
- Duplicate the slope chart
- Remove first or last from filter
4. measure value per loc
Purpose of this worksheet: using with the map to perform point source
Steps to take:
- Drag sample date to column shelf and drill it down to month granularity
- Drag location and measure to row shelf in order
- Put value on row shelf and choose average as aggregation method
- Add value to color card and choose average as aggregation method
- Drag location and measure to filter
5. measure value trend by year
Purpose of this worksheet: how single measure changes in each location by year
Steps to take:
- sample date on column shelf and drill down to month
- Put value on row shelf and choose average as aggregating method
- Choose area for marks
- Insert measure in title
6. measure value
Purpose of this worksheet: giving more intuitive feeling of the difference of single measure between the start year and the end year
Steps to take:
- Duplicate the second slope chart
- Add measure on filter
- Double click the title and insert measure on the title
- in the tooltip card, format it a bit and insert above chart to drill down more details
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"