Assign NGO SIEW HUI Q1

From Visual Analytics and Applications
Jump to navigation Jump to search

Background

Data Preparation

Question 1

Question 2

Question 3

Conclusion

 


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 are supposed to be taking readings at every hour of the day, we would like to know if there are 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 are 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 matches the number of additional (extra) records for AGOC-3A, and hence a mirror image is observed in the chart. This might be due to a system bug which wrongly records the readings for Methylosmolene against AGOC-3A instead.