Trend Analysis

The below worksheet and dashboard helps to understand the Crime trends in Los Angeles. All the trend analysis are in tableau. To refer to respective worksheet and dashboard for detailed view, please click on the below images.

Overall trends of crimes over the years in Los Angeles

Here we can see the overall trends of crimes of last three years. From the graph it is evident that for most of the months maximum crimes are in 2017. With every passing year crime cases have increased and it is highest in 2017, i.e. the most recent year of our analysis. This showcases the ascending number of crime cases in Los Angeles. This trend tells us the severity of the problem of increase in crime rate in Los Angeles over the years.  

Trend of Crimes in Los Angeles
Overview of Crimes in Los Angeles

This dashboard represents type of crimes, the demographics of the victim’s age, and the status of the crime. Maximum crime observed are of battery, domestic assault, and assault in general. Overall age distribution of victims age across crimes shows that maximum crime occurred in the age group of 19-28 in the crime type domestic assault. We can filter on crime type, gender, age distribution to observe the trends across crime type and demographics of the gender. Using this dashboard, police department would know that on which age group and gender they should concentrate to reduce the particular crime. Additionally, it shows how many crimes are still pending to investigate so that necessary action are taken.

Overview of crimes in Los Angeles
Gender comparison across crime type

In the below graph, we can observe the total crime cases for male in blue and for female in red. The number of crime cases differs for different crime type. As observed, the female crime cases is highest for Domestic Assault crime whereas male crime cases are highest for Battery. The top three crime for both the genders is Domestic Assault, Battery and Assault.The total crime cases for male and female are equal for Battery crime. This would help the police department to focus on most dominant crimes specific to gender.

Crime Description vs Gender Cases
Average time taken to report for each type of crime

Here, we can see the average time taken to report the crime based on crime type. This will help the police department of Los Angeles to create awareness about the importance of reporting crime as soon as possible. Maximum awareness is needed to report the sexual unlawful crime and human trafficking as per the below chart. For example: If a criminal is commiting crime continuously, and if the report is registered then police department can investigate and catch the criminal to stop further crimes.

Average time taken to report for each type of crime
Distribution of crimes during the day

This chart shows that maximum crimes occurred at what time of the day i.e. morning, afternoon, evening or night. Maximum crimes are occured at night. So the people of Los Angeles should be cautious while commuting at night. Additionally, Los Angeles police should be more alert and do the patrolling at night in every 2 hours to reduce the chances of crime.

Distribution of crimes during the day
Conclusion

From our analysis on the dashboard we can conclude that crimes have been rising over the years. The highest number of crime cases are in battery, domestic assault, and assault in general. We can assess the demographics of victims across crime type. Time taken to report a particular crime type will help the police department to create awareness. Below are the insights from the above charts: 

  1. It is observed that maximum crimes are occured in the months of July, Oct, April.
  2. Except for the months of February and April in every month number of crime in 2017 have increased.
  3. The distribution across gender for battery is almost equal, in the age group of 19-58.
  4. For domestic assault maximum crimes are occurred with females, in the age group of 19-38.
  5. In general assault, maximum number victims are males, in the age group of 19-38.
  6. For forcible rape crime, maximum crimes are occured on females i.e. 3,526 and while in males it’s just 34.
  7. For all other crimes, in general maximum crime occurred in the age group is 19-48.
  8. Overall, maximum crimes have happened with females compared to males.
  9. Overall, average time taken to report the crime case are on higher end in the crimes related to forcible sexual acts and child abuse.
  10. Maximum crime have occured during night i.e. 9:00 pm to 5:00 am.