Difference between revisions of "IS428 AY2019-20T1 Assign Tommy Johnson"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(Undo revision 3763 by Ronald.lay.2017 (talk))
Tag: Undo
 
(22 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Problem & Motivation ==
+
<div style=background:#f79b4c border:#A3BFB1>
 +
[[Image:Nuclear-power-plant 09-24-18.jpg|200px]]
 +
<font size = 5; color="#000000"><b>Visualization Analysis on Always Safe nuclear power plant</b></font>
 +
</div>
 +
{|style="background-color:#f79b4c; color:#7fc6cb; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 +
| style="padding:0.3em; font-size:100%; background-color:#7fc6cb; text-align:center; color:#7fc6cb" width="10%" |
 +
[[IS428_AY2019-20T1_Assign_Tommy Johnson |
 +
<font color="#000000" size=2><b>Problem & Motivation</b></font>]]
 +
 
 +
| style="background:none;" width="1%" | &nbsp;
 +
| style="padding:0.3em; font-size:100%; background-color:#f79b4c;  text-align:center; color:#7fc6cb" width="10%" |
 +
[[IS428_AY2019-20T1_Assign_Tommy Johnson_DataAnalysisTransformation |
 +
<font color="#000000" size=2><b>Data Analysis & Transformation</b></font>]]
 +
 
 +
| style="background:none;" width="1%" | &nbsp;
 +
| style="padding:0.3em; font-size:100%; background-color:#f79b4c;  text-align:center; color:#7fc6cb" width="10%" |
 +
[[IS428_AY2019-20T1_Assign_Tommy Johnson_Visualization |
 +
<font color="#000000" size=2><b>Interactive Visualization</b></font>]]
 +
 
 +
| style="background:none;" width="1%" | &nbsp;
 +
| style="padding:0.3em; font-size:100%; background-color:#f79b4c;  text-align:center; color:#7fc6cb" width="10%" |
 +
[[IS428_AY2019-20T1_Assign_Tommy Johnson_Observation |
 +
<font color="#000000" size=2><b>Observation & Anomalies</b></font>]]
 +
 
 +
|}
 +
 
 
One of St. Himark’s largest employers is the Always Safe nuclear power plant. The pride of the city, it produces power for St. Himark’s needs and exports the excess to the mainland providing a steady revenue stream. However, the plant was not compliant with international standards when it was constructed and is now aging. As part of its outreach to the broader community, Always Safe agreed to provide funding for a set of carefully calibrated professional radiation monitors at fixed locations throughout the city. Additionally, a group of citizen scientists led by the members of the Himark Science Society started an education initiative to build and deploy lower cost homemade sensors, which people can attach to their cars. The sensors upload data to the web by connecting through the user’s cell phone. The goal of the project was to engage the community and demonstrate that the nuclear plant’s operations were not significantly changing the region’s natural background levels of radiation.
 
One of St. Himark’s largest employers is the Always Safe nuclear power plant. The pride of the city, it produces power for St. Himark’s needs and exports the excess to the mainland providing a steady revenue stream. However, the plant was not compliant with international standards when it was constructed and is now aging. As part of its outreach to the broader community, Always Safe agreed to provide funding for a set of carefully calibrated professional radiation monitors at fixed locations throughout the city. Additionally, a group of citizen scientists led by the members of the Himark Science Society started an education initiative to build and deploy lower cost homemade sensors, which people can attach to their cars. The sensors upload data to the web by connecting through the user’s cell phone. The goal of the project was to engage the community and demonstrate that the nuclear plant’s operations were not significantly changing the region’s natural background levels of radiation.
  
Line 8: Line 33:
 
* Identify observations and anomalies to the existing data available
 
* Identify observations and anomalies to the existing data available
 
* Identify contaminated areas and cars so that evacuation can be done efficiently and quickly
 
* Identify contaminated areas and cars so that evacuation can be done efficiently and quickly
 
 
== Dataset Analysis & Transformation Process ==
 
Before moving on to the analysis, it is essential to clean and transform the raw data so that I can bring value to the analysis. In the zipped file, I am given 3 raw data sets namely:
 
* MobileSensorReadings.csv - contains the sensor readings of different mobile sensor Ids over a period of time and its locations
 
* StaticSensorReadings.csv - contains the sensor readings of different static sensor Ids over a period of time
 
* StaticSensorLocations.csv - contains the different static sensor Ids with its locations
 
 
I will be using Tableau Prep to clean and transform the data. It is a new feature provided by the Tableau. The following section will explain step by step on how I prepare the data sets.
 
 
=== 1. Combine the Static sensor readings and locations ===
 
[[File:JoinStaticsensor.png|500px|centre]]
 
The first step is to combine the two csv files of static into one. This is to create a tidier data (Tall and skinny structure). I use Join to combine the columns from two different files into one.
 
 
=== 2. Create a calculated field for Static and Mobile sensor Ids ===
 
[[File:CleanSensorId.PNG|500px|centre]]
 
 
The next step is to concatenate "- Static" or "- Mobile" at the back of the sensor Ids with the [Sensor-id] + "- Mobile" or [Sensor-id] + "- Static" calculated fields. This is because I realize that the static sensor Ids have the same Id number although they are referring to different records. Hence, this is done to avoid confusion at the later part. The final output will be as follow.
 
 
Static Sensor
 
[[File:Staticdata.PNG|centre|500px]]
 
 
 
Mobile Sensor
 
[[File:Mobiledata.PNG|centre|500px]]
 
 
=== 3. Combine the static and mobile sensor data into one ===
 
[[File:Combinedata.PNG|500px|centre]]
 
 
The last step is to combine the static and mobile sensor data into 1 file. This will be the working file that I am going to use in Tableau. I use Union because I am just going to append more rows. After that, I will still need to clean the data to remove any duplicate columns so that all columns are arranged.
 
 
The final Workflow will look like this:
 
 
[[File:Finalworkflow.PNG|500px|centre]]
 
 
== Interactive Visualization ==
 
The interactive visualization can be accessed here:
 
=== Home Dashboard ===
 
 
=== Radiation Level Dashboard ===
 
In this dashboard, I am using map chart to visualize the radiation measurements for both static and mobile sensors. With this chart, analysts will be able to see which areas are prone to high or low radiation levels from each sensor types.
 
 
[[File:MapchartRadiationLevel.PNG|500px|centre]]
 
 
To enhance the visualization of the data, implementing interactive elements would help users in analyzing the data intuitively. The following elements are used throughout the dashboards.
 
{| class="wikitable"
 
|-
 
! style="font-weight: bold;background: #7fc6cb;width: 20%;" | Interactive Features
 
! style="font-weight: bold;background: #7fc6cb;width: 40%" | Rationale
 
! style="font-weight: bold;background: #7fc6cb;" | Brief Implementation Steps
 
|-
 
| <center>'''Filter dates with the use of checkboxes''' <br/>[[File:Datefilter.PNG|200px|center]]</center>
 
|| <center>To provide flexibility for analysts to choose the dates that they are interested to analyse. They can choose only one or multiple dates.</center>
 
||
 
# Drag the Timestamp to the Filter
 
# Change the format of the timestamp to custom date Month/Date/Year with Date Part option <br/>[[File:CustomDate.PNG|200px|center]]
 
|-
 
| <center>'''Filter the sensor type Static/Mobile a single selection drop down list''' <br>[[File:SensorType.PNG|200px|center]]</center>
 
|| <center>To allow analysts to visualize the radiation level focusing on the type of sensors (Static/Mobile) that they want. This will also enhance the navigation between the two sensors</center>
 
||
 
# Create a parameter for the sensor type <br/>[[File:SensorTypeParameter.PNG|200px|center]]
 
# Create a calculated field to filter the type. Then, put it at the Filter section <br/>[[File:SensorTypeFilter.PNG|200px|center]]
 
|-
 
| <center>'''Animate the timestamp in minutes''' <br>[[File:TimestampAnimation.PNG|200px|center]]</center>
 
|| <center>To allow for greater analysis and aesthetics of the data. Analysts will be able to view the changes of radiation level and identify the highest / lowest level at a particular time clearly.</center>
 
||
 
# Put the Timestamp in Pages section of the Tableau
 
# Change the format of the timestamp to minutes
 
|}
 
 
== Interesting Observation and  Anomalies==
 
=== Visualize radiation measurements over time from both static and mobile sensors.===
 
To visualize the radiation level for both static and mobile sensors, I am using a map chart. From the chart, user can interactively
 

Latest revision as of 15:19, 12 October 2019

Nuclear-power-plant 09-24-18.jpg Visualization Analysis on Always Safe nuclear power plant

Problem & Motivation

 

Data Analysis & Transformation

 

Interactive Visualization

 

Observation & Anomalies

One of St. Himark’s largest employers is the Always Safe nuclear power plant. The pride of the city, it produces power for St. Himark’s needs and exports the excess to the mainland providing a steady revenue stream. However, the plant was not compliant with international standards when it was constructed and is now aging. As part of its outreach to the broader community, Always Safe agreed to provide funding for a set of carefully calibrated professional radiation monitors at fixed locations throughout the city. Additionally, a group of citizen scientists led by the members of the Himark Science Society started an education initiative to build and deploy lower cost homemade sensors, which people can attach to their cars. The sensors upload data to the web by connecting through the user’s cell phone. The goal of the project was to engage the community and demonstrate that the nuclear plant’s operations were not significantly changing the region’s natural background levels of radiation.

When an earthquake strikes St. Himark, the nuclear power plant suffers damage resulting in a leak of radioactive contamination. Further, a coolant leak sprayed employees’ cars and contaminated them at varying levels. Now, the city’s government and emergency management officials are trying to understand if there is a risk to the public while also responding to other emerging crises related to the earthquake as well as satisfying the public’s concern over radiation.

With the data visualization, it would help analyse:

  • The radiation level for both static and mobile sensor over time
  • Identify observations and anomalies to the existing data available
  • Identify contaminated areas and cars so that evacuation can be done efficiently and quickly