Difference between revisions of "ISSS608 2017-18 T3 Assign Lim Wee Kiong Dashboard Design"
Jump to navigation
Jump to search
Wklim.2017 (talk | contribs) |
Wklim.2017 (talk | contribs) |
||
Line 47: | Line 47: | ||
It contained: | It contained: | ||
+ | |||
- ID: ID of the Sample Reading | - ID: ID of the Sample Reading | ||
+ | |||
- Value: Value of the Sample Reading | - Value: Value of the Sample Reading | ||
+ | |||
- Location1: Location of the Reading | - Location1: Location of the Reading | ||
+ | |||
- Sample Date: Date of the Reading | - Sample Date: Date of the Reading | ||
+ | |||
- Measure: The measure of the Sample Reading | - Measure: The measure of the Sample Reading | ||
+ | |||
- Unit: Unit of the Sample Reading | - Unit: Unit of the Sample Reading | ||
+ | |||
- X / Y: X and Y coordinates of the Location | - X / Y: X and Y coordinates of the Location | ||
Revision as of 10:26, 8 July 2018
|
|
|
|
|
|
Dashboard Methodology
Joining the Data Sources
The first step is to join the 3 data sources into one and do some Exploratory Data Analysis:
Location and the Waterway data points will be joined as an inner join while the Waterway data points are joined with the units of measurements as a right outer join.
The sample joined data is shown here:
It contained:
- ID: ID of the Sample Reading
- Value: Value of the Sample Reading
- Location1: Location of the Reading
- Sample Date: Date of the Reading
- Measure: The measure of the Sample Reading
- Unit: Unit of the Sample Reading
- X / Y: X and Y coordinates of the Location
Back to Dropbox Page