Analysis of All Types of Crimes in India in Power BI

Problem Statement: 

The study aims to analyze the trends, patterns, and variations in IPC crimes across India between 2020 and 2022. Using Power BI for visualization and analytics, the research focuses on understanding the rise and fall of different crime categories, their relative contribution to overall IPC crimes, and the implications for law enforcement and policymaking.

Download Dataset 👉👉👉👉Analysis of All Types of Crimes in India

Research Questions to be solved

Trend & Pattern Analysis

1. What are the year-wise trends of major IPC crimes between 2020–2022?

2. Which crime heads have shown an increase or decrease over the years?

3. What is the average annual growth rate of different crimes?

Comparative Analysis

4. Which crimes have the highest crime rate per year?

5. How does the percentage share of each crime head in total IPC crimes change year by year?

6. Which crime categories contribute the most to overall IPC crimes in India?

Policy & Social Impact

7. Are there specific categories of crimes that consistently remain high, indicating systemic issues?

8. Which crimes saw significant reduction during or post-COVID-19 years?

9. What insights can be drawn to guide law enforcement agencies for targeted interventions?

Correlations & Insights

10. Is there a correlation between crime rate trends and total number of cases for specific crime heads?

11. Which crimes have relatively low case counts but high crime rates (indicating severity)?

12. Can the distribution of crime types highlight underlying socioeconomic or governance challenges?