Difference between revisions of "ISSS608 2017-18 T3 Assign Hasanli Orkhan Insights"
Orkhanh.2017 (talk | contribs) |
Orkhanh.2017 (talk | contribs) |
||
(38 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <div style=background:# | + | <div style=background:#A8A8A8 border:#A3BFB1> |
− | [[Image:Network_Main.png| | + | [[Image:Network_Main.png|300px]] |
<b><font size = 6; color="#3a2e29"; style="font-family:Century Gothic">Detecting Suspicious Individuals</font></b> | <b><font size = 6; color="#3a2e29"; style="font-family:Century Gothic">Detecting Suspicious Individuals</font></b> | ||
</div> | </div> | ||
<!--Navigation--> | <!--Navigation--> | ||
− | {|style="background-color:# | + | {|style="background-color:#A8A8A8;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | |
− | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:# | + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F;font-weight:bold; background:#A8A8A8; text-align:center;" width="25%" | |
; | ; | ||
[[ISSS608_2017-18_T3_Assign_Hasanli Orkhan|<font color="#000000">Overview</font>]] | [[ISSS608_2017-18_T3_Assign_Hasanli Orkhan|<font color="#000000">Overview</font>]] | ||
− | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:# | + | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A8A8A8; width=25%" | |
; | ; | ||
[[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Methodology|<font color="#000000">Methodology</font>]] | [[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Methodology|<font color="#000000">Methodology</font>]] | ||
− | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:# | + | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A8A8A8; width=25%" | |
; | ; | ||
[[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Insights|<font color="#000000">Findings</font>]] | [[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Insights|<font color="#000000">Findings</font>]] | ||
− | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:# | + | | style="font-family:Century Gothic; font-weight:bold; font-size:100%; text-align:center; background-color:#A8A8A8; width=25%" | |
; | ; | ||
− | [[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Conclusion|<font color="#000000"> | + | [[ISSS608_2017-18_T3_Assign_Hasanli Orkhan_Conclusion|<font color="#000000">Reference and Comments</font>]] |
|} | |} | ||
<br><br> | <br><br> | ||
− | <gallery mode="packed-hover" heights=" | + | <h2>Changes over time in the company.Is the company growing?</h2> |
− | File: | + | <br> |
− | + | <gallery mode="packed-hover" heights="800" > | |
− | + | File:Dashboard 1.png | |
− | |||
− | |||
− | |||
</gallery> | </gallery> | ||
<br><br> | <br><br> | ||
+ | By looking at the overall trend we can compare absolute numbers and see that during 2.5 years the number of Emails always were higher than other communication types and average number of emails was 462K, whereas Calls which following the Emails on average showing 336K throughout the period. There is some obvious fluctuations depending on number of days in each month, we can see that for Emails, Calls and Purchase line plots there is a bit spike in months that have 31 days, a slight drop in months that have 30 days and reasonable drop in February of 2016 and 2017. | ||
+ | <br> | ||
+ | For meetings on the other hand there is an upward trend. Need to be noted that some months of meetings were filtered out because they showed values around 0. Starting from October 2015 we might notice increase in the number of meetings. | ||
+ | |||
+ | To compare the months in each year I have plotted the cycle plot where we might observe some drops and ups over the 2.5 years. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="800" > | ||
+ | File:Dashboard 2.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | By looking at this plot we may easily determine which months show drops or increase in the number of calls, emails or purchases relatively to other years. Again here for some months we only have 2016 and 2017 years and drop in February from 2016 to 2017 might be explained by 1 day difference. | ||
+ | <br> | ||
+ | Overall for months where we noticed increase it is obvious that increase from 2015 to 2016 relatively higher than increase from 2016 to 2017 which might indicates relatively slow increase in last year. Although for Emails and Calls the trend by months showing almost the same pattern, Purchases on the other hand differs by showing decrease from April to June, in October and December which is below average number for that months. It worth to mention that for December for all communications type there is a drop, however for Purchases it is obvious the percentage of the drop is quite high. | ||
+ | <br> | ||
+ | One of the suspicious patterns that we can extract by visualizing all the types of communications in one dashboard the highest months for Meetings happened in October and December 2017 when exactly purchase amount decreased substantially. From the given data we might not say explicitly that the company growing or opposite, most probably the pattern is almost the same over the given period, because the range of the average value for each months of years fluctuate almost in the same interval. | ||
+ | |||
+ | <br><br> | ||
+ | <h2>Who else appears to be closely associated with suspicious group?</h2> | ||
+ | After joining the suspicious data with large data set and running Modularity we have grouped individuals into 6 different communities. Individuals without 'Ins' adding were identified as new suspicious members.Below are shown all the members of the communities: | ||
+ | <br> | ||
+ | <div><ul> | ||
+ | <li style="display: inline-block;"> [[File:Modul 0.png|thumb|none|250px|Community_1]] </li> | ||
+ | <li style="display: inline-block;"> [[File:Modul 1.png|thumb|none|250px|Community_2]] </li> | ||
+ | <li style="display: inline-block;"> [[File:Modul 2.png|thumb|none|250px|Community_3]] </li> | ||
+ | <li style="display: inline-block;"> [[File:Modul 3.png|thumb|none|250px|Community_4]] </li> | ||
+ | <li style="display: inline-block;"> [[File:Modul 4.png|thumb|none|250px|Community_5]] </li> | ||
+ | <li style="display: inline-block;"> [[File:Modul 5.png|thumb|none|250px|Community_6]] </li> | ||
+ | </ul></div> | ||
+ | <br> | ||
+ | <h2>Which employees are making suspicious purchases?</h2> | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="500" > | ||
+ | File:Degree suspicious.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | By Filtering only purchase type we can find out the names of the employees who is making suspicious purchases according to the insider information. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="200" > | ||
+ | File:1Purchase.png | ||
+ | </gallery> | ||
+ | <br><br> | ||
+ | From here we can see that from the suspicious group of employees Rosalia Larroque making purchase from Jenice Savaria. | ||
+ | <br> | ||
+ | There is only one person - Gail Feindt who made the purchase with four suspicious individuals: Richard Fox, Tobi Gatlin, Meryl Pastuch and Lizbeth Jindra. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="600" > | ||
+ | File:Before Filtering.png | ||
+ | <gallery mode="packed-hover" heights="400" > | ||
+ | File:4Purchase.png | ||
+ | </gallery> | ||
+ | <br><br> | ||
+ | <h2>Organizational structure and a full picture of communications</h2> | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="650" > | ||
+ | File:Org Structure.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | From the above network graph we can identify the organizational structure where Richard Fox has the highest position according to assigned betweenness and centrality. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="200" > | ||
+ | File:Richard Fox values.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | Some people from our analysis have higher betweenness value, while others have higher closeness values. Therefore, the main leaders in this network are: Richard Fox, Meryl Pastuch, Tobi Gatlin, Lindsy Henion, Glen Grant, Sheilah Stachniw. | ||
+ | <br> | ||
+ | By setting the degree measure at least to 4 we can see clear picture of all interactions within the group. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="600" > | ||
+ | File:4degree.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | From above graph we can conclude that mostly people communicate via emails, followed by calls, meetings and making purchases. | ||
+ | For '''call''' interactions (green colour) the thickness of the edges show weight of that connection type between different individuals: ''Medeline Nindorf -> Lizbeth Jindra, Kerstin Belveal <-> Sherrel Biebel'' (both sides), ''Richard Fox -> Lindsy Henion''. | ||
+ | For '''email''' interactions (purple line): ''Rosalia Larroque <-> Kerstin Belveal, Kerstin Belveal -> Lindsy Henion, Meryl Pastuch -> Lindsy Henion''. | ||
+ | For '''meetings''' interaction (orange colour): ''Meryl Pastuch -> Rosalia Larroque, Richard Fox -> Meryl Pastuch, Richard Fox -> Kerstin Belveal, Madeline Nindorf, Julie Tierno, Sherrel Biebel''. | ||
+ | For '''purchases'''(blue colour) there is only ''Geil Feindt'' from whom ''Richard Fox, Tobi Gatlin, Meryl Pastuch'' and ''Lizbeth Jindra'' purchase. | ||
+ | <br><br> | ||
+ | <h2>Changes in the group composition depending on activities and over time</h2> | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="100" > | ||
+ | File:C-type Q3.PNG | ||
+ | </gallery> | ||
+ | <br> | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="500" > | ||
+ | File:Emails.png | ||
+ | File:Calls.png | ||
+ | File:Meetings.png | ||
+ | File:Purchase.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | When we filter our the overall connections by year we can see that mostly communications happened in 2016 (40.35%) , followed by 2015 (32.02%) and lastly 2017 (27.63%). | ||
+ | In 2015 there are 41 nodes and 73 edges, whereas in 2016 the number of nodes increased to 45 nodes and 92 edges and mostly communications were experienced in November and December of 2016. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="200" > | ||
+ | File:Filter 2016.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | In 2017 even the number of the people interacting increased to 47, however, the intensity of the interaction decreased to 63. | ||
+ | <br> | ||
+ | <gallery mode="packed-hover" heights="400" > | ||
+ | File:2015_1.png | ||
+ | File:2016_1.png | ||
+ | File:2017_1.png | ||
+ | </gallery> | ||
+ | <br> | ||
+ | <h2>Similar patterns as other suspicious individuals</h2> | ||
+ | <gallery mode="packed-hover" heights="400" > | ||
+ | File:Susp1.PNG | ||
+ | File:Mer Ros Jen.PNG | ||
+ | </gallery> | ||
+ | <br> | ||
+ | As we see from here Gail Feindt is the same person that previously Richard Fox, Lizbeth Jindra, Meryl Pastuch and Tobi Gatlin has made a purchase. By Filtering the month we can see that this purchase happened on 7th of June,2017 at the same time if we look at previous group purchase time the Month is exactly the same which happened on 23th of June,2017. | ||
+ | <br> | ||
+ | Another point is before purchasing from Gregory Russell Beth Wilensky had a meeting with Errol Eklov, which shows the same pattern when in previous image we saw meeting of Rosalia Larroque with Meryl Pastuch. |
Latest revision as of 23:34, 8 July 2018
|
|
|
|
Contents
- 1 Changes over time in the company.Is the company growing?
- 2 Who else appears to be closely associated with suspicious group?
- 3 Which employees are making suspicious purchases?
- 4 Organizational structure and a full picture of communications
- 5 Changes in the group composition depending on activities and over time
- 6 Similar patterns as other suspicious individuals
Changes over time in the company.Is the company growing?
By looking at the overall trend we can compare absolute numbers and see that during 2.5 years the number of Emails always were higher than other communication types and average number of emails was 462K, whereas Calls which following the Emails on average showing 336K throughout the period. There is some obvious fluctuations depending on number of days in each month, we can see that for Emails, Calls and Purchase line plots there is a bit spike in months that have 31 days, a slight drop in months that have 30 days and reasonable drop in February of 2016 and 2017.
For meetings on the other hand there is an upward trend. Need to be noted that some months of meetings were filtered out because they showed values around 0. Starting from October 2015 we might notice increase in the number of meetings.
To compare the months in each year I have plotted the cycle plot where we might observe some drops and ups over the 2.5 years.
By looking at this plot we may easily determine which months show drops or increase in the number of calls, emails or purchases relatively to other years. Again here for some months we only have 2016 and 2017 years and drop in February from 2016 to 2017 might be explained by 1 day difference.
Overall for months where we noticed increase it is obvious that increase from 2015 to 2016 relatively higher than increase from 2016 to 2017 which might indicates relatively slow increase in last year. Although for Emails and Calls the trend by months showing almost the same pattern, Purchases on the other hand differs by showing decrease from April to June, in October and December which is below average number for that months. It worth to mention that for December for all communications type there is a drop, however for Purchases it is obvious the percentage of the drop is quite high.
One of the suspicious patterns that we can extract by visualizing all the types of communications in one dashboard the highest months for Meetings happened in October and December 2017 when exactly purchase amount decreased substantially. From the given data we might not say explicitly that the company growing or opposite, most probably the pattern is almost the same over the given period, because the range of the average value for each months of years fluctuate almost in the same interval.
Who else appears to be closely associated with suspicious group?
After joining the suspicious data with large data set and running Modularity we have grouped individuals into 6 different communities. Individuals without 'Ins' adding were identified as new suspicious members.Below are shown all the members of the communities:
Which employees are making suspicious purchases?
By Filtering only purchase type we can find out the names of the employees who is making suspicious purchases according to the insider information.
From here we can see that from the suspicious group of employees Rosalia Larroque making purchase from Jenice Savaria.
There is only one person - Gail Feindt who made the purchase with four suspicious individuals: Richard Fox, Tobi Gatlin, Meryl Pastuch and Lizbeth Jindra.
Organizational structure and a full picture of communications
From the above network graph we can identify the organizational structure where Richard Fox has the highest position according to assigned betweenness and centrality.
Some people from our analysis have higher betweenness value, while others have higher closeness values. Therefore, the main leaders in this network are: Richard Fox, Meryl Pastuch, Tobi Gatlin, Lindsy Henion, Glen Grant, Sheilah Stachniw.
By setting the degree measure at least to 4 we can see clear picture of all interactions within the group.
From above graph we can conclude that mostly people communicate via emails, followed by calls, meetings and making purchases.
For call interactions (green colour) the thickness of the edges show weight of that connection type between different individuals: Medeline Nindorf -> Lizbeth Jindra, Kerstin Belveal <-> Sherrel Biebel (both sides), Richard Fox -> Lindsy Henion.
For email interactions (purple line): Rosalia Larroque <-> Kerstin Belveal, Kerstin Belveal -> Lindsy Henion, Meryl Pastuch -> Lindsy Henion.
For meetings interaction (orange colour): Meryl Pastuch -> Rosalia Larroque, Richard Fox -> Meryl Pastuch, Richard Fox -> Kerstin Belveal, Madeline Nindorf, Julie Tierno, Sherrel Biebel.
For purchases(blue colour) there is only Geil Feindt from whom Richard Fox, Tobi Gatlin, Meryl Pastuch and Lizbeth Jindra purchase.
Changes in the group composition depending on activities and over time
When we filter our the overall connections by year we can see that mostly communications happened in 2016 (40.35%) , followed by 2015 (32.02%) and lastly 2017 (27.63%).
In 2015 there are 41 nodes and 73 edges, whereas in 2016 the number of nodes increased to 45 nodes and 92 edges and mostly communications were experienced in November and December of 2016.
In 2017 even the number of the people interacting increased to 47, however, the intensity of the interaction decreased to 63.
Similar patterns as other suspicious individuals
As we see from here Gail Feindt is the same person that previously Richard Fox, Lizbeth Jindra, Meryl Pastuch and Tobi Gatlin has made a purchase. By Filtering the month we can see that this purchase happened on 7th of June,2017 at the same time if we look at previous group purchase time the Month is exactly the same which happened on 23th of June,2017.
Another point is before purchasing from Gregory Russell Beth Wilensky had a meeting with Errol Eklov, which shows the same pattern when in previous image we saw meeting of Rosalia Larroque with Meryl Pastuch.