Challenge11TacticalLondonCrimes

Summary

Report submitted for FP20 Analytics ZoomCharts Challenge, November 2023. The report was built with Tactical Crime Analysis dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI. 

Author's description:
The main insights are outlined below:
· There are 10000 people registered in the database, whose 7877 were involved in any of 2500 crimes registered in the 3 years analyzed.
· The top 5 crime types registered in the city of London were Violence and Sexual Offenses leading the top with 959 cases (38%), followed by far for Anti-Social Behavior with 473 (18.92%) reported cases. Finally, Public Order with 198 cases (7.92%), Criminal Damage with 180 cases (7.20%), and Vehicle Crime with 177 cases (7.08%) make up the last three places in the countdown.
· Along the three years analyzed, it can be observed there is a cycle of about 4 months in between where crimes recorded an increase in crime rates and the same behavior occurs regarding the months with the lowest crimes registered which says the trend of crime occurrences are cyclical and might be related to specific seasons along the year where the Police department should pay more attention to lower those figures.
· As for clearance rates, most of the crime types observe a clearance rate over 60% where “Possession of Weapons” is the one with the highest proportion whereas “Robbery and Mugging” has the lowest clearance. For the most part, the clearance rate of crimes is around 70%.
· Crime roles listed in the study show a similar proportion in terms of gender involvement where male offenders account for 41% and their female counterparts around 38%. For victims, the proportions yielded the opposite compared to offenders; regarding the other roles the proportions for both genders were the same, 7% for both Accomplices and Informants. Witness showed 6% for males and 7% for females.
· The biggest challenges according to this survey are to address the crimes with the highest rates by targeting the boroughs with the greatest occurrences, research the main reasons for these facts, and increase the clearance rates by training the police force on how criminality should be approached. Make bigger recruiting campaigns to attract new potential members to the Police to increase the personnel within the city and spread them on the places considered “dangerous” especially on certain days of the week.
· Also, conduct research regarding those who identified as Ethnicity 1, Ethnicity 2, or Ethnicity 3 as they were involved in most of the crimes registered in the study. The main topics should be a deep study of the backgrounds, and chances of improving their life quality in terms of job opportunities to avoid falling into criminality.