The Truck Safety Coalition (TSC) has a national network of volunteers dedicated to providing compassionate, immediate support to survivors and families of victims of truck crashes. TSC also advocates for policy changes to prevent future deaths.
TSC routinely used data in their advocacy activities, but accessing the data was time consuming. The data lived in siloed tables or PDFs hosted on the Department of Transportation (DOT) website, making it difficult to analyze and time consuming to visualize. Customized reports had to be developed for different policy makers and stakeholders.
Excellians Amanda Makulec, Marc Frankel, John Carr and Michael Bass worked together with TSC to create an interactive dashboard TSC could use during meetings to create quick, custom reports for each policy maker. The dashboard was designed to be embedded on the TSC website for wider visibility. To achieve the TSC’s goals, the development process focused on identifying the key use cases and audiences with our TSC partners, developing an MVP for early feedback, and delivering a final product that can be refined and continuously improved by the TSC team.
The final dashboard is available on Tableau Public: https://public.tableau.com/profile/amanda.makulec#!/vizhome/FatalLargeTruckCrashesinAmerica/Overview
The TSC dashboard showcases how legacy reports and PDFs can be transformed into engaging, interactive, data-driven tools with a user-centered design process.
Illustrative applications of this approach could include:
If you’d like to find more detailed information regarding implementation details and the design of this project, check out these two blog posts and a video testimonial: