Difference between revisions of "IS428 2017-18 T1 Assign Dong Ruiyan"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(intro)
(asd)
 
(35 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
Visual Analytics Assignment
 
  
 
== Problem & Motivation ==
 
== Problem & Motivation ==
Line 7: Line 6:
 
''
 
''
 
''In fact, Mitch was surprised to learn that the factories had recently taken steps to make their processes more environmentally friendly, even though it raised their cost of production. Mitch discovered that the state government has been monitoring the gaseous effluents from the factories through a set of sensors, distributed around the factories, and set between the smokestacks, the city of Mistford and the nature preserve. The state has given Mitch access to their air sampler data, meteorological data, and locations map. Mitch is very good in Excel, but he knows that there are better tools for data discovery, and he knows that you are very clever at visual analytics and would be able to help perform an analysis.''''
 
''In fact, Mitch was surprised to learn that the factories had recently taken steps to make their processes more environmentally friendly, even though it raised their cost of production. Mitch discovered that the state government has been monitoring the gaseous effluents from the factories through a set of sensors, distributed around the factories, and set between the smokestacks, the city of Mistford and the nature preserve. The state has given Mitch access to their air sampler data, meteorological data, and locations map. Mitch is very good in Excel, but he knows that there are better tools for data discovery, and he knows that you are very clever at visual analytics and would be able to help perform an analysis.''''
−
 
 
== Task 1 ==
 
== Task 1 ==
 
''Characterise the sensors’ performance and operation. Are they all working properly at all times? Can you detect any unexpected behaviours of the sensors through analysing the readings they capture? Limit your response to no more than 9 images and 1000 words.''
 
''Characterise the sensors’ performance and operation. Are they all working properly at all times? Can you detect any unexpected behaviours of the sensors through analysing the readings they capture? Limit your response to no more than 9 images and 1000 words.''
 
=== Characterise Monitor Performance ===  
 
=== Characterise Monitor Performance ===  
 
I characterise the monitors’ performance and operations based on the amount of noise in their readings.
 
I characterise the monitors’ performance and operations based on the amount of noise in their readings.
−
==== Large Amount of Noise ====
+
<br>The following charts shows the total readings of all chemicals at each timestamp over the 3 months of different monitors.
−
==== Medium Amount of Noise ====
+
==== Monitors with much amount of noise ====
−
==== Small Amount of Noise ====
+
[[Image: 5,6,9.png |1000px|center]]
 +
From the graph, I find that Monitor 5, 6, and 9 have large amount of noise.
 +
Monitor 5 becomes more noise in its readings from August. Monitor 9 becomes more noise in its readings and its baseline increases from August.
 +
 
 +
==== Monitors with medium amount of noise ====
 +
[[Image: 3,7.png |1000px|center]]
 +
Monitor 3 and 7 have medium amount of noise comparing with Monitor 5, 6 and 9.
 +
 
 +
==== Monitors with less amount of noise ====
 +
[[Image: 1,2,8.png |1000px|center]]
 +
Monitor 1, 2 and 8 have small amount of noise in their readings comparing with the other monitors.
 +
 
 
==== Special: Monitor 4 ====
 
==== Special: Monitor 4 ====
−
The line graph shows the total readings of Monitor 4 at each timestamp over the 3 months. It shows a clear linearly-increasing in its readings over the time. However, other monitors did not show such kind of trend, and the possibility that this trend is caused by environmental change is very small. This trend might be caused due to errors or improper monitor behaviours.
+
[[Image: M4.png |1000px|center]]
 +
The line graph shows the total readings of Monitor 4 at each timestamp over the 3 months. It shows a clear linearly-increasing in its readings over the time. However, other monitors did not show such kind of trend, and the possibility that this trend is caused by environmental change is very small. This trend might be caused due to errors or improperly working behaviours.
 +
 
 
=== Improperly Working Behaviours ===
 
=== Improperly Working Behaviours ===
 
==== Stop Working ====  
 
==== Stop Working ====  
−
The calendar chart shows how total number of records of all 9 monitors varies with the hour of the day over the 3 months. There are 5 blank girds, which shows the total number of records of all 9 monitors at the timestamps is 0. It strongly indicates that all 9 monitors stopped working at the timestamps period, which are 00:00 AM 2nd April, 00:00 AM 6th April, 00:00 AM 4th August, 00:00 AM 7th August and 00:00 AM 2nd December. There are 2 light green grids, which shows that the total number of records of all 9 monitors at the timestamps is much fewer than that at other timestamps. By viewing the calendar chart for different monitor (filter by monitor), only Monitor 3 was working and captured 2 records at 00:00 AM 2nd August, and only Monitor 7 and Monitor 8 was working and captured total 5 records at 00:00 AM 7th December.  
+
[[Image: Missing.png |1000px|center]]
 +
The calendar chart shows how total number of records of all 9 monitors varies with the hour of the day over the 3 months. There are 5 blank girds, which shows the total number of records of all 9 monitors at the timestamps is 0. It strongly indicates that all 9 monitors stopped working at the timestamps period, which are 00:00 AM 2nd April, 00:00 AM 6th April, 00:00 AM 4th August, 00:00 AM 7th August and 00:00 AM 2nd December. There are 2 light green grids, which shows that the total number of records of all 9 monitors at the timestamps is much fewer than that at other timestamps. By viewing the calendar chart for different monitor (filter by monitor), only Monitor 3 was working and captured 2 records at 00:00 AM 2nd August, and only Monitor 7 and Monitor 8 was working and captured total 5 records at 00:00 AM 7th December.
 +
 
 
==== Redundant Records ====  
 
==== Redundant Records ====  
−
By viewing the chart of total number of records of each chemical at each timestamp for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months. The above chart is one example for Monitor 5. There are multiple dark green bars, which shows the total number of records of AGOC-3A at that timestamp is 2. It indicates that Monitor 5 captured the amount of AGOC-3A released at that timestamp twice. By viewing the chart for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months.  
+
[[Image: Duplicated.png |1000px|center]]
−
Besides, in most cases of the duplicated records of AGOC-3A at a timestamp, the amount of AGOC-3A of one record is much higher than (around 10 times) that of the other record. (To view that, go to ..dashboard) Since the smaller readings are at the normal range while the larger readings are abnormally high, I assume that the large readings are outlier due to improper working behaviours of the monitors. The extremely high readings may dominate the following analysis. To avoid that, the records with smaller reading of AOGC-3A are kept and the records with larger reading will be ignored.  
+
By viewing the charts of total number of records of each chemical at each timestamp for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months. The above chart is one example for Monitor 5. There are multiple dark green bars, which shows the total number of records of AGOC-3A at that timestamp is 2. It indicates that Monitor 5 captured the amount of AGOC-3A released at that timestamp twice. By viewing the chart for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months.  
−
To do that, I created a …
+
<br>Besides, in most cases of the duplicated records of AGOC-3A at a timestamp, the amount of AGOC-3A of one record is much higher than (around 10 times) that of the other record. Since the smaller readings are at the normal range while the larger readings are abnormally high, I assume that the large readings are outlier due to improperly working behaviours of the monitors.
 +
===== Data Cleaning ===== 
 +
The extremely high readings may dominate the following analysis. To avoid that, the records with smaller reading of AOGC-3A are kept and the records with larger reading will be ignored.  
 +
To do that, I created a new field using formula: ''{ FIXED [Date Time],[Monitor],[Chemical]: MIN([Reading])}''. It will keep the smaller reading instead of the larger reading when there are duplicated for the same chemical at the same timestamp.
 +
 
 
==== Exceptions ====  
 
==== Exceptions ====  
−
By viewing the line graphs of the hourly total readings of all chemicals per day by month captured by each monitor over the 3 months, I find that all monitors captured abnormally high readings. One clear example is the line graph of Monitor 9, which shows an extremely high reading of 46.91 at 03:00 AM 11th April that is much larger than the average readings of 2.53 at 03:00 AM across April.
+
[[Image: ExtremeHigh.png |1000px|center]]
 +
By viewing the line graphs of the hourly readings of all chemicals per day by month captured by different monitor (filter by monitor) over the 3 months, I find that all monitors captured abnormally high readings. One clear example is the line graph of Monitor 9, which shows an extremely high reading of 46.91 at 03:00 AM 11th April that is much larger than the average readings of 2.53 at 03:00 AM across April.
  
 
== Task 2 ==
 
== Task 2 ==
 
''Now turn your attention to the chemicals themselves. Which chemicals are being detected by the sensor group? What patterns of chemical releases do you see, as being reported in the data? Limit your response to no more than 6 images and 500 words.''
 
''Now turn your attention to the chemicals themselves. Which chemicals are being detected by the sensor group? What patterns of chemical releases do you see, as being reported in the data? Limit your response to no more than 6 images and 500 words.''
 
=== Monitor Detection Pattern ===
 
=== Monitor Detection Pattern ===
 +
[[Image: ByLocation.png |1000px|center]]
 
This graph shows that total readings of each chemical detected by each monitor. The pie chart of each monitor shows that all monitors detect all different amount of these 4 chemicals.
 
This graph shows that total readings of each chemical detected by each monitor. The pie chart of each monitor shows that all monitors detect all different amount of these 4 chemicals.
 +
 
=== Chemical Release Pattern ===
 
=== Chemical Release Pattern ===
 
==== Increase Pattern ====
 
==== Increase Pattern ====
 +
[[Image: IncreasePattern.png |1000px|center]]
 
This chart displays the monthly readings of each chemicals without Monitor 4 over the 3 months. The reason of excluding Monitor 4 is that the performance of Monitor 4 analysed in previous question shows a constant increase in chemical readings over time, which may dominate in this analysis. It is obvious that the total amount of Appluimonia, Chlorodinine, and AGOC-3A released experienced an increase trend over the time. The total amount of Methylosmolene released decreased from April to August but it increased much more from August to December.
 
This chart displays the monthly readings of each chemicals without Monitor 4 over the 3 months. The reason of excluding Monitor 4 is that the performance of Monitor 4 analysed in previous question shows a constant increase in chemical readings over time, which may dominate in this analysis. It is obvious that the total amount of Appluimonia, Chlorodinine, and AGOC-3A released experienced an increase trend over the time. The total amount of Methylosmolene released decreased from April to August but it increased much more from August to December.
 +
 
==== Daily Release Pattern ====
 
==== Daily Release Pattern ====
−
The chart displays the daily amount of each chemical released by month. It is obvious that the daily amount of Appluimonia and Chlorodinine released fluctuates less dramatically than that of Methylosmolene and AGOC-3A from the start day to the end day of each month.  
+
[[Image: ReleasePatternByDay.png |1000px|center]]
 +
The chart displays the daily amount of each chemical released by month. It is obvious that the daily amount of Appluimonia and Chlorodinine released fluctuates less dramatically than that of Methylosmolene and AGOC-3A from the start day to the end day of each month.
 +
 
 
==== Hourly Release Pattern ====
 
==== Hourly Release Pattern ====
−
The chart shows the hourly amount of each chemical released over the 3 months. It is obvious that the hourly amount of Methylosmolene released increases extremely from 09：00 PM to 05:00 AM. While, the hourly amount of Appluimonia, Chlorodinine and AGOC-3A released fluctuates over the time.  
+
[[Image: ReleasePatternByHour.png |1000px|center]]
 +
The chart shows the hourly amount of each chemical released over the 3 months. It is obvious that the hourly amount of Methylosmolene released increases extremely from 09:00 PM to 05:00 AM. While, the hourly amount of Appluimonia, Chlorodinine and AGOC-3A released fluctuates over the time.
 +
[[Image: MethHeatMap.png |1000px|center]]
 
This heat map also indicates the peak amount of Methylosmolene released during 09:00 PM to 05:00 AM.
 
This heat map also indicates the peak amount of Methylosmolene released during 09:00 PM to 05:00 AM.
 +
 
== Task 3 ==
 
== Task 3 ==
−
''Which factories are responsible for which chemical releases? Carefully describe how you determined this using all the data you have available. For the factories you identified, describe any observed patterns of operation revealed in the data. Limit your response to no more than 8 images and 1000 words.''
+
=== Data Preparation ===
 +
In order to plot wind rose chart, the following steps should be followed.
 +
<br> 1. Create "Radius": "WINDOW_SUM(COUNT([Wind Speed (m/s)]))"
 +
<br> 2. Create "Index": "Index()"
 +
<br>3. Create "Direction Group":
 +
<br>"If [Wind Direction] > 0 AND [Wind Direction] <= 22.5
 +
THEN 11.25
 +
ELSEIF [Wind Direction] > 22.5 AND [Wind Direction] <= 45
 +
THEN 33.75
 +
ELSEIF  [Wind Direction] > 45 AND [Wind Direction] <= 67.5
 +
THEN 56.25
 +
ELSEIF  [Wind Direction] > 67.5 AND [Wind Direction] <= 90
 +
THEN 78.75
 +
ELSEIF [Wind Direction] > 90 AND [Wind Direction] <= 112.5
 +
THEN 101.25
 +
ELSEIF [Wind Direction] > 112.5 AND [Wind Direction] <= 135
 +
THEN 123.75
 +
ELSEIF [Wind Direction] > 135 AND [Wind Direction] <= 157.5
 +
THEN 146.25
 +
ELSEIF [Wind Direction] > 157.5 AND [Wind Direction] <= 180
 +
THEN 168.75
 +
ELSEIF [Wind Direction] > 180 AND [Wind Direction] <= 202.5
 +
THEN 191.25
 +
ELSEIF [Wind Direction] > 202.5 AND [Wind Direction] <= 225
 +
THEN 213.75
 +
ELSEIF [Wind Direction] > 225 AND [Wind Direction] <= 247.5
 +
THEN 236.25
 +
ELSEIF [Wind Direction] > 247.5 AND [Wind Direction] <= 270
 +
THEN 258.75
 +
ELSEIF [Wind Direction] > 270 AND [Wind Direction] <= 292.5
 +
THEN 281.25
 +
ELSEIF [Wind Direction] > 292.5 AND [Wind Direction] <= 315
 +
THEN 303.75
 +
ELSEIF [Wind Direction] > 315 AND [Wind Direction] <= 337.5
 +
THEN 326.25
 +
ELSEIF [Wind Direction] > 337.5 AND [Wind Direction] <= 360
 +
THEN 348.75
 +
END"
 +
<br> 4. Create X-Axis: "IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0,
 +
WINDOW_MAX([Radius]) * SIN(RADIANS(avg([Wind Direction]))))"
 +
