The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Chicago Crime Data Cleaning, SQL Analysis and Power BI Visualization:
I independently completed a crime data analytics project using Chicago crime records to examine crime patterns, arrest trends and geographic concentrations.
The project involved cleaning and transforming raw crime records using MySQL, designing a relational database structure and developing analytical reports using SQL and Power BI.
Key activities included:
Cleaned and transformed Chicago crime records using SQL.
Created structured relational tables for criminal cases, crime classifications and geographic information.
Identified missing values and duplicate records.
Used SQL queries to analyze crime frequency and arrest patterns.
Examined crime distributions across categories and locations.
Developed Power BI dashboards to communicate analytical findings.
Key findings:
Battery was the most frequently recorded crime category.
Simple domestic battery accounted for 8.21% of recorded incidents.
Approximately 15.48% of recorded incidents resulted in an arrest.
Battery represented 22.92% of arrests, followed by narcotics at 17.22%.
Tools: MySQL, SQL, Power BI and DAX.
Deliverables: Cleaned datasets, relational database tables, SQL scripts, analytical findings and interactive Power BI dashboards.
This project demonstrates my ability to work with large public datasets, perform structured data analysis and communicate findings through visual reporting.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Your best-selling dish could be losing you money.
That insight shaped my dashboard work on DineIQ, a restaurant analytics competition project.
My challenge: turn complex analytics into clear, useful views. I approached it with focused Django dashboards, practical filters, and role-based access—helping managers explore their location’s menu performance and wastage together.
My role covered full-stack integration, UI/UX, dashboards, and architecture. Built with synthetic competition data, DineIQ illustrates why sales volume alone doesn’t tell the full story.
Better decisions start with better visibility.
#FullStackDevelopment #Django #DataAnalytics
A dashboard with a lot of data doesn’t have to feel overwhelming.
The focus here was on clear hierarchy, easy-to-scan risk alerts, and making complex payment data feel simple and intuitive. Dark UI, structured analytics, and just enough color to guide attention where it matters.
What do you think of this direction?
Looks so clean! Love it 👏
I co-designed High Drop Sum (HDS), a KPI that tracked attendance drops class by class in a free 10-day intro course, with yellow and red alerts that triggered tiger team outreach. I mapped every department’s touchpoints, cut early sales pressure, and led the data analysis. Course attendance rose 10%, with fewer cancelled cohorts.
