Difference between revisions of "ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno Methodology"
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<div style=background:#F6CECE border:#A3BFB1> | <div style=background:#F6CECE border:#A3BFB1> | ||
− | [[Image: | + | [[Image:Wildlife.jpg|165px]] |
− | <b><font size = 6; color="#8B4513"> VAST Challenge | + | <b><font size = 6; color="#8B4513"> VAST Challenge 2018:Like a duck to water </font></b> |
</div> | </div> | ||
<!--MAIN HEADER --> | <!--MAIN HEADER --> | ||
Line 11: | Line 11: | ||
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | ||
; | ; | ||
− | [[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Data_Preparation|<b><font size="4"><font color="#8B4513">Methodology | + | [[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Data_Preparation|<b><font size="4"><font color="#8B4513">Methodology </font></font></b>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | ||
; | ; | ||
− | [[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Visualization|<b><font size="2"><font color="#BC8F8F"> | + | [[ISSS608 2017-18 T3 Assign Alejandro Llorens Moreno_Visualization|<b><font size="2"><font color="#BC8F8F">Answers</font></font></b>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#FFF0F5; text-align:center;" width="25%" | | ||
Line 25: | Line 25: | ||
<br/> | <br/> | ||
− | <font size="5"><font color="#8B4513">'''Methodology & | + | <font size="5"><font color="#8B4513">'''Methodology & Design'''</font></font> |
==Methodology== | ==Methodology== | ||
Line 39: | Line 39: | ||
<br> Pollution in the waters of the reserve is defined by many measures but the data set only provides enough data for a set of measures | <br> Pollution in the waters of the reserve is defined by many measures but the data set only provides enough data for a set of measures | ||
</td> | </td> | ||
− | <td>[[File: | + | <td>[[File:Selected chemicals.JPG|50x |center]]</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 2.Visualizing the | + | <td><b> 2.Visualizing the overall trend and specific changes </b> |
<br>The chemical measures were visualized per quarter and year vs Location. This helps understand the trend for each selected chemical | <br>The chemical measures were visualized per quarter and year vs Location. This helps understand the trend for each selected chemical | ||
</td> | </td> | ||
− | <td>[[File: | + | <td>[[File:Trend2.JPG|500px|center]]</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 3. | + | <td><b> 3. Visual interpretation and distribution analysis </b> |
− | <br> | + | <br>For better user experience I have elaborated a dashboard with a visual representation of each chemical in each location with its specific distribution in a box plot. |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</td> | </td> | ||
− | <td> | + | <td>[[File:Trend3.JPG|500px|center]]</td> |
− | |||
− | |||
− | |||
− | [[File: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 4. | + | <td><b> 4.Outliers analysis </b> |
− | <br> | + | <br> With a control chart the user can determine easily specific outliers for each chemical selecting 1, 2 or 3 standard deviations from the average.Upper bound: WINDOW_AVG(SUM([Value])) + ( WINDOW_STDEV( SUM([Value])) * [Standard Deviations] ), Lower bound: WINDOW_AVG(SUM([Value])) - ( WINDOW_STDEV( SUM([Value])) * [Standard Deviations] ). I have also created a measure of Outliers with the following formula: SUM([Value]) < [Lower Bound] OR SUM([Value]) > [Upper Bound] |
− | < | + | </td> |
+ | <td>[[File:OutliersAlex.JPG|500px|center]]</td> | ||
− | <br> | + | </tr> |
+ | <tr> | ||
+ | <td><b> 5.Analysis of anomalies and sampling recommendations </b> | ||
+ | <br> To understand the sampling strategy in the dataset and suggest improvements I have created a dashboard | ||
</td> | </td> | ||
− | <td>[[File: | + | <td>[[File:Anomalies.JPG|500px|center]]</td> |
+ | |||
</tr> | </tr> | ||
− | |||
<tr> | <tr> | ||
− | <td><b> | + | <td><b> 6.Detailed distribution of samples </b> |
− | <br> | + | <br> I have designed a dashboard to help the user understand the anomalies in the sampling data |
</td> | </td> | ||
− | + | <td>[[File:Boxplot.JPG|500px|center]]</td> | |
</tr> | </tr> | ||
</table> | </table> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 14:38, 8 July 2018
|
|
|
|
Methodology & Design
Methodology
Description | Illustration |
---|---|
1.Selecting the right chemicals
|
|
2.Visualizing the overall trend and specific changes
|
|
3. Visual interpretation and distribution analysis
|
|
4.Outliers analysis
|
|
5.Analysis of anomalies and sampling recommendations
|
|
6.Detailed distribution of samples
|