IS428 AY2019-20T1 Assign He Yicheng: Preparation

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Yc mc2 heading wide.jpg

Background

Preparation

Visualisation

Observations

References


Preparation

Provided Data:

  • MobileSensorReadings.csv - contains the sensor readings of different mobile sensor Ids over a period of time and its locations
  • StaticSensorReadings.csv - contains the sensor readings of different static sensor Ids over a period of time
  • StaticSensorLocations.csv - contains the different static sensor Ids with its locations

I will start with importing Mobile Sensor Data and then Static Sensor Data.


Create Mobile Sensor Map Graph

a. Drag Long and Lat into Columns and Rows respectively.

Yc long lat drag.png

b. Go to the top right corner and click Show Me, select symbol maps

Yc static map 01.png

c. Now, the background of the map is not defined. To customise the background, go to the top menu bar and select Map and then Background Images

Yc static map 02.png

d. Click Add Image and locate the image file on your computer.

Yc static map 03.png

e. To map the background perfectly, set the correct Long and Lat limits accordingly. Adjust the transparency using Washout slider and then click Okay.

Yc static map 04.png

f. Drag relative attributes to the Mark section.

Yc mobile map 02.png

g. Drag Timestamp to Filter and edit the filter as follows.

Yc mobile map 00.png

h. Right click Timestamp and check Show Filter

Yc mobile map 04.png

i. Go to the Timestamp filter box and choose Single Value Slider

Yc mobile map 01.png

j. Try playing around with the slider, the dots representing different sensors on the map change dynamically according to the time.

Yc mobile map 03.png

Create Mobile Sensor Readings Graph

a. Open a new sheet, and drag Timestamp, Sensor-id, and Value accordingly to the Columns and Rows.

Yc mobile log 01.png

b. Click the first Timestamp in the Columns and check Weekday

Yc mobile log 02.png

c. Click the second Timestamp in the Columns and check Exact Date, this shows the detailed timeline.

Yc mobile log 03.png

d. Go to the bottom X axis and right click, select Format.... Set Custom Dates as follows.

Yc mobile log 04.png

f. Go to the left Y asis and right click, select Edit Axis.... Under Scale, tick Logarithmic to display the data on a log scale so smaller changes can be spotted with spikes.

Yc mobile log 00.png

g. Drag Sensor-id to Color in Marks to distinguish different sensors with distinct colors.

Yc mobile log 05.png

h. This is how it looks.

Yc mobile log 06.png




Create Mobile Sensor Running Total Graph

a. Drag Timestamp and Value to Columns and Rows respectively.

Yc mobile running 00.png

b. Right click Value in Rows and go to Quick Table Calculation and select Running Total.

Yc mobile running 01.png

c. Drag Sensor-id to Color under Marks to distinguish different sensors with colours.

Yc mobile running 02.png

d. This is how it looks.

Yc mobile running 03.png

Combine Static Sensor Data

Yc static join table.png

Drag both StaticSensorReadings.csv and StaticSensorLocations.csv into the Tableau Data Source. A inner joined Data source is generated. 2 sets of data joined perfectly with common columns.

Create Static Sensor Readings Graph

Similar to Mobile Sensor Readings Graph but with Static data.

Yc mobile running 04.png

Create Static Sensor Running Total Graph

Similar to Mobile Sensor Running Total Graph but with Static data.

Yc mobile running 05.png