ISSS608 Assign3 HoLiChin Task2

Introduction

Data Preparation

Task 1

Task 2

Task 3

Visualisation Links & Conclusion

Task Requirement

Describe up to 10 communications patterns in the data.
Characterize who is communicating, with whom, when and where.
If you have more than 10 patterns to report, please prioritize those patterns that are most likely to relate to the crime. Note: Please limit your response to no more than 10 images and 1000 words

Communication Patterns

Pattern #1 – Big Groups

Analysis and Findings

From the above Qlik Sense visualisation, besides ID 1278894 and 839736, there were some IDs top in sending large volume of messages (more than 3000 texts, but less than 5000) over the 3 days. The top 5 IDs (in descending order) are 1045021, 1116329, 1749109, 918738 and 1388162. In the bar chart in lower quadrant, it shows that those high volume IDs had sent messages to a big group of unique receiver IDs.

For example, by drilling down the first ID 1045021, it’s observed it had sent 3.81K messages to about 2.77K unique Receiver ID. This ID was in the park for all 3 days, and most messages were sent on Friday & Sat, at Wet Land. From the above, we might deduce that this group of IDs could be the group leaders sending the bulk messages to the group members, or they could be the Park staff that sent information to visitors.