ISS608 2017-18 T3 G2 Assign ChenYanchong Visualization

ISSS608 Visual Analytics Vast Challenge Mini Challenge 2

Overview

Data Preparation

Visualization

Answer

Feedback

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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. 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:

1. Creating a excel worksheet named location with three columns inside it, location, Xcoord and Ycoord
2. Adding a background map in Tableau
3. Using annotation to get the coordinate of each location on the map
4. Using the prepared data table to left join the location table by the column "location"