BriggsJobi/substance-abuse-crime-analysis-excel

Data-driven analysis project using Microsoft Excel to explore the relationship between substance abuse and criminal activities in Nigeria through demographic analysis, trend visualization, and business intelligence reporting. # Substance Abuse & Crime Nexus in Nigeria ## Project Overview This project presents a data-driven analytical study exploring the relationship between substance abuse patterns and criminal activities in Nigeria using Microsoft Excel. The analysis was designed to uncover behavioral trends, demographic vulnerabilities, overdose patterns, crime distributions, and regional incident relationships associated with drug abuse and criminal activity. Using interactive dashboard reporting and business intelligence techniques, the project transforms raw incident-level data into actionable insights capable of supporting: - public health awareness, - crime prevention strategies, - rehabilitation planning, - and evidence-based decision-making. The dashboard enables users to explore: - monthly incident trends, - demographic distributions, - crime categories, - overdose patterns, - and regional crime statistics through interactive visual analysis. --- # Project Objectives The primary objectives of this project include: - To identify demographic groups most affected by substance abuse - To analyze the relationship between drug use and criminal activities - To examine overdose patterns across drug categories - To identify regional and behavioral crime trends - To monitor monthly incident fluctuations - To develop an interactive Excel dashboard for analytical reporting - To generate strategic recommendations and social-impact insights --- # Tools & Technologies | Tool | Purpose | |------|----------| | Microsoft Excel | Data analysis and dashboard development | | Pivot Tables | Aggregation and analytical reporting | | Pivot Charts | Data visualization | | KPI Cards | Executive dashboard reporting | | Slicers | Interactive filtering | | Excel Formulas | Data transformation and calculations | | CSV Dataset | Raw incident-level data source | --- # Project Structure ```text Substance-Abuse-Crime-Analysis/ │ ├── raw-data/ │ └── substance_abuse_crime_dataset.csv │ ├── analysi …