IS428 AY2019-20T1 Assign He Yicheng: Dataset Processing

Background

Dataset Processing

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

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.