Difference between revisions of "IS428 AY2019-20T1 Assign Ngoh Yi Long Dashboard"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 24: Line 24:
 
= Pre-Dashboard =
 
= Pre-Dashboard =
 
<center>
 
<center>
[[File:PreDashboard 1.png|800px|frameless]]
+
[[File:PreDashboard 1.png|800px|frameless]]<br>
 
''' Finding Outlier '''
 
''' Finding Outlier '''
  
Line 31: Line 31:
  
  
[[File:PreDashboard 2.png|800px|frameless]]<br />
+
[[File:PreDashboard 2.png|800px|frameless]] <br>
 
''' Removing Outlier '''
 
''' Removing Outlier '''
[[File:PreDashboard 3.png|800px|frameless]]<br />
+
[[File:PreDashboard 3.png|800px|frameless]] <br>
 
''' Creating New Parameter and Calculated Field '''
 
''' Creating New Parameter and Calculated Field '''
  
  
To improve on the mapping visualization, I had created a parameter called “Alert Value” which represents the point in which cpm is deemed to be unsafe and also another calculated field called “Alert Level” to filter the points on the map when it is above the “Alert Value” which the user using the dashboard can set within a range of 75 to 250. This would allow me to filter the points that are only higher than the “Alert Value” set. <br />
+
To improve on the mapping visualization, I had created a parameter called “Alert Value” which represents the point in which cpm is deemed to be unsafe and also another calculated field called “Alert Level” to filter the points on the map when it is above the “Alert Value” which the user using the dashboard can set within a range of 75 to 250. This would allow me to filter the points that are only higher than the “Alert Value” set. <br>
 
</center>
 
</center>
 +
 +
= Dashboard =
 +
The interactive visualization can be accessed here: https://public.tableau.com/profile/yi.long#!/vizhome/St_HimarkRadiationMonitorSystem/HomePage <br>
 +
<center>
 +
 +
[[File:Home Page (YL).png|800px|frameless]] <br>
 +
''' Home Page ''' <br>
 +
 +
I have created a simple home page where it has a short background on what my dashboard intends to do and achieve. It has 3 buttons - Map Visualisation, Highlight Tables and Cumulative Results, these 3 are what comprises of my dashboard. The buttons allow users to navigate through the dashboard to use whichever data visualisation would be important to them, resulting a smoother flow of using the dashboard. <br>
 +
 +
[[File:Static Visualise (YL).png|800px|frameless]] <br>
 +
''' Dashboard 1 ''' <br>
 +
 +
{| class="wikitable"
 +
|-
 +
! Tools used !! Description
 +
|-
 +
|[[File:Tool 1 (YL).png|600px|frameless]] ||
 +
I have enabled the user to use the filtering action where they clicked on any of the sensors, it will show the users the radiation level in that neighbourhood
 +
|-
 +
|}
 +
 +
[[File:Mobile Visualise (YL).png|800px|frameless]] <br>
 +
''' Dashboard 2 '''
 +
 +
{| class="wikitable"
 +
|-
 +
! Tools used !! Description
 +
|-
 +
|[[File: PreDashboard 3.png|800px|frameless]] ||
 +
I had learnt to create a new parameter to be used as the Alert Value and then created a new calculated field where I allow it to run through the radiation level values so that I am able to visualise the points on the map where the levels of the recorded readings are above unsafe level.
 +
|-
 +
|}
 +
 +
 +
 +
[[File:Highlight Table by Values (YL).png|800px|frameless]] <br>
 +
''' Dashboard 3 '''
 +
 +
[[File:Sensors Highlight Table (YL).png|800px|frameless]] <br>
 +
''' Dashboard 4 '''
 +
 +
 +
[[File:Cumulative Radiation (YL).png|800px|frameless]] <br>
 +
''' Dashboard 5 '''
 +
 +
</center>
 +
 +
= Lesson Learnt =
 +
* I learnt the importance of using highlight table
 +
* The interactive panel actions which allow different sheets of graphs to interact with each other when the user interacts with the graphs.

Latest revision as of 23:59, 13 October 2019

MC2: St. HiMark Radiation Monitor System

Overview

Data Preparation

Interactive Visualisation

Tasks

References

Pre-Dashboard

PreDashboard 1.png
Finding Outlier


Before I start working on the interactive dashboard, I was trying around with the dataset. I plotted the scatterplot of the radiation level of all the mobile sensor readings through the timestamp and found out there seems to be an outlier on the reading. Sensor-id 12 is showing an extraordinary huge radiation level of 57,345 where the rest of the scatter points are only just below 5,000. Therefore, I took note of this point and excluded this point from the rest of my dashboard when it was using mobile sensor readings.


PreDashboard 2.png
Removing Outlier PreDashboard 3.png
Creating New Parameter and Calculated Field


To improve on the mapping visualization, I had created a parameter called “Alert Value” which represents the point in which cpm is deemed to be unsafe and also another calculated field called “Alert Level” to filter the points on the map when it is above the “Alert Value” which the user using the dashboard can set within a range of 75 to 250. This would allow me to filter the points that are only higher than the “Alert Value” set.

Dashboard

The interactive visualization can be accessed here: https://public.tableau.com/profile/yi.long#!/vizhome/St_HimarkRadiationMonitorSystem/HomePage

Home Page (YL).png
Home Page

I have created a simple home page where it has a short background on what my dashboard intends to do and achieve. It has 3 buttons - Map Visualisation, Highlight Tables and Cumulative Results, these 3 are what comprises of my dashboard. The buttons allow users to navigate through the dashboard to use whichever data visualisation would be important to them, resulting a smoother flow of using the dashboard.

Static Visualise (YL).png
Dashboard 1

Tools used Description
Tool 1 (YL).png

I have enabled the user to use the filtering action where they clicked on any of the sensors, it will show the users the radiation level in that neighbourhood

Mobile Visualise (YL).png
Dashboard 2

Tools used Description
PreDashboard 3.png

I had learnt to create a new parameter to be used as the Alert Value and then created a new calculated field where I allow it to run through the radiation level values so that I am able to visualise the points on the map where the levels of the recorded readings are above unsafe level.


Highlight Table by Values (YL).png
Dashboard 3

Sensors Highlight Table (YL).png
Dashboard 4


Cumulative Radiation (YL).png
Dashboard 5

Lesson Learnt

  • I learnt the importance of using highlight table
  • The interactive panel actions which allow different sheets of graphs to interact with each other when the user interacts with the graphs.