MohWaliG/Abuja-Traffic-Volume-Analysis

Traffic Volume Survey & Violation Rate Analysis across GSM Village, Jumuah Mosque & Keystone Bank Junctions in Abuja, Nigeria. Built with Excel, Power Query & Pivot Tables. # 🚦 Traffic Volume Survey & Violation Rate Analysis ### Abuja Urban Corridor Study — GSM Village, Jumuah Mosque & Keystone Bank Junctions **Prepared by:** Mohammed Wali Galkaye Friday, ‎April ‎3, ‎2026, ‏‎12:40:03 PM **Tools:** Microsoft Excel · Power Query · Pivot Tables · DAX --- ## 📌 Project Overview This project transforms raw traffic count data into decision-ready intelligence for urban transport planning and road safety enforcement in Abuja, Nigeria. The analysis covers **447,652 vehicle movements** across three major junctions over seven consecutive survey days, examining traffic volume, vehicle type distribution, violation rates, peak periods, and directional flow. The dataset was collected at 15-minute intervals from **5:46 AM to 7:15 PM**, capturing both volume counts and violation incidents across **nine vehicle types** at each junction. --- ## 🗺️ Study Area | Junction | Total Volume | Violation Rate | |---|---|---| | GSM Village Junction | 186,645 | 50.26% ⚠️ | | Keystone Bank Junction | 144,980 | 45.05% | | Jumuah Mosque Junction | 116,027 | 32.31% ✅ | --- ## 📊 Key Findings | Metric | Value | |---|---| | Total Traffic Count | 447,652 | | Total Volume (excl. violations) | 311,864 | | Total Violations | 135,788 | | **Overall Violation Rate** | **43.54%** | | Average Daily Volume | 44,552 | | Dominant Vehicle Type | Okada (36.3%) | | Morning Peak | 7–8 AM (45,115 vehicles) | | Evening Peak | 5–6 PM (44,872 vehicles) | | Commercial Vehicle Share | 83.4% | > **Nearly 1 in 2 trips on these corridors involves a traffic infraction** — a systemic compliance crisis, not an isolated enforcement problem. --- ## 🚗 Vehicle Type Distribution Okada and Keke combined account for **48.5% of all traffic** — a distress signal indicating a critical gap in formal public transport provision in the FCT. --- ## 🔍 Analytical Approach - **Data Cleaning** in Excel and Power Query: validated structure, confirmed consistent formats across all three junctions, and c …