<br> 5. Create Y-Axis: "IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0,
 +
WINDOW_MAX([Radius]) * COS(RADIANS(AVG([Wind Direction]))))"
 +
=== Wind Rose Chart ===
 +
[[Image: Windrose.png |500px|center]]
 +
This is the wind rose chart for April.
 +
 
 +
=== Which factories are responsible for which chemical releases? ===
 +
'''Roadrunner -> Methylosmolene'''
 +
[[Image: Release1.png |1000px|center]]
 +
This dashboard shows the wind direction and speed in on April 11th and the pie charts of the readings by 4 chemicals detected by all monitors on April 11th. In this case, I mainly focus on the readings of Monitor 6, which detected Methylosmolene most on that day. It is very obvious the wind direction is from north west side and the Factory 10 (Roadrunner) is at the northwestern corner of the monitor 6. Therefore, I conclude that Roadrunner has high possibility that it is responsible for Methylosmolene emission.
 +
<br>'''Radiance -> Chlorodinine & AGOC-3A'''
 +
[[Image: Release2.png |1000px|center]]
 +
This dashboard shows the wind direction and speed in on April 13rd and the pie charts of the readings by 4 chemicals detected by all monitors on April 13rd. In this case, I focus on the readings of Monitor 3, which detected Chlorodinine and AGOC-3A most on that day. It is very obvious the wind direction is from south east side and the Factory 12 (Radiance) is at the sourtheastern corner of the monitor 3. Therefore, I conclude that Radiance has high possibility that it is responsible for Chlorodinine & AGOC-3A emission.
 +
