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
Excited to share my latest data analytics project: Traffic Congestion Analysis & Prediction. 🚗📊
This end-to-end project involved processing complex traffic data to derive actionable insights, including:
Visualizing traffic hotspots and congestion trends across Cairo.
Analyzing accident risk factors related to road types, hours, and underage drivers.
Building an interactive dashboard to support data-driven urban planning.
Tools used: Power BI, DAX, and advanced data visualization techniques.
Check out the snapshots below and let me know your thoughts! Always happy to discuss data-driven solutions. 💡
Access the full project and source code here: [https://github.com/Hazemkhaled278/Traffic-Congestion-Analysis-Prediction- ]
#DataAnalytics #PowerBI #TrafficAnalysis #DataScience #Freelance #Traffic"
The hotspot map alongside the prediction dashboard is a great combo, turns raw congestion numbers into something a city planner could actually act on. Was the traffic data public/open source, or did you have to piece it together from multiple sources?
Thanks, Maty
Glad you find the combo effective. As you suspected, the data wasn't readily available. I had to scrape and aggregate it from multiple sources and perform extensive cleaning to make it usable for the prediction model. It was definitely a challenging but rewarding process to piece it all together.
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
Live football data has always existed. A dashboard that makes it feel this immediate hasn't.
Clutch Lens brings the entire match into one screen: live streaming, real-time scoreboard, possession and shot stats, dual team heatmaps, player leaderboard, and a tactic map that shows exactly how the game is being played, not just who's winning it.
France 0 VS Spain 2. Semi-finals. World Cup 2026. Every number that matters, right where it should be.
Dark. Live. Built for the football obsessed.
Designing a sports analytics platform that needs to feel this considered? Let's build it together.
Tools: Figma
#SportsUI #DashboardDesign #FIFA2026 #WorldCup2026 #UIDesign #DarkUI #ContraFreelance
Amazing design
Built this one for an e-commerce customer behavior project - 18,000+ customers, segmented using RFM (Recency, Frequency, Monetary) analysis.
The interesting part wasn't the segmentation itself, it was what it revealed: nearly 22% of customers were "at risk" of churning, and most businesses wouldn't know that until those customers had already stopped buying.
This is the kind of insight that's usually sitting in your order data already, it just needs the right lens. Happy to take a look at your numbers if you're curious what's hiding in yours.
Tools used: Power BI, SQL, Python (Pandas, Scikit-learn for clustering)
Built a 4-part Power BI dashboard suite analyzing $80M+ in revenue for supply chain & e-commerce data — designed for 4 different stakeholders.
📊 Executive KPI Dashboard (VP of Supply Chain) — Revenue, profit & a 71% revenue drop identified in 2018
🚚 Delivery Performance (Procurement Team) — 54.8% late delivery rate flagged, broken down by shipping class
📦 Product & Warehouse Analysis (Warehouse Ops) — 33K SKUs across 9 warehouses, revenue vs. margin comparison
💳 Customer & Payment Insights (Finance Team) — Sentiment, review scores & payment method breakdown
Tools: Tableau, SQL, Excel, Python
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?