ISSS608 2017-18 T3 Assign Lim Wee Kiong Dashboard Design

From Visual Analytics and Applications
Revision as of 10:26, 8 July 2018 by Wklim.2017 (talk | contribs)
Jump to navigation Jump to search

DuckFam.jpg    VAST 2018 Mini-Challenge 2: Like a Duck to Water

Introduction

Data Preparation

Dashboard Methodology

Insights & Findings

Conclusion & Comments


 


Dashboard Methodology

Joining the Data Sources

The first step is to join the 3 data sources into one and do some Exploratory Data Analysis:

LWKdashmed1.jpg

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:

LWKdashmed2.jpg

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

Go back.png