#WOW2022 | Week 01 | Let’s visualize wildlife strikes


Happy New Year!  We’re so excited to be kicking off our 6th year of #WorkoutWednesday! If you are new to this project, you’ll be challenged with different technical each week. We strive for our challenges to be aimed at the intermediate level Tableau analyst ready to take their development to the next level. Whether you’ve been with us 6 hours or 6 years, we’re excited you’re here! Let’s get to work.

To get the year started off right, we going to focus on dashboard layout and providing context for our users.

One of my most FAVORITE datasets I’ve ever come across is the FAA Wildlife Strikes database. Yes, every aircraft operator is required, by the FAA, report any and all incidents where wildlife comes in to contact with an aircraft! And..they’ve been maintaining this database since 1990!

Something that we need to be considering when we develop a dashboard is how the dashboard will be consumed. As much we would like all interactions to happen in the browser, a lot of our dashboards will be screenshot and pasted into an email or powerpoint. So with that information let’s build an interactive dashboard that provides context to what has been clicked on


  • Dashboard Size: 1200px by 900 px
  • # of Sheets – up to you
  • Create a bar chart that shows the top 10 species types and aggregates all others
  • Create a US state map by total incidents
    • You will need to bring in a special shape file to deal with Alaska and Hawaii. Check out this forum post by Sarah Battersby for the file
    • Make sure to figure out how to display the null or unknown locations
  • Create an area chart by year
  • Interactivity
    • Clicking on a state or species type will filter the dashboard
    • The same click(s) will also update the titles for the bar and area charts. The titles return to normalize when clearing selections


This week uses a cleaned version of the FAA Wildlife Strike database. You can get it here at data.world


When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2022 in your description to make it searchable!


After you finish your workout, share on Twitter using the hashtag #WOW2022 and tag @LukeStanke, @_Lorna_Brown, @HipsterVizNinja, @_hughej, and @YetterDataViz



Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top