<br>'''Kasios -> Appluimonia'''
 +
[[Image: Release3.png |1000px|center]]
 +
This dashboard shows the wind direction and speed in on April 18th and the pie charts of the readings by 4 chemicals detected by all monitors on April 18th. In this case, I focus on the readings of Monitor 2, which detected Appluimonia most on that day. It is very obvious the wind direction is from south east side and the Factory 11 (Kasios) is at the southeastern corner of the monitor 2. Therefore, I conclude that Radiance has high possibility that it is responsible for Appluimonia emission.
 +
== Visualisation Link ==
 +
https://public.tableau.com/profile/ruinay#!/vizhome/VAAssignment_1/Story1

Latest revision as of 00:17, 9 October 2017

Problem & Motivation

Mistford is a mid-size city is located to the southwest of a large nature preserve. The city has a small industrial area with four light-manufacturing endeavors. Mitch Vogel is a post-doc student studying ornithology at Mistford College and has been discovering signs that the number of nesting pairs of the Rose-Crested Blue Pipit, a popular local bird due to its attractive plumage and pleasant songs, is decreasing! The decrease is sufficiently significant that the Pangera Ornithology Conservation Society is sponsoring Mitch to undertake additional studies to identify the possible reasons. Mitch is gaining access to several datasets that may help him in his work, and he has asked you (and your colleagues) as experts in visual analytics to help him analyze these datasets.

