ISSS608 2016-17 T1 Assign3 CHIA Yong Jian IDs with large volume of communications

From Visual Analytics and Applications
Jump to navigation Jump to search

CHIA YONG JIAN Assign3 CSI Logo.png Episode VA3: "A Crime-Filled Weekend at DinoFun World"

[Home]

[Data Review and Prep]

[Large Volume Comms IDs]

[Ten Comms Patterns]

[Discovery of Vandalism]


CHIA YONG JIAN Assign3 IDLogo.png

IDs with large volume of communications

An visual exploration of the communications data was done in Tableau.

Overall Observations - Top Senders of Communications

Using a boxplot, there are two particular IDs that stands out for the number of communications sent across the three days - 1278894 and 839736. When the observations was done by each day over the three-day period, both IDs consistently show the highest percentage of records of the total communications sent. An interesting observation is that on Sunday (June 8), the percentage of communications sent by ID 839736 jumped in comparison to the other days.

CHIA YONG JIAN Assign3 Task1 FromByDay.png



Overall Observations - Top Receivers of Communications

Using a boxplot, the top three receivers of communications was ID 1278894 and 839736, and communications to "External" parties. When observed by each day, the top IDs for received communications remained consistent. An interesting observation is on Sunday (June 8) where there was a spike of communications to ID 839736. A drill down of data for this ID will be needed for further analysis to understand why the spike.

CHIA YONG JIAN Assign3 Task1 ToByDay.png

Next, an investigation will be drilled down into the IDs identified above. Note that for communications sent to external comms will not be elaborated in this section but be further explored in another section.

ID 1278894 - DinoFun World App feature server messages

A heatmap was constructed in Tableau with the hour and second timings displayed for this ID by each date. You can notice that this ID sends out messages right on the dot every 5 minutes, when it is active. Furthermore, there is only 1 location where the messages are sent from - Entry Corridor. The messages tend to get more approaching Sunday as well. Given the preciseness of the timestamps, it is hypothesized that this could be a feature in the DinoFun World App (possibly for the Cindysaurus Trivia Game), with the server sending messages to park visitors throughout the day.

CHIA YONG JIAN Assign3 Task1 1278894.png



ID 839736 - Park Information and Service line

For this ID, the amount of communications remained generally flat on Friday and Saturday, but have large spikes on Sunday. Based on the timestamps, you will notice that there was a spike in messages sent to this ID at 12pm, with replies coming at 12.03pm. Secondly, at almost 2.42pm, there was also a spike in messages from this ID, with immediate responses from other IDs around 10 seconds later.

It is probably not possible if this ID is an individual, after all, to send so many messages to other park visitors at one time will likely be restricted in the app. The spike in the messages to and from may suggest some event or activity going on, causing the spike. If that's the case, this ID could possibly be the park information and service communications line for visitors to report and receive important information on what's going on in the park. This can be further strengthened by the fact that all communications from this ID came from the Entry Corridor location in the park, which is the entrance to the park.

CHIA YONG JIAN Assign3 Task1 839736.png



Next: 10 Communication Patterns