Building Automated Crash Dashboards: Leveraging Excel, Power Query, and AI to Automate Reporting and Create Decision-Ready Dashboards

• Thursday, August 6th, 2026 @ 1000 Central Time via Zoom
• FREE
• Register here
  
• Contact Daniel A. Howard, IADLEST, Project Manager [email protected] for more info

Crash analysts often spend hours cleaning data, updating spreadsheets, recreating charts, and rebuilding reports, time that could be spent identifying trends and supporting traffic safety initiatives. This webinar introduces a practical approach to automating crash reporting by combining Excel, Power Query, and artificial intelligence (AI).

Participants will explore strategies for structuring crash data, automating data preparation, creating dashboards that answer operational and strategic questions, and using AI to accelerate analysis and communicate insights. Participants will leave with practical techniques they can apply immediately to improve efficiency, consistency, and decision-making within their agency.

The learning objectives for this webinar include:

• Design an automated crash reporting workflow that improves data preparation, reporting efficiency, and consistency.
• Develop interactive crash dashboards using Excel and Power Query to transform data into actionable information for operational and strategic decision-making.
• Apply artificial intelligence (AI) tools to enhance crash analysis by identifying trends, summarizing findings, and communicating insights to agency leadership.