IS428 AY2019-20T1 Assign Sean Chai Shong Hee Q2

Mini Case Challenge 2: Visualising Radiation Measurements in St. Himark

Problem And Motivation

Data Preparation

Interactive Visualisation

Interesting Anomalies & Observations

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

This section will answer questions for Mini Case 2

Question 2

Calculated field: Average value of radiation by neighbourhood per day

Two calculated fields were created during the data preparation phase:

Calculated Field Name	Formula	Explanation
Average radiation value by neighbourhood per day	{FIXED [Nbrhood], date([Timestamp]): avg([Value])}	Returns the average radiation levels of each neighbourhood for each day
Value > Average Value	IF ([Value] > [Average radiation value by neighbourhood per day]) THEN 1 END	Returns 1 if current value > average value of neighbourhood that sensor is currently in

The calculated field Average Value will help determine which value recorded is higher than the average recorded radiation value of the neighbourhood for that particular day.