Difference between revisions of "ISSS608 2017-18 T3 Assign Manu George Mathew Q2"
(Created page with "<div style=background:#ae946e border:#ae946e> 165px <b><font size = 6; color="#FFFFFF"> VAST Challenge 2018:Suspense at the Wildlife Preserve </f...") |
|||
(One intermediate revision by the same user not shown) | |||
Line 39: | Line 39: | ||
<font size="5"><font color="#ae946e">'''Question:'''</font></font> | <font size="5"><font color="#ae946e">'''Question:'''</font></font> | ||
− | <p>Combine the four data sources for group that the insider has identified as being suspicious and locate the group in the larger dataset. Determine if anyone else appears to be closely associated with this group. Highlight which employees are making suspicious purchases, according to the insider’s data. </p> | + | <p> |
+ | Combine the four data sources for group that the insider has identified as being suspicious and locate the group in the larger dataset. Determine if anyone else appears to be closely associated with this group. Highlight which employees are making suspicious purchases, according to the insider’s data. | ||
+ | </p> | ||
<font size="5"><font color="#ae946e">'''Visualization and Analysis'''</font></font> | <font size="5"><font color="#ae946e">'''Visualization and Analysis'''</font></font> | ||
− | + | ||
<table border='1'> | <table border='1'> | ||
<tr> | <tr> | ||
− | <th>Description</th> | + | <th>Description</th> |
− | <th>Illustration</th> | + | <th>Illustration</th> |
</tr> | </tr> | ||
+ | |||
<tr> | <tr> | ||
− | <td><b> 1.The relationship between the Suspicious People and the Larger DataSet </b> | + | <td> |
− | <br> | + | <b> 1.The relationship between the Suspicious People and the Larger DataSet </b> |
− | </td> | + | <br>The people indicated in Red are the suspicious ones and the ones in green are their connections in the organization. |
− | <td> | + | </td> |
− | <br>By using the Yifan Hu layout: | + | <td> |
− | [[File:mgm_Q2_1.1.jpg|500px|center]] | + | <br>By using the Yifan Hu layout: |
− | <br>By using the Yifan Hu layout with a modularity filter value = 6: | + | [[File:mgm_Q2_1.1.jpg|500px|center]] |
− | [[File:mgm_Q2_1.3.jpg|500px|center]] | + | <br>By using the Yifan Hu layout with a modularity filter value = 6: |
− | </td> | + | [[File:mgm_Q2_1.3.jpg|500px|center]] |
+ | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td><b> 2.Other Closely Associated People </b> | + | <td> |
− | <br> | + | <b> 2.Other Closely Associated People </b> |
− | + | <br>For this analysis, I calculated the closeness centrality. Ordering the nodes as per their closeness centrality, I started filtering the data as per their modularity. At a modularity level of 7, it was observed that Alex Hall was excluded from the network. At a level of 8, Jane tyler and timothy Gibson was excluded from the network. | |
− | </td> | + | <br>For keeping a good number of suspicious people for analysis, a modularity filter level of 6 was taken. The following people were narrowed down. We can observe that there are 8 additional people closely related to the suspicious people. The people indicated in Red are the originally suspicious ones and the ones in green are the newly identified ones. |
− | <td>[[File:mgm_Q2_2.jpg|500px|center]]</td> | + | </td> |
+ | <td> | ||
+ | [[File:mgm_Q2_2.jpg|500px|center]] | ||
+ | <br>Here are their individual interactions with the other group members. | ||
+ | <br> Sheilah Stachniw | ||
+ | [[File:mgm_Q2_2.5.1.jpg|450px|center]] | ||
+ | <br> Madeline Nindorf | ||
+ | [[File:mgm_Q2_2.5.2.jpg|450px|center]] | ||
+ | <br> Timothy Gibson | ||
+ | [[File:mgm_Q2_2.5.3.jpg|450px|center]] | ||
+ | <br> Ferne Hards | ||
+ | [[File:mgm_Q2_2.5.4.jpg|450px|center]] | ||
+ | <br> Sherrell Biebel | ||
+ | [[File:mgm_Q2_2.5.5.jpg|450px|center]] | ||
+ | <br> Jane Tyler | ||
+ | [[File:mgm_Q2_2.5.6.jpg|450px|center]] | ||
+ | <br> Martha Harris | ||
+ | [[File:mgm_Q2_2.5.7.jpg|450px|center]] | ||
+ | <br> Gail Feindt | ||
+ | [[File:mgm_Q2_2.5.8.jpg|450px|center]] | ||
+ | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td> | + | <td> |
− | <b> 3.Employees Who make Purchases as per the instructions of the Group</b> | + | <b> 3.Employees Who make Purchases as per the instructions of the Group</b> |
− | </td> | + | <br> We observe that Gail Feindt and Jenice Savaria are the ones with whom the order for purchases are placed. |
− | <td> | + | <br> Jane Tyler and Timothy Gibson Places the most number of orders. This indicates that they could be non suspicious ones going by the number of transactions. |
− | [[File:mgm_Q2_3.jpg|500px|center]] | + | <br> |
− | </td> | + | </td> |
+ | <td> | ||
+ | [[File:mgm_Q2_3.jpg|500px|center]] | ||
+ | [[File:mgm_Q2_3.1.jpg|500px|center]] | ||
+ | [[File:mgm_Q2_3.2.jpg|500px|center]] | ||
+ | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
− | |||
− | |||
<font size="5"><font color="#ae946e">'''Insights'''</font></font> | <font size="5"><font color="#ae946e">'''Insights'''</font></font> | ||
<p>By using the above Plots, we can infer that,</p> | <p>By using the above Plots, we can infer that,</p> | ||
<ul> | <ul> | ||
− | + | <li>Richard Fox is the most well connected person of the Group.</li> | |
− | + | <li>He is followed by Lindsy Henion and Tobi Gatlin</li> | |
− | + | <li>If someone has more than 6 communications with the group they are considered suspicious.</li> | |
+ | <li>Based on the above criteria, there are 8 other people who are very close to the group. They are, | ||
<ul> | <ul> | ||
<li>Madeline Nindorf</li> | <li>Madeline Nindorf</li> | ||
Line 99: | Line 127: | ||
<li>Gail Feindt</li> | <li>Gail Feindt</li> | ||
</ul> | </ul> | ||
− | + | </li> | |
+ | <li>We observe that Gail Feindt and Jenice Savaria are the ones with whom the order for purchases are placed.</li> | ||
+ | <li>Jane Tyler and Timothy Gibson Places the most number of orders.</li> | ||
</ul> | </ul> |
Latest revision as of 17:34, 11 July 2018
|
|
|
|
|
|
|
Question:
Combine the four data sources for group that the insider has identified as being suspicious and locate the group in the larger dataset. Determine if anyone else appears to be closely associated with this group. Highlight which employees are making suspicious purchases, according to the insider’s data.
Visualization and Analysis
Description | Illustration |
---|---|
1.The relationship between the Suspicious People and the Larger DataSet
|
|
2.Other Closely Associated People
|
|
3.Employees Who make Purchases as per the instructions of the Group
|
Insights
By using the above Plots, we can infer that,
- Richard Fox is the most well connected person of the Group.
- He is followed by Lindsy Henion and Tobi Gatlin
- If someone has more than 6 communications with the group they are considered suspicious.
- Based on the above criteria, there are 8 other people who are very close to the group. They are,
- Madeline Nindorf
- Jane Tyler
- Sheilah Stachniw
- Ferne Hards
- Sherrell Biebel
- Timothy Gibson
- Martha Harris
- Gail Feindt
- We observe that Gail Feindt and Jenice Savaria are the ones with whom the order for purchases are placed.
- Jane Tyler and Timothy Gibson Places the most number of orders.