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.

Pattern #2 - Identifying the Dynamics of Park Activities

Analysis and Findings

Some of the observations from the above visualization: -

• The openings hours of the park were from 8:00am to 23:00pm.
• Saturday and Sunday had higher communication volume than Friday, that means more visitors over the weekend.
• Comparing movement and check-in, larger communication happened when visitors checked in at attractions in the park during Saturday and Sunday.
• Again, similar to earlier analysis, there was a spike of communication data observed for both check-in and movement on Sunday @ about 12pm.
• From the charts of Sender and Receiver activities during the 3 days, the volume of communication of Thrill rides was much higher than other types on both Saturday and Sunday.
• One thing to observe is the comm pattern at Entrance followed a periodical pattern of high volume at regular intervals, then the comm ceased at the alternate intervals. This could due

Pattern #3 - Abnormal Communication Volume from ID:839736 on Sunday

From Task 1, we have found out ID 839736 stand out with large communication volume on Sunday. Over here, we will further investigate what could had caused the large communication volume on that day.

Analysis and Findings

The obvious abnormality in communication volume was observed on Sunday, with two obvious peaks. One very obvious peak was at 12 noon, and another was at about 2pm.