Day three of dashboard week had us gathering data from the National Electronic Injury Surveillance System (NEISS) and using it to create a dashboard in tableau. This task also required a bit of data preparation and cleaning in Alteryx to build relationships between the tables.
Prepping the Data
After exploring the data, I came to the conclusion that I wanted to explore injuries that occurred under the influence of alcohol. Once I dug further, I discovered a narrative column that would often include the blood alcohol content (BAC) details, so i used a RegEx tool to extract BAC and BAL values and grouped them to drive the narrative of my story. From there I just needed to merge all of the injury classification codes such as Location, Diagnosis and Product with the main dataset.
Dashboarding
The goal of the dashboard was to analyze injuries where alcohol was involved, with a focus on BAC levels. I wanted to explore whether higher BAC increased the number of injuries and identify which types of injuries was most common at each level of intoxication. To accomplish this, I created two KPI’s that looked at total injuries and hospitalisations, along with three bar graphs to assess the most common injury types, causes and affected age groups, and a line chart to analyze trends in injury numbers over time. I also created a viz in tooltip to show which body parts are most affected by certain injuries. The dashboard can be found Here.
Main Insights
- Most common types of injuries are internal injuries, lacerations and fractures
- Males account for two thirds of total injuries
- There has been a 35k spike in total injuries in 2024. Seeing more injuries for age groups 17 and under, 30-39 and 70-79
- Poisoning has doubled since 2019
- Main injury types for high BAC levels are internal injuries and lacerations to the head. Typically falls from stairs.
- Low BAC levels see fractures as the main injury type to the upper body (Collarbone, shoulder blade etc.). As well as high levels of poisoning