Mitch Vogel was immediately suspicious of the noxious gases just pouring out of the smokestacks from the four manufacturing factories south of the nature preserve. He was almost certain that all of these companies are contributing to the downfall of the poor Rose-crested Blue Pipit bird. But when he talked to company representatives and workers, they all seem to be nice people and actually pretty respectful of the environment. In fact, Mitch was surprised to learn that the factories had recently taken steps to make their processes more environmentally friendly, even though it raised their cost of production. Mitch discovered that the state government has been monitoring the gaseous effluents from the factories through a set of sensors, distributed around the factories, and set between the smokestacks, the city of Mistford and the nature preserve. The state has given Mitch access to their air sampler data, meteorological data, and locations map. Mitch is very good in Excel, but he knows that there are better tools for data discovery, and he knows that you are very clever at visual analytics and would be able to help perform an analysis.''

Task 1

Characterise the sensors’ performance and operation. Are they all working properly at all times? Can you detect any unexpected behaviours of the sensors through analysing the readings they capture? Limit your response to no more than 9 images and 1000 words.

Characterise Monitor Performance

I characterise the monitors’ performance and operations based on the amount of noise in their readings.
The following charts shows the total readings of all chemicals at each timestamp over the 3 months of different monitors.

Monitors with much amount of noise

5,6,9.png

