One of the modules I've done in QUT was to work with a teammate to analyse and visualise data on crimes committed between 1998 to 2019 in Springfield, Virginia (US). The objective of this assignment is to analyse the given data using Tableau to present findings to the Mayor of Springfield, the Police Chief of and the Police Sergeant. Final result of this case study was provided as a video presentation (shown in the Youtube Video below). I received a grade of 7 for this course. More information regarding the case study can be found below the video. Time taken: 3 weeks
Stakeholder Information
Mayor Jones:
Concerned about social welfare of citizens due to increasing crime rate
Received complaints by citizens as they no longer feel safe
Next year is election year
ChiefOdinson:
Responsible for crime portfolio
Responsible for entire police force across areas within Springfield
Wants to improve how he manages the police force
Sergeant Rogers
Middle Management User
informed the Chief that the police required more information to understand the nature of the crimes in the area, so that they can be better equipped to respond
Stakeholder Requirements
Mayor Jones – to improve societal issues surrounding crimes
Mayor Jones makes long term, high level decisions, such as allocating budgets and developing policies
Chief Odinson – to manage the Springfield Police Department in Central Springfield, North Springfield, and West Springfield
Chief Odinson makes long term decisions for how the police force is managed overall, so all 3 suburbs were addressed with the particular issue
Sergeant Rogers – to be more informed of the crimes in the local areas
Sergeant Rogers is the middle management user. The most worrying suburb (i.e highest crime rate) is addressed