TshepoKgopane/SA-Crime-Analysis-PowerBI

Built an interactive Power BI dashboard analyzing South Africa’s crime trends. It breaks down crime by province, category, and year, with insights on hotspots and year-over-year changes — all designed to make data-driven decisions easier and faster. #South Africa Crime Analysis Dashboard This Power BI project explores crime trends across South Africa's provinces and crime categories over multiple financial years. #Project Overview The dashboard provides interactive insights into: - Year-over-year changes in crime incidents. - Provincial crime rates normalized by population. - Top crime categories contributing to total crime. - Regional hotspots and trends over time. It is designed to support better decision-making by highlighting where resources should be focused to improve public safety. #Features - Dynamic filtering by Province, Crime Type, and Year. - Key Performance Indicators (KPIs) showing total crimes and trends. - Drilldowns into provincial crime rates and top categories. - Year-over-Year (YoY) comparison to monitor changes. - Clean, minimalist design for easy storytelling with data. #Tools & Technologies - Microsoft Power BI - DAX (Data Analysis Expressions) - Power Query (for data cleaning) - Time-Intelligence functions (YoY Analysis) #Files - SA Crime Analysis Report.pbix - Power BI file containing the dashboard and DAX measures. #How to View the Report 1. Download the `.pbix` file. 2. Open it in Microsoft Power BI Desktop. 3. Explore the report interactively! --- Tshepo Vincent Kgopane- Aspiring Business/Data Analyst