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

Registration:

https://us06web.zoom.us/meeting/register/5uKNGNndSy2lJjDCuf2mbw

August 6, 2026 (10:00AM-11:30AM CST)

Brief Course Summary: 

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.