GreatChidera/Regional-Crime-Insights-In-Sub-Saharan-Africa-1974-2020-Using-Microsoft-Excel

# Regional Crime Insights In Sub-Saharan Africa (1974-2020) Using Microsoft Excel ## Table of Contents - Project Overview - Objectives - Process - Tools - Key Insights ### Project Overview This dashboard provides a comprehensive visual analysis of regional crime and violence in Sub-Saharan Africa from 1974 to 2020. It highlights key metrics such as total fatalities, injuries, countries affected, and the most dangerous forms of violence. Users can filter data by country, year, and perpetrator group to explore trends. The dashboard uncovers insights on the most targeted victims, deadliest perpetrator groups, most attacked cities, and yearly fatality trends—offering valuable context for understanding regional security dynamics and informing policy decisions. ### Objectives - To analyze patterns of violence and crime across Sub-Saharan Africa over a 39-year period. - To identify the deadliest forms of violence and most impacted countries, cities, and victim groups. - To uncover trends in fatalities and injuries over time. - To assess the role of perpetrator groups in regional instability. - To provide an interactive tool for stakeholders to explore regional crime data for research, policy-making, and security planning. ### Process - Data Collection: Gathered regional crime data (1974–2020) from reliable sources. - Data Cleaning: Used Excel to remove duplicates, fix errors, and handle missing values. - Data Structuring: Organized data by year, country, violence type, and perpetrator group using tables and filters. - Analysis: Applied Excel functions, pivot tables, and charts to explore trends and patterns. - Visualization: Created interactive dashboard elements using slicers, bar charts, and line graphs for clear insights. ### Tools - Microsoft Excel – for data cleaning, analysis, and dashboard creation - Pivot Tables & Charts – to summarize and visualize trends - Slicers – for interactive filtering by country, year, and perpetrator group - Conditional Formatting – t …