Difference between revisions of "ISS608 2017-18 T3 G2 Assign ChenYanchong Visualization"
Ycchen.2017 (talk | contribs) |
Ycchen.2017 (talk | contribs) |
||
Line 90: | Line 90: | ||
==7. heat map== | ==7. heat map== | ||
− | Purpose of this worksheet: | + | Purpose of this worksheet: using heatmap for the convenience of comparison and obtain more detail time series analysis<br/> |
− | [[Image: | + | [[Image:Cyc_wh_7.png|550px]]<br/> |
− | Steps to take: | + | Steps to take:<br/> |
− | # | + | # Select '''measure''' to column shelf and '''location''' to row shelf |
− | # | + | # Drag '''sample date''' on column shelf and drill it down to '''month''' |
− | # | + | # Drag '''month''' to row shelf |
− | # | + | # Apply '''location''' and '''measure''' as filters |
+ | # Put average '''value''' on color card | ||
− | ==8 seasonality trend== | + | ==8. seasonality trend== |
− | Purpose of this worksheet: | + | Purpose of this worksheet: to discovery seasonality patterns<br/> |
− | [[Image: | + | [[Image:Cyc_wh_8.png|550px]]<br/> |
− | Steps to take: | + | Steps to take:<br/> |
− | # | + | # Duplicate '''the measure value by year trend''' worksheet |
− | + | # Reverse the position of '''year''' and '''month''' | |
− | # | ||
− | |||
− | ==9 percentage diff== | + | ==9. percentage diff== |
− | Purpose of this worksheet: | + | Purpose of this worksheet: comparing each location against all<br/> |
− | [[Image: | + | [[Image:Cyc_wh_9.png|550px]]<br/> |
− | Steps to take: | + | Steps to take:<br/> |
− | # | + | # Create calculated field '''avg_across_all''' by formula : '''{ FIXED YEAR([Sample Date]), [Measure]:AVG([Value])}''' |
− | # | + | # Create calculated field '''pct_diff_with_all ''' by formula: ''' ({ FIXED YEAR([Sample Date]), [Location], [Measure]:AVG([Value])} - [avg_across_all])/[avg_across_all]''' |
− | # | + | # Create calculated field ''' increased? ''' by formula: ''' IF [pct_diff_with_all] > 0 THEN 'higher' ELSEIF [pct_diff_with_all] < 0 THEN 'lower' ELSE 'equal' END''' |
− | # | + | # '''location''' and '''pct_diff_with_all''' on column shelf |
+ | # '''sample date''' on row shelf | ||
+ | # '''measure''' and '''location''' on filter | ||
+ | # '''increased? ''' on color card | ||
Revision as of 22:53, 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: using heatmap for the convenience of comparison and obtain more detail time series analysis
Steps to take:
- Select measure to column shelf and location to row shelf
- Drag sample date on column shelf and drill it down to month
- Drag month to row shelf
- Apply location and measure as filters
- Put average value on color card
8. seasonality trend
Purpose of this worksheet: to discovery seasonality patterns
Steps to take:
- Duplicate the measure value by year trend worksheet
- Reverse the position of year and month
9. percentage diff
Purpose of this worksheet: comparing each location against all
Steps to take:
- Create calculated field avg_across_all by formula : { FIXED YEAR([Sample Date]), [Measure]:AVG([Value])}
- Create calculated field pct_diff_with_all by formula: ({ FIXED YEAR([Sample Date]), [Location], [Measure]:AVG([Value])} - [avg_across_all])/[avg_across_all]
- Create calculated field increased? by formula: IF [pct_diff_with_all] > 0 THEN 'higher' ELSEIF [pct_diff_with_all] < 0 THEN 'lower' ELSE 'equal' END
- location and pct_diff_with_all on column shelf
- sample date on row shelf
- measure and location on filter
- increased? on color card
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"