ISSS608 2016-17 T1 Assign3 XU Qiuhui When was the vandalism discovered
Mayhem at DinoFun World
|
|
|
|
|
Narrow down suspects
- Check-in the Pavilion before 9:00am or stay at the border of Wet Land and Coaster Alley between 9:00am and 11:30am.
- Visitors who hanging around the park and visited more than 4 locations, or took rides earlier that day, or visited Kiddie Land are not less suspicious.
- Criminals tend to spend more time around the Pavilion to observe and familiarize surrounding environments. So between the time they check in and 9:30am, they must spend majority time at Wet land.
130 unique IDs left.
- Communicate to no more than 10 distinct persons. Since criminals are not tending to connect to too many people while they commit vandalism.
- Since we consider external as social media, so criminals shouldn’t have connections with external.
After filtering, there’re only 17 unique IDs left, all of them don’t have any communication records on Sunday.
- If the visitor didn’t leave after vandalism was discovered, or even stay late in the park, they are not likely to be criminals.
After preceding filtering, there’s only one ID left, it’s 1983765. So he MUST BE THE CRIMINAL!!!
Movements of Criminal:1983765
For interactive dashboards, please refer to Online Workbook at Tableau Plublic For video, please refer to YouTube via this link.
The criminal, 1983765, checked in Pavilion at 8:32:40am on Sunday, then committed vandalism between 8:32:40am to 9:08:18am, then left the Pavilion.
The criminal checked in the park at Raptor Restroom, Tundra Land at 8:15:21am, then straightly go to the Pavilion where vandalism happened. After he vandalized the Pavilion, he then went to hide in Scholtz Express from 9:13:58am to 11:33:28am. After that, he left the part via the same path as he entered. He finally left the park at 11:47:07am, at Raptor Restroom, Tundra Land.
