ISSS608 2017-18 T3 Assign Manu George Mathew Q3

VAST Challenge 2018:Suspense at the Wildlife Preserve

Background

Data Preparation

Question 1

Question 2

Question 3

Conclusion

Back to Dropbox

Question:

Using the combined group of suspected bad actors you created in question 2, show the interactions within the group over time.

Visualization and Analysis

Description	Illustration
1.Characterize the group’s organizational structure and show a full picture of communications within the group We can observe that, Madeline Nindorf has never interacted trough email. Only 8 people have initiated purchases in the group. Only 5 people have taken part in meetings.	All communications within the group. Each point shows an instance of communication. Taking a drill down view onto the meetings and Purchases,
2.Does the group composition change during the course of their activities? Using the following visualization, we can observe that 2 of the members in the group moved away from in the course of their activities. They are Alex Hall in 2016 and Madeline Nindorf in 2017. But this again does not talk about whether they were part of the group's activities during this period. the second set of visualizations, aims to solve this predicament. We observe that the out of 28 people, the count of people taking part in communications are 2015 : 26 people 2016 : 25 people 2017 : 21 people We also observe that, Jenise Savaria and Gail Feindt never initiate communications. There was just 1 meeting in 2016 as compared to other 2 years. Jain Tylor and timothy Gibson have been constantly communicating eachother and placing orders with Gail Feindt. This could indicate that they are most likely not associated with the group as assumed in Question 2.	Looking at the interactions year wise, In 2015: In 2016: In 2017:
3.How do the group’s interactions change over time? By using the dashboard provided, we can analyse the group's interactions over time. We can find that towards the end, the group actively involved is different from the one that was involved in the beginning except for a couple of people like Richard Fox.	The communication Trend is visualized as shown.

Links and Guide to Dashboard

View the interactive Tableau design here:
Link to tableau dashboard in Sub Question 1 and 2
Link to tableau dashboard in Sub Question 2 and 3

Insights

By using the above Plots, we can infer that,

• The group is comprised of people who joined in November of 2015 if we exclude Richard Fox, Jane Tyler, Gail Feindt and Timothy Gibson.
• The only interaction Jenise Savaria had with the group was in 2017 when Rosalia Larroque placed the purchase order with her.
• The above purchase was unusual as all the past purchases have been handled by Gail Feindt. This brings a possibility that Gail Feindt has backed out of the group's activities.
• Jane Tyler, Gail Feindt and Timothy Gibson have been in the organization the longest over time.
• We aslo see that Alex Hall left the company in 2016 and Madeline Nindroff left them in 2017.
• By observing the Target Label axis of the Dashboard, we can see that, over the years, the number of people being contacted is showing a decline.
• Checking the over time transaction patterns, it is highly possible that Jane Tyler and Timothy Gibson are not part of the group's operations. Thus the criterion for suspicious people could be changed to more than 8 interactions with the group.