From the graph, I find that Monitor 5, 6, and 9 have large amount of noise. Monitor 5 becomes more noise in its readings from August. Monitor 9 becomes more noise in its readings and its baseline increases from August.

Monitors with medium amount of noise

3,7.png

Monitor 3 and 7 have medium amount of noise comparing with Monitor 5, 6 and 9.

Monitors with less amount of noise

1,2,8.png

Monitor 1, 2 and 8 have small amount of noise in their readings comparing with the other monitors.

Special: Monitor 4

M4.png

The line graph shows the total readings of Monitor 4 at each timestamp over the 3 months. It shows a clear linearly-increasing in its readings over the time. However, other monitors did not show such kind of trend, and the possibility that this trend is caused by environmental change is very small. This trend might be caused due to errors or improperly working behaviours.

Improperly Working Behaviours

Stop Working

Missing.png

The calendar chart shows how total number of records of all 9 monitors varies with the hour of the day over the 3 months. There are 5 blank girds, which shows the total number of records of all 9 monitors at the timestamps is 0. It strongly indicates that all 9 monitors stopped working at the timestamps period, which are 00:00 AM 2nd April, 00:00 AM 6th April, 00:00 AM 4th August, 00:00 AM 7th August and 00:00 AM 2nd December. There are 2 light green grids, which shows that the total number of records of all 9 monitors at the timestamps is much fewer than that at other timestamps. By viewing the calendar chart for different monitor (filter by monitor), only Monitor 3 was working and captured 2 records at 00:00 AM 2nd August, and only Monitor 7 and Monitor 8 was working and captured total 5 records at 00:00 AM 7th December.

