IS428 AY2019-20T1 Assign He Yicheng: Dataset Processing

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 Static Sensor Data and then Mobile Sensor Data.

1. Combine the Static sensor readings and locations

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.