IS428 AY2019-20T1 Assign Jessica Yuen Chui Shan

From Visual Analytics for Business Intelligence
Revision as of 12:16, 11 October 2019 by Csyuen.2016 (talk | contribs)
Jump to navigation Jump to search

To be a Visual Detective - VAST Challenge 2019: Mini-Challenge 2

Overview Assignment Details

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. Note: reviewing the city description document may be helpful to understanding the landscape and character of the city.

Problem, Motivation, Objectives

Dataset Import Structure & Process Tasks Instruction & Interactive Visualization Your task, as supported by visual analytics that you apply, is to help St. Himark’s emergency management team combine data from the government-operated stationary monitors with data from citizen-operated mobile sensors to help them better understand conditions in the city and identify likely locations that will require further monitoring, cleanup, or even evacuation. Will data from citizen scientists clarify the situation or make it more uncertain? Use visual analytics to develop responses to the questions below. Novel visualizations of uncertainty are especially interesting for this mini-challenge.

Task 1: Visualize radiation measurements over time from both static and mobile sensors to identify areas where radiation over background is detected. Characterize changes over time.
Limit your response to 6 images and 500 words.

Task 2: Use visual analytics to represent and analyze uncertainty in the measurement of radiation across the city.
a. Compare uncertainty of the static sensors to the mobile sensors. What anomalies can you see? Are there sensors that are too uncertain to trust?
b. Which regions of the city have greater uncertainty of radiation measurement? Use visual analytics to explain your rationale.
c. What effects do you see in the sensor readings after the earthquake and other major events? What effect do these events have on uncertainty?
Limit your responses to 12 images and 1000 words.

Task 3: Given the uncertainty you observed in question 2, are the radiation measurements reliable enough to locate areas of concern?
a. Highlight potential locations of contamination, including the locations of contaminated cars. Should St. Himark officials be worried about contaminated cars moving around the city?
b. Estimate how many cars may have been contaminated when coolant leaked from the Always Safe plant. Use visual analysis of radiation measurements to determine if any have left the area.
c. Indicated where you would deploy more sensors to improve radiation monitoring in the city. Would you recommend more static sensors or more mobile sensors or both? Use your visualization of radiation measurement uncertainty to justify your recommendation.
Limit your responses to 12 images and 1000 words

Task 4: Summarize the state of radiation measurements at the end of the available period. Use your novel visualizations and analysis approaches to suggest a course of action for the city. Use visual analytics to compare the static sensor network to the mobile sensor network. What are the strengths and weaknesses of each approach? How do they support each other?
Limit your response to 6 images and 800 words.

Task 5: The data for this challenge can be analyzed either as a static collection or as a dynamic stream of data, as it would occur in a real emergency. Describe how you analyzed the data - as a static collection or a stream. How do you think this choice affected your analysis? Limit your response to 200 words and 3 images.

Data Preparation

In the zipped folder, we were given 3 raw datasets namely:
1) MobileSensorReadings.csv - contains mobile sensor readings from various user IDs from 6 April 2020 0000 to 10 April 2020 2359 and its coordinates (longitude & latitude)
2) StaticSensorLocations.csv - contains sensor readings of 9 different sensor IDs with the coordinates (longitude & latitude)
3) StaticSensorReadings.csv - contains static sensor readings from various user IDs from 6 April 2020 0000 to 10 April 2020 2359 and its coordinates (longitude & latitude)

Removing Redundant Data
In both MobileSensorReadings.csv and StaticSensorReadings.csv, there is a column named "Units" that were not used in the data pre-processing. Hence, I decided to remove it when I was importing the csv files into Tableau. To do so,

    1. Add StaticSensorReadings.csv into the Panel.

1.png

    2. Right click on the column "Units" and click "Hide" for both StaticSensorReadings.csv and MobileSensorReadings.csv
      2jess.PNG

      Merging StaticSensorReadings.csv and StaticSensorLocations.csv
      To make the data more accurate and meaningful, I decided to merge StaticSensorReadings.csv with StaticSensorLocations.csv.
      3jess.PNG
      I would then save the data from StaticSensorReadings and StaticSensorLocations in a new CSV file. I have named it as SensorReadings.csv

      Merging SensorReadings.csv and MobileSensorReadings.csv
      Similar to the StaticSensor CSV files, I decided to merge SensorREadings.csv with MobileSensorReadings.csv.
      Bear in mind that we need to remove "Units" column in MobileSensorReadings.csv too

      Concat "Static"/"Mobile" with Sensor ID
      As both MobileSensorReadings.csv and SensorReadings.csv has Sensor ID, I decided to add a "Static" or "Mobile" behind each sensor ID so that it would be clearer for me to understand the data. Hence, I decided to do it to avoid any confusion.
      4jess.PNG

      Interactive Visualization

      The interactive visualization could be found here:


      Home Page
      I decided to separate the visualizations with tabs labelled Mobile Sensor Visualizations and Static Sensor Visualizations. This helps to give a more user-friendly visualization for the user.
      The following is a screenshot of the homepage.
      Homepagejess.PNG

      To have a better visualization of the data, I decided to customize interactive elements to help the users analyze the data better. The following elements were used:

      Filters/Interactive Feature Rationale Implementation Steps
      Rationale1jess.PNG To allow users to be able to filter based on the desired date.
        1. Drag Timestamp to "Filter" section.
        2. In the "Filter Field" popup box, select the format: Month/Date/Year.
        3. Click Next and you should be able to see the checkboxes.
      Rationale2jess.PNG Users would be able to see an animated trail of mobile sensor movement.
        1. Drag the Timestamp in Pages section.
        2. Click on the down arrow key and change the format of timestamp to "Minutes" and custom option of "Date Value".
      Rationale3jess.PNG Allow the user to tell the different mobile/static sensors based on the color code.
        1. Drag Mobile/Static Sensor to "Colour" under "Marks" section.
      Rationale4jess.PNG To provide users a better insight of how the different mobile/static sensors progress and changes.
        After Sensor ID has been dragged into "Marks" section, click on the down arrow key and select "Show Highlighter"
      Marking out an animated trail To map out the trail that the mobile sensor data has travelled throughout the day.

      Select the following screenshot options.
      Rationale5jess.png

      Objectives

      This section aims to answer the 5 tasks.
      1) Mobile Sensors
      1jess.PNG
      The frequency of mobile sensors were quite consistent for majority of the mobile sensors. However, for mobile sensor 12, there was a significant jump of value at 9 April 2020, 2:43:25 AM. This might be a sign that there was an earthquake at where mobile sensor 12 was.
      1ajess.png
      1bjess.png
      1cjess.png
      Static Sensors

      Comments

      Feel free to comment!