Difference between revisions of "ISSS608 2017-18 T3 Assign Jyoti Bukkapatil Conclusion"
Jump to navigation
Jump to search
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | <div style=background:#2B3856 border:#A3BFB1> | ||
+ | [[Image:MC3_2018.jpg |200px]] | ||
+ | <b><font size = 5; color="#FFFFFF"> VAST Challenge 2018 MC3 </font></b> | ||
+ | </div> | ||
+ | <!--MAIN HEADER --> | ||
+ | {|style="background-color:#1B338F;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
+ | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil| <font color="#FFFFFF">Background</font>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil_Data_Preparation| <font color="#FFFFFF">Data Preparation</font>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil_Methodology_&_Dashboard_Design| <font color="#FFFFFF">Methodology & Dashboard Design </font>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil_Observations & Insights| <font color="#FFFFFF">Observations & Insights</font>]] | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil_Conclusion| <font color="#FFFFFF">Conclusion</font>]] | ||
+ | |||
+ | |style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
+ | ; | ||
+ | [[Assignment_Dropbox_G1| <font color="#FFFFFF">Back to Dropbox</font>]] | ||
+ | |||
+ | | | ||
+ | |} | ||
+ | |||
+ | |||
+ | |||
+ | |||
=='''Question 1'''== | =='''Question 1'''== | ||
Line 23: | Line 59: | ||
*Richard Fox must have been a most prominent person and most probably initiator of suspicious activities. Followed by Richard, Lindsy Henion, Kerstin Belveal, Tobi Gatlin and Meryl Pastuch were the most active members from a list of suspicious employees provided by Insider. | *Richard Fox must have been a most prominent person and most probably initiator of suspicious activities. Followed by Richard, Lindsy Henion, Kerstin Belveal, Tobi Gatlin and Meryl Pastuch were the most active members from a list of suspicious employees provided by Insider. | ||
*Apart from suspicious members, Shailah Stachniw, Sherrel Biebel and Glen Grant were frequently involved in a conversation with suspicious group members. | *Apart from suspicious members, Shailah Stachniw, Sherrel Biebel and Glen Grant were frequently involved in a conversation with suspicious group members. | ||
− | *After analyzing communication pattern within the group of 34 | + | *After analyzing communication pattern within the group of 34 members over two and a half year of a time period, we could see the composition of the group changed over the time. |
*Not all members were involved in interactions throughout two and half year. For example, Meryl Pastuch was the most active member for the first three quarters however for 2016Q3 and followed by 2017Q1 and Q2, she was not in the picture. which is as good as one group of the organization went out of the frame as Meryl Pastuch was the only person from her organizational group involved in these suspicious activities. | *Not all members were involved in interactions throughout two and half year. For example, Meryl Pastuch was the most active member for the first three quarters however for 2016Q3 and followed by 2017Q1 and Q2, she was not in the picture. which is as good as one group of the organization went out of the frame as Meryl Pastuch was the only person from her organizational group involved in these suspicious activities. | ||
*At the starting of these activities, there were a high number of interactions which reduced over following quarters continuously till 2016Q3 and increased again at the end of the period. | *At the starting of these activities, there were a high number of interactions which reduced over following quarters continuously till 2016Q3 and increased again at the end of the period. | ||
*Surprisingly Meetings request were sent only during 2015Q4 and then at the end of the period that is during last two quarters i.e.2017Q3 and 2017Q4. Apart from these most of the time communication was through either emails or calls. There was only one suspicious purchase order sent that also in 2017Q3. | *Surprisingly Meetings request were sent only during 2015Q4 and then at the end of the period that is during last two quarters i.e.2017Q3 and 2017Q4. Apart from these most of the time communication was through either emails or calls. There was only one suspicious purchase order sent that also in 2017Q3. | ||
+ | |||
+ | =='''Question 4'''== | ||
+ | *other suspicious purchases list provided by the insider other instances of suspicious activities in the company were found. Total five purchases made by below employees were suspicious. | ||
+ | #Pearl Tran | ||
+ | #Jane Ramsey | ||
+ | #Almeta Evancho | ||
+ | #Fairy Boratko | ||
+ | *Structure of this group was similar to the structure of the first group noted by the insider. Role of Alpha Chessor was similar to Richard Fox from the first group. |
Latest revision as of 14:43, 9 July 2018
|
|
|
|
|
|
Contents
Question 1
- From Monthly Time Series Plot we can conclude that Kasios International is stable and there is neither growth or drop in its communication and purchase patterns.
- From Calendar plot we can say that Kasios International works for 7 days a week and 24 hours a day. There is no fixed pattern for a number of communications or purchases. There are peaks on weekdays as well as weekends in all communication and purchases.
- There is a high correlation between the number of calls, emails, and Purchases.
- Number of meetings is continuously growing from last two and half year. Which might be an indication of a change in work culture or might be new initiatives in the company. Further analysis is required to find out increasing more about increasing trend of meetings. This will require additional data.
Question 2
- Based on the analysis we were able to locate suspicious employee group in large data. Suspicious employees belong to six different departments/groups in the organization.
- Richard Fox, Tobi Gatlin, Maryl Pastuch and Lizbeth Jindra are associated with four different groups and have the highest degree (connectivity) within respective groups. Which indicates that these four prominent persons for those groups.
- Out of remaining 16 members, 4 are connected associated to one small group and 12 are associated with one common group.
- We were able to find out 14 other employees who might be closely associated with 20 suspicious employees. Further network analysis revealed that below 6 members are closely associated with suspicious employees.
- Sheilah Stachwin
- Madeline Nindorf
- Terrilyn Overkam
- Jaunita Westen
- Corinne Veatch
- Sherrell Biebel
- We found that Prominent person from each group had sent the Purchase orders to Gail Feindt which looked as if the normal process in an organization. However, there was only one offbeat purchase order placed by Rosalia Larroque to Jenice Savaria. It is this order which insider has listed in his data.
Question 3
- We analyzed interactions between the suspicious group which we found in question 2. So after adding 14 closely associated employees to suspicious group total members were 34.
- Richard Fox must have been a most prominent person and most probably initiator of suspicious activities. Followed by Richard, Lindsy Henion, Kerstin Belveal, Tobi Gatlin and Meryl Pastuch were the most active members from a list of suspicious employees provided by Insider.
- Apart from suspicious members, Shailah Stachniw, Sherrel Biebel and Glen Grant were frequently involved in a conversation with suspicious group members.
- After analyzing communication pattern within the group of 34 members over two and a half year of a time period, we could see the composition of the group changed over the time.
- Not all members were involved in interactions throughout two and half year. For example, Meryl Pastuch was the most active member for the first three quarters however for 2016Q3 and followed by 2017Q1 and Q2, she was not in the picture. which is as good as one group of the organization went out of the frame as Meryl Pastuch was the only person from her organizational group involved in these suspicious activities.
- At the starting of these activities, there were a high number of interactions which reduced over following quarters continuously till 2016Q3 and increased again at the end of the period.
- Surprisingly Meetings request were sent only during 2015Q4 and then at the end of the period that is during last two quarters i.e.2017Q3 and 2017Q4. Apart from these most of the time communication was through either emails or calls. There was only one suspicious purchase order sent that also in 2017Q3.
Question 4
- other suspicious purchases list provided by the insider other instances of suspicious activities in the company were found. Total five purchases made by below employees were suspicious.
- Pearl Tran
- Jane Ramsey
- Almeta Evancho
- Fairy Boratko
- Structure of this group was similar to the structure of the first group noted by the insider. Role of Alpha Chessor was similar to Richard Fox from the first group.