IS428 AY2019-20T1 Assign He Yicheng: Preparation
Revision as of 17:59, 12 October 2019 by Yicheng.he.2017 (talk | contribs) (Created page with "<div style="margin-bottom:20px;background:#3d3c49">1000px|center</div> <!-- Header Start --> {|style="background-color:#f0f0f0; color:#000000...")
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.
