I
FN558
Management Information Systems
Assessment 1
IFN558 Management Information Systems
Assessment 1
Student Id:
Problem formulation & design motivation
Problem Formulation
There is an upsurge in safety concerns amongst the public citizens of Springfield Virginia due to the enhanced coverage of crime situations by different media outlets. This pressure is felt more by Mayor Jones with an impending election, citizens are waking up to the fact that safer neighborhoods have to be worked for there is a lot of data that was collected on crime between 1998 and 2019, however, most of it lies underutilized. Election, as citizens, demand action to improve safety. Crime data collected between 1998 and 2019 contains valuable insights but remains underutilized. Chief Odinson, the commander of the Springfield Police Department, does not possess the necessary analysis, or methods to get useful information from a large number of reports on crime incidents. To address the rising concerns of public safety and improve police management, the problem at hand is twofold: offering clear and distinct information about the crime rate to the mayor, considering social issues, as well as helping the heads of police to enhance the management of crime prevention tools in three regions, including Springfield Central, North Springfield, March Springfield, West Springfield.
Design Motivation
To solve these problems, a data-driven dashboard is suggested by utilizing over 23,000 instances of crime data collected over 21 years. The dashboard will be tailored to the needs of three key stakeholders:
Mayor Jones: The design will be to present crime rates and trends in the whole city as well as social problems. By presenting data in the form of heat maps, line graphs, or crime frequency distribution, the Mayor will have the overall information about the safety status in the city and therefore have the necessary information on where to focus measures.
Chief Odinson: The dashboard will analyze the rates of crimes in all three suburbs; Central, North, and West Springfield. Again, the Chief would be quickly aware of which suburbs are most dangerous and require the allocation of more police strength and also know which suburbs require different patrol strategies due to differences in the type and frequency of the crimes committed in the different suburbs.
Sergeant Rogers: For localized information, the dashboard will focus on one suburb greater in depth. This will particularly focus on the certain category of crimes, the criminals and the time and places of the occurrence of the crimes to assist the Sergeant in the deployment of the police force in his region.
Digital
dashboard development
The dataset contains over 23,000
instances of crime reported in Springfield, Virginia, between 1998
and 2019. It includes details on the crime location, offender and
victim demographics, weapon use, gang affiliation, and crime
classification. This data provides crucial insights for understanding
crime patterns across different areas of the city. To analyze the
above problems for all three stakeholders, three charts will be made
to solve each stakeholder's problem.
Early Dashboard:
Figure 1: Early version
This above dashboard is the early dashboard. This is the rough dashboard, that tries to solve all three stakeholders' problems. This dashboard contains three charts, one is related to Mayor Jones, the second is related to Chief Odinson and the third is related to Sergeant Rogers.
The chart “Sheet 1” shows the number of different types of assaults committed by various racial groups. The highest number of assaults is committed by White offenders, followed by Black offenders. The most common type of assault is Simple Assault with Injury. According to this graph, it can be easily “White” offenders have has most criminal records for verbal Threat assault. Aggravated assault has the least criminal records for each offender race.
The chart “Sheet 2”, the distribution of different types of assaults committed by various racial groups. The data is presented in pie charts, with each chart representing a specific crime type. The different colors within each chart correspond to the percentage of each racial group involved in that crime. The chart reveals that White offenders are the most prevalent in all types of assaults, followed by Black offenders. According to the above charts it can be easily seen that postcode “22151” has the highest criminal records. This postcode represents the area “North Springfield”.
The chart “Sheet 3” shows the trend of "Count of Crimes" over the years 1997 to 2020, categorized by whether the crimes were private or not. It appears that the number of private crimes increased from 1997 to around 2001 and then decreased steadily until 2010. After 2010, the number of private crimes remained relatively stable. In contrast, the number of non-private crimes showed a slight increase from 1997 to 2001, then decreased until around 2009, and finally increased again until 2020.
Advance version:
Figure 2: Advanced version
The above dashboard shows the advanced version of the early dashboard (Tableau, 2024). This dashboard has chart four charts, three charts for each stakeholder and one shows overall performance. This advanced version dashboard has the same charts but is modified. This advanced dashboard has charts formatting better than the early dashboard and also has detailed charts.
Chart “Societal issues surrounding crimes”, shows the number of crimes reported to the police and not reported, categorized by offender race. It reveals that the majority of crimes are committed by White offenders, followed by Black offenders. The highest number of unreported crimes is also attributed to White offenders. The data is presented in a stacked bar chart format, with each bar representing a different racial group and the different colors within each bar representing the types of crimes.
Chart “Comparison of all three suburbs” shows the distribution of different types of assaults committed in three suburbs. The data is presented in bubble charts, with the size of each bubble representing the frequency of a particular crime type. The different colors within each chart correspond to the percentage of each suburb involved in that crime. The chart reveals that Verbal Threat Assault is the most common crime across all three suburbs, followed by Simple Assault with Injury.
Chart “Crimes in the local area” shows the trend of crimes against male and female victims in a local area from 1997 to 2019. It appears that the number of crimes against both males and females increased significantly from 1997 to 2002, then decreased until around 2009, and finally increased again until 2019. However, the trend for male victims seems to be more volatile than that for female victims.
Final version:
Figure 3: Final version
The above dashboard shows showing the final version of the dashboard (Tableau, 2024). The dashboard provides a comprehensive overview of crime trends in Springfield, addressing the needs of three key stakeholders. For Mayor Jones, societal issues surrounding crimes are highlighted, showing that White offenders contribute most to both reported and unreported crimes. Chief Odinson can compare crime types across the three suburbs, with Verbal Threat Assault being the most common. For Sergeant Rogers, the dashboard shows crime trends by gender in a local area, revealing fluctuations in crimes against male and female victims over the years. The advanced dashboard offers improved chart formatting and details, helping the stakeholders better analyze crime data.
Mayor Jones: The dashboard helps address public concerns by identifying the most frequent offenders by race and highlighting unreported crimes. This data allows her to implement community-based programs and awareness campaigns to reduce crime and increase public safety perception.
Chief Odinson: The comparison of crime types across the three suburbs (Central, North, and West Springfield) enables Chief Odinson to allocate police resources more effectively, prioritizing areas with higher crime rates and the most common types of offenses.
Sergeant Rogers: The local area crime trends provide Sergeant Rogers with detailed insights into crime patterns over time, allowing him to strategize responses and target crime prevention efforts in specific areas, based on historical and current data.
Reference:
Tableau. (2024). Dashboards. [online] Available at: https://www.tableau.com/learn/get-started/dashboards [Accessed 7 Oct. 2024].
?Tableau. (2024). Tableau Dashboard Showcase. [online] Available at: https://www.tableau.com/data-insights/dashboard-showcase [Accessed 7 Oct. 2024].
?
