DEV Community

Cover image for Analyzing Crime against women in India.
Kaira Kelvin.
Kaira Kelvin.

Posted on

Analyzing Crime against women in India.

#discuss #datascience #data #sql

About this project

Purpose:

The aim of this project is to analyze crime against women in India during the year 2022. By transforming raw crime statistics into visual insights through Power BI.

Objectives.

  1. To identify the most common crime types affecting women.
  2. To analyze the states with the highest and lowest number of reported cases.
  3. To highlight correlations and patterns in gender-based violence.
  4. To provide insights that can inform prevention and policy decisions.

Tools and Technologies used.

  • Power BI Desktop : for data cleaning, modelling and visualization.
  • Dataset : National Crime Records Bureau (NCRB) 2022 - Crimes Against Women.
  • Data Model : State-wise and crime-type-wise aggregation with calculated metrics such as crime rate per 100k population and percentage distribution.

Key Insights.

a.Overview.

  • Total crime cases Reported 445,000
  • States/UTs Covered: 35
  • Total Crime types: 20
  • Women Population: 686M
  • Overall Death Rate: 1.5%

b.Frequent Crimes Against Women

  • Reflecting a troubling global pattern, cruelty by husband/relatives stands out to be most persistent and underreported crimes against women, cutting across culture,economy and geography.

c.Insights Summary.
🔴 Uttar Pradesh consistently ranks highest in total reported cases, demanding urgent intervention.
❗ Domestic abuse is systemic: Found across every Indian state with alarming frequency.

  • Lakshwadeep city is the safe city in India that had no incidence of crime committed against women.

  • The Safe regions show that crime reduction is possible through social cohesion, education, and proactive governance.

Conclusion.

  • The Crime Analysis in India 2022 project paints a sobering but necessary picture of women’s safety in India. While progress has been made in reporting and awareness, the persistence of domestic abuse, dowry deaths, and crimes against young girls shows that gender-based violence is both a social and cultural challenge. Through data-driven storytelling and visual analytics, this project serves as both a mirror and a call to action — urging policymakers, citizens, and advocacy groups to turn insights into impact.

Top comments (0)