Difference between revisions of "ISSS608 2017-18 T3 Assign Kalai Selvi Methodology and Dashboard Design"

From Visual Analytics and Applications
Jump to navigation Jump to search
 
(26 intermediate revisions by the same user not shown)
Line 17: Line 17:
  
 
| style="font-family: Calibri; font-size:120%; text-align:center;" width="25%" |   
 
| style="font-family: Calibri; font-size:120%; text-align:center;" width="25%" |   
−
[[ISSS608_2017-18_T3_Assign_Kalai Selvi_Insights| <font color="#FFFFFF">Insights</font>]]
+
[[ISSS608_2017-18_T3_Assign_Kalai Selvi_Insights| <font color="#FFFFFF">Insights and Conclusions</font>]]
  
 
| style="font-family: Calibri; font-size:120%; text-align:center;" width="25%" |   
 
| style="font-family: Calibri; font-size:120%; text-align:center;" width="25%" |   
−
[[ISSS608_2017-18_T3_Assign_Kalai Selvi_Conclusion| <font color="#FFFFFF">Conclusion</font>]]
+
[[Assignment Dropbox G1|<font color="#FFFFFF">Back to Assignments</font>]]
 +
 
 
|  &nbsp;  
 
|  &nbsp;  
−
|}  
+
|}
 +
 
 +
Link to Tableau Public Profile: [https://public.tableau.com/profile/kalaiselvi#!/]
 +
 
 +
The storyboard consists of 4 dashboards.
  
−
<font size="4"><font color="#0c457d" face="Calibri">
 
−
<font size="4"><font color="#0c457d" face="Calibri">
 
−
=='''Question 1''': Characterize the past and most recent situation with respect to chemical contamination in the Boonsong Lekagul waterways. Do you see any trends of possible interest in this investigation?'''</font></font>==
 
  
−
<font size="3"><font face=""Calibri" color="#0e68ce">'''Cyclic Trend in Dissolved Oxygen and Water Temperature observed across the years'''</font></font><br> Dissolved oxygen levels in the waterways consistently declines from January to July or January to August each year. Increasing trend is observed from August to December for each year. On the other hand, increasing trends in water temperature readings is observed from January to August and water temperature readings decline from August to December for each year.
+
<font size="3"><font face=""Calibri" color="#0e68ce">'''1st Dashboard'''</font></font><br>
−
[[File:1.1jpg|600 px]]
+
To identify the trends in the average chemical measure values and to analyse the distribution of the chemical measure values, by time and location. The filter options are Location, Year and Measure. Users can also further drill down at Year, Month or Day level for the line chart.
 +
<br>
 +
[[File:41.jpg|800 px]]
  
−
<font size="3"><font face=""Calibri" color="#0e68ce">'''Consistent Patterns for Petroleum Hydrocarbons across locations '''</font></font><br>
 
−
The average yearly Petroleum hydrocarbons readings follows the same pattern for Chai, Kannika, Sakda, Busarakhan and Somchair locations. 
 
−
[[File:1.2jpg|600 px]]
 
  
−
<font size="3"><font face=""Calibri" color="#0e68ce">'''Consistent Patterns for Petroleum Hydrocarbons across locations '''</font></font><br>
+
<font size="3"><font face=""Calibri" color="#0e68ce">'''2nd Dashboard'''</font></font><br>
−
The average yearly Petroleum hydrocarbons readings follows the same pattern for Chai, Kannika, Sakda, Busarakhan and Somchair locations.
+
To spot anomalies and unusual trends in the chemical measure values over time and across locations. The filter options are Location, Year and Measure. Users can also further drill down by Year, Month or Day level to analyse the average chemical measure values.
−
[[File:1.3jpg|600 px]]
+
<br>
 +
[[File:42.jpg|800 px]]
  
−
<font size="3"><font face=""Calibri" color="#0e68ce">'''Decreasing Trends in Methylosmoline '''</font></font><br>
 
−
The Methylosmoline levels has been consistent for 2014 and 2015. The Methylosmoline readings recorded in 2016 are lower and less than half of the values of 2014 and 2015 readings.  From the inter quartile range of the boxplot, it can be observed that the range of values were wider in 2014 and 2015.
 
−
[[File:1.4jpg|600 px]]
 
  
−
<font size="3"><font face=""Calibri" color="#0e68ce">'''Increasing Trends in Total Hardness levels'''</font></font><br>
+
<font size="3"><font face=""Calibri" color="#0e68ce">'''3rd Dashboard'''</font></font><br>
−
Total hardness levels have been generally declining from 2006 to 2010, and the value of the readings are closer to each other in range, especially from years 2008 to 2010 as seen as the smaller IQR. The total hardness levels were lowest in 2011 and 2012. The total hardness levels are higher for 2014 to 2016 and the first quartile is also at a  higher value compared to previous years. There are a higher number of skewed readings; above the 3rd quartile for 2014 to 2016.
+
The heatmap Calendar shows the number of records collected in each day across the years selected. The filter options are Location, Year and Measure.  
−
[[File:1.5jpg|600 px]]
+
<br>
 +
[[File:43.jpg|600 px]]
  
−
=='''Question 2''': What anomalies do you find in the waterway samples dataset? How do these affect your analysis of potential problems to the environment? Is the Hydrology Department collecting sufficient data to understand the comprehensive situation across the Preserve? What changes would you propose to make in the sampling approach to best understand the situation?'''</font></font>==
 
  
−
<font size="4"><font color="#0c457d" face="Calibri">  
+
<font size="3"><font face=""Calibri" color="#0e68ce">'''4th Dashboard'''</font></font><br>
−
=='''Question 3''': After reviewing the data, do any of your findings cause particular concern for the Pipit or other wildlife? Would you suggest any changes in the sampling strategy to better understand the waterways situation in the Preserve?'''</font></font>==
+
This dashboard allows users to compare the trends in Average Measure Readings across locations and by years. The filter options are Location, Year and Measure. Users can also further drill down by Year, Month or Day level to analyse the average chemical measure values.
 +
<br>
 +
[[File:44.jpg|600 px]]

Latest revision as of 23:57, 8 July 2018

MC2 2018.jpg VAST Challenge 2018 MC2: Like a Duck to Water

Problem Background

Data Preparation

Methodology and Dashboard Design

Insights and Conclusions

Back to Assignments

 

Link to Tableau Public Profile: [1]

The storyboard consists of 4 dashboards.


1st Dashboard
To identify the trends in the average chemical measure values and to analyse the distribution of the chemical measure values, by time and location. The filter options are Location, Year and Measure. Users can also further drill down at Year, Month or Day level for the line chart.
41.jpg


2nd Dashboard
To spot anomalies and unusual trends in the chemical measure values over time and across locations. The filter options are Location, Year and Measure. Users can also further drill down by Year, Month or Day level to analyse the average chemical measure values.
42.jpg


3rd Dashboard
The heatmap Calendar shows the number of records collected in each day across the years selected. The filter options are Location, Year and Measure.
43.jpg


4th Dashboard
This dashboard allows users to compare the trends in Average Measure Readings across locations and by years. The filter options are Location, Year and Measure. Users can also further drill down by Year, Month or Day level to analyse the average chemical measure values.
44.jpg

Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Kalai_Selvi_Methodology_and_Dashboard_Design&oldid=9443’