Redundant Records

Duplicated.png

By viewing the charts of total number of records of each chemical at each timestamp for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months. The above chart is one example for Monitor 5. There are multiple dark green bars, which shows the total number of records of AGOC-3A at that timestamp is 2. It indicates that Monitor 5 captured the amount of AGOC-3A released at that timestamp twice. By viewing the chart for different monitor (filter by monitor), most of the monitors captured the amount of AGOC-3A released twice at multiple timestamps over the 3 months.
Besides, in most cases of the duplicated records of AGOC-3A at a timestamp, the amount of AGOC-3A of one record is much higher than (around 10 times) that of the other record. Since the smaller readings are at the normal range while the larger readings are abnormally high, I assume that the large readings are outlier due to improperly working behaviours of the monitors.

Data Cleaning

The extremely high readings may dominate the following analysis. To avoid that, the records with smaller reading of AOGC-3A are kept and the records with larger reading will be ignored. To do that, I created a new field using formula: { FIXED [Date Time],[Monitor],[Chemical]: MIN([Reading])}. It will keep the smaller reading instead of the larger reading when there are duplicated for the same chemical at the same timestamp.

Exceptions

ExtremeHigh.png

By viewing the line graphs of the hourly readings of all chemicals per day by month captured by different monitor (filter by monitor) over the 3 months, I find that all monitors captured abnormally high readings. One clear example is the line graph of Monitor 9, which shows an extremely high reading of 46.91 at 03:00 AM 11th April that is much larger than the average readings of 2.53 at 03:00 AM across April.

Task 2

Now turn your attention to the chemicals themselves. Which chemicals are being detected by the sensor group? What patterns of chemical releases do you see, as being reported in the data? Limit your response to no more than 6 images and 500 words.

Monitor Detection Pattern

ByLocation.png

This graph shows that total readings of each chemical detected by each monitor. The pie chart of each monitor shows that all monitors detect all different amount of these 4 chemicals.

Chemical Release Pattern

Increase Pattern

IncreasePattern.png

This chart displays the monthly readings of each chemicals without Monitor 4 over the 3 months. The reason of excluding Monitor 4 is that the performance of Monitor 4 analysed in previous question shows a constant increase in chemical readings over time, which may dominate in this analysis. It is obvious that the total amount of Appluimonia, Chlorodinine, and AGOC-3A released experienced an increase trend over the time. The total amount of Methylosmolene released decreased from April to August but it increased much more from August to December.

Daily Release Pattern

ReleasePatternByDay.png

The chart displays the daily amount of each chemical released by month. It is obvious that the daily amount of Appluimonia and Chlorodinine released fluctuates less dramatically than that of Methylosmolene and AGOC-3A from the start day to the end day of each month.

Hourly Release Pattern

ReleasePatternByHour.png

The chart shows the hourly amount of each chemical released over the 3 months. It is obvious that the hourly amount of Methylosmolene released increases extremely from 09:00 PM to 05:00 AM. While, the hourly amount of Appluimonia, Chlorodinine and AGOC-3A released fluctuates over the time.

MethHeatMap.png

This heat map also indicates the peak amount of Methylosmolene released during 09:00 PM to 05:00 AM.

Task 3

Data Preparation

