At this point, we were half-way through the Dashboard week, and so far, pretty good. For the third day, we were using NEISS, a U.S database that collect data on injuries treated in emergency departments, especially those related to consumer products.
Getting Started:
Similar to the second day, we were not required to call on API or web scraping, we simply downloaded straight from their website. We did have the option to look at a subset of products, age group, years, etc.
For the most part, the dataset is encoded, with numbers are used to represent a string value. These type of dataset are often accommodated with data dictionary for ease of use .
In this challenge, I decided to take a slightly different approach. For the previous two days, I often took a quick look at the data and quickly decided which subset to focus on. This allowed me to have enough time to analysis and formatting. On the third day, however, I wanted to shake things up a little bit.
Down To Business with Alteryx
The dataset itself is not exactly clean, but very usable. As I mentioned before, the dataset contains column with encoded values, hence I used Alteryx to perform some basic transformation and cleaning to get desired result. Since I did not have an anchor point this time around, I ended up spent time more time than I need to ‘extract’ a meaningful story. The original idea was to do a little bit of rabbit-hole digging, then hopefully I would get something interesting to start off.
After spending decent amount of time digging for something interesting in Tableau, I finally decided to focus the narrative on injuries related to trampoline. More specifically, it would be any injuries related to tripping, slipping, flipping and falling.
Start Building
I recalled on one of the session with the Data school Coach, in which she showed me a chart type that I really want to take advantage of for this case. However, I need to find a way to do it quickly, cause I was running out of time. The good news was, I got it. Here is the result.
In case you want to know how I do it, here is the website: https://cbistudio.interworks.com/#. Lisa Trescott, a well-known in the Tableau community, published a blog which I used to create this Dashboard, here is her blog : https://lisatrescott.com/2025/02/18/tutorial-custom-coordinates/
Final Thought
I must admitted, this is not the best approach if I want to finish everything by 6pm latest. I cost me way more time than I want to spend on, which for the most part, not really worth it since I may suffer from burn out.
