Analytics

Road Safety Analytics Dashboard - Tableau (Collisions & KPIs)

Tableau Developer / BI & Data Visualization Specialist

Business summary
Operations automation • Turn raw data into executive-ready reporting
  • Eliminated repetitive manual steps across the workflow
  • Faster response time and fewer missed handoffs
  • Error handling and edge-case coverage to reduce operational risk

What I built

Designed a multi-layer BI dashboard analysing UK road-collision data in Tableau, built for executive, operations and analyst audiences. The executive view tracks KPIs - total collisions, casualties, fatal & serious counts and fatal/serious rate - with monthly severity trends. Operations dashboards rank police-force areas, map geo hotspots, and break collisions down by time, weather, road surface and speed. Analytical pages add statistical models (T-Test, Chi-Square, ANOVA), scatter/regression, box plots, treemaps and heatmaps with filters - turning data into decision-ready insight.

Tech stack

TableauData VisualizationBI DashboardsStatistical AnalysisKPI ReportingT-TestChi-SquareANOVAGeospatial MappingHeatmapsCalculated FieldsInteractive FiltersAnalytics