In order to plot wind rose chart, the following steps should be followed.
1. Create "Radius": "WINDOW_SUM(COUNT([Wind Speed (m/s)]))"
2. Create "Index": "Index()"
3. Create "Direction Group":
"If [Wind Direction] > 0 AND [Wind Direction] <= 22.5 THEN 11.25 ELSEIF [Wind Direction] > 22.5 AND [Wind Direction] <= 45 THEN 33.75 ELSEIF [Wind Direction] > 45 AND [Wind Direction] <= 67.5 THEN 56.25 ELSEIF [Wind Direction] > 67.5 AND [Wind Direction] <= 90 THEN 78.75 ELSEIF [Wind Direction] > 90 AND [Wind Direction] <= 112.5 THEN 101.25 ELSEIF [Wind Direction] > 112.5 AND [Wind Direction] <= 135 THEN 123.75 ELSEIF [Wind Direction] > 135 AND [Wind Direction] <= 157.5 THEN 146.25 ELSEIF [Wind Direction] > 157.5 AND [Wind Direction] <= 180 THEN 168.75 ELSEIF [Wind Direction] > 180 AND [Wind Direction] <= 202.5 THEN 191.25 ELSEIF [Wind Direction] > 202.5 AND [Wind Direction] <= 225 THEN 213.75 ELSEIF [Wind Direction] > 225 AND [Wind Direction] <= 247.5 THEN 236.25 ELSEIF [Wind Direction] > 247.5 AND [Wind Direction] <= 270 THEN 258.75 ELSEIF [Wind Direction] > 270 AND [Wind Direction] <= 292.5 THEN 281.25 ELSEIF [Wind Direction] > 292.5 AND [Wind Direction] <= 315 THEN 303.75 ELSEIF [Wind Direction] > 315 AND [Wind Direction] <= 337.5 THEN 326.25 ELSEIF [Wind Direction] > 337.5 AND [Wind Direction] <= 360 THEN 348.75 END"
4. Create X-Axis: "IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0, WINDOW_MAX([Radius]) * SIN(RADIANS(avg([Wind Direction]))))"
5. Create Y-Axis: "IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0, WINDOW_MAX([Radius]) * COS(RADIANS(AVG([Wind Direction]))))"

Wind Rose Chart

Windrose.png

This is the wind rose chart for April.

Which factories are responsible for which chemical releases?

Roadrunner -> Methylosmolene

Release1.png

This dashboard shows the wind direction and speed in on April 11th and the pie charts of the readings by 4 chemicals detected by all monitors on April 11th. In this case, I mainly focus on the readings of Monitor 6, which detected Methylosmolene most on that day. It is very obvious the wind direction is from north west side and the Factory 10 (Roadrunner) is at the northwestern corner of the monitor 6. Therefore, I conclude that Roadrunner has high possibility that it is responsible for Methylosmolene emission.
Radiance -> Chlorodinine & AGOC-3A

Release2.png

This dashboard shows the wind direction and speed in on April 13rd and the pie charts of the readings by 4 chemicals detected by all monitors on April 13rd. In this case, I focus on the readings of Monitor 3, which detected Chlorodinine and AGOC-3A most on that day. It is very obvious the wind direction is from south east side and the Factory 12 (Radiance) is at the sourtheastern corner of the monitor 3. Therefore, I conclude that Radiance has high possibility that it is responsible for Chlorodinine & AGOC-3A emission.
Kasios -> Appluimonia

Release3.png

This dashboard shows the wind direction and speed in on April 18th and the pie charts of the readings by 4 chemicals detected by all monitors on April 18th. In this case, I focus on the readings of Monitor 2, which detected Appluimonia most on that day. It is very obvious the wind direction is from south east side and the Factory 11 (Kasios) is at the southeastern corner of the monitor 2. Therefore, I conclude that Radiance has high possibility that it is responsible for Appluimonia emission.

Visualisation Link

https://public.tableau.com/profile/ruinay#!/vizhome/VAAssignment_1/Story1

Retrieved from ‘https://wiki.smu.edu.sg/1718t1is428g1/index.php?title=IS428_2017-18_T1_Assign_Dong_Ruiyan&oldid=3140’