Concussion Explorer
What sports cause the most brain injuries in children and teenagers? Explore which athlete’s sustain the highest number of concussions along with trends and seasonality patterns.
Visualizing concussion injuries has been done before. However I wanted to condense the story and try different chart types within the assignment constraints.
View Project →
Tools
Excel
R
Tableau
My Role
Data Prep
Design
Development
Data
1.18 MM observations, 22 variables (filtered by age and years)
Type
Interactive Dashboard
My Process
The Challenge
Use Tableau and create two interactive dashboards with at least 3 chart types and 4 calculations.
The Design
The first story point gives an overview. You can see the distribution of concussions by age and gender. This chart filters the count list and seasonality trend chart below it, allowing you to compare concussions by sport. You can also change the age range and gender, or select a bar to further investigate and drill into the data.
The second story point shows changes across time. I created two new measures to calculate the count at 2009 and 2014 and plotted the values on a slope graph by sport. The delta, another calculated field, determined the line color. The greater the change, the more saturated the color, with red indicating an increase, and blue a decrease. Selecting rows in the heat map filters the slope graph.
The Result
An interactive data experience that allows you to investigate and compare brain injuries in sports in kids and teenagers.