A structured analytics project built on simulated criminal justice datasets from South Africa.
This project explores crime data across different provinces, focusing on criminals, types of crimes, arrests, pending cases, and unresolved incidents.
The goal is to demonstrate how SQL tools can be applied to analyze law enforcement data, uncover trends, and provide actionable insights for decision‑makers.
- Analyze crime records across South African provinces.
- Identify patterns in types of crimes and their frequency.
- Track arrest status (arrested, pending cases, not arrested).
- Provide insights into regional crime distribution and justice outcomes.
- Showcase SQL query development and optimization for real‑world datasets.
- SQL Server / T-SQL → Querying and analysis
- Data Modeling → Structured schema for criminal justice datasets
- Business Intelligence Concepts → Translating law enforcement questions into queries
-
Data Exploration
- Understand dataset structure (provinces, criminals, crime types, case status).
- Identify key attributes for analysis.
-
Query Development
- Write SQL queries to answer justice‑driven questions (e.g., Which province has the highest number of pending cases?).
- Apply filtering, grouping, and ordering datasets.
-
Optimization
- Use indexing and query tuning techniques to improve performance.
-
Insights & Reporting
- Translate raw query results into crime statistics and justice outcomes.
- Highlight provincial differences and systemic challenges.
- Which province has the highest crime rate?
- What are the most common types of crimes across regions?
- How many cases remain pending vs. resolved?
- What percentage of criminals are arrested vs. not arrested?
- Which provinces show the highest number of cases?
- SQL query writing & optimization
- Criminal justice data analysis
- Regional trend identification
- Translating technical outputs into actionable insights
- Highlighted provinces with high crime volumes and low arrest rates.
- Identified pending case backlogs that impact justice delivery.
- Showcased ability to bridge technical SQL skills with social impact analysis.
This project is part of my data analytics portfolio, demonstrating how structured SQL analysis can be applied to real‑world social challenges such as crime and justice in South Africa.