Assign NGO SIEW HUI Q1

From Visual Analytics and Applications
Revision as of 23:41, 15 July 2017 by Siewhui.ngo.2016 (talk | contribs) (Siewhui.ngo.2016 moved page Assign NGO Q1 to Assign NGO SIEW HUI Q1)
Jump to navigation Jump to search

Vaa1.jpg ISSS608 Visual Analytics and Applications - Individual Assignment Report

Background

Data Preparation

Question 1

Question 2

Question 3

Conclusion

Comments

 



Question 1

Characterize the sensors' performance and operation. Are they all working properly at all times? Can you detect any unexpected behaviors of the sensors through analyzing the readings they capture? Limit your response to no more than 9 images and 1000 words.


Response

As the sensors were supposed to be taking readings at every hour of the day, we would like to know if there were any missing records. Hence, a dashboard was developed with interactive filters (i.e. select sensor, month and chemical) to enable the viewing of captured readings on an hourly basis.

Ngo fig1.png



Observation 1: There were indeed many missing records spread across all months, sensors and chemicals.



Next, a dashboard was developed to view the number of missing records, on the basis that we would expect 24 readings in one day for a specified chemical and sensor. Interactive filters were added to enable selection of chemical(s). In the process, it was observed that there were additional (extra) records present in the data, i.e. more than one single record for a particular sensor, chemical and hour of the day.

Ngo fig2.png



Observation 2: The number of missing records for Methylosmolene matched the number of additional (extra) records for AGOC-3A, and hence a mirror image was observed in the chart. This might be due to a system bug which had wrongly recorded the readings for Methylosmolene against AGOC-3A instead.



We used the above dashboard to view the no. of extra / missing records for the other two chemicals, Appluimonia and Chlorodinine.

Ngo fig3.png



Observation 3: There were missing records for Appluimonia and Chlorodinine which had occurred during the same days within each month. For example, missing records were observed on the 2nd and 6th day of April across all 9 sensors. This might be due to a system bug or it could be some system maintenance process which led to all sensors not being able to capture readings during those days.