Copyright © 2025 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

@article{182288,
        author = {Parth Hemantrao Deshmukh and Prof. Prashant Kulkarni and Prof. Vishnupant Potdar},
        title = {Crime Analysis in India (2001–2013): A Data-Driven Study Using MySQL and Power BI},
        journal = {International Journal of Innovative Research in Technology},
        year = {2025},
        volume = {12},
        number = {2},
        pages = {1257-1262},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=182288},
        abstract = {This paper presents a comprehensive analysis of crime trends in India over a 13-year period (2001–2013) using structured data tools (MySQL) and interactive dashboards (Power BI). Official NCRB data were cleaned, transformed and stored in a relational database; SQL queries extracted insights on annual growth, state-wise distribution, and crime categories. The results—visualized through line charts, bar graphs, and heatmaps—show a steady rise in total reported crimes (on the order of 40–45%) and highlight key patterns: Maharashtra accounted for the highest cumulative crimes, while states like Uttar Pradesh, Bihar and Madhya Pradesh were major contributors. Certain crime types (notably kidnapping and rape) grew disproportionately fast. These findings illustrate how advanced analytics can support stakeholders: policymakers gain evidence for targeted resource allocation and policy formulation; law enforcement can identify hotspots and plan interventions; and public safety initiatives are informed by transparent crime mapping to empower communities. The study’s expanded methodology and detailed visual outputs (Figures 1–3) demonstrate the value of combining SQL and Power BI for large-scale crime data analysis, with implications for improving governance and citizen safety.},
        keywords = {},
        month = {July},
        }