Hey Tableau fans, get ready to be Grossed Out!
The Jett Black Experiment is still in its first year. This article describes one of the methods I am using to help Jett learn about math and data analytics. If you are interested in following this experiment, you can watch Jett on his YouTube channel.
When you combine a childhood passion (Grossery Gang – Figure 1) with adult passions (Tableau and Alteryx), a huge amount of learning, good times, and excitement can totally erupt! If you don’t believe me, just read this article!
Jett and I built an Excel worksheet (Figure 2) to hold the Grossery Gang (GG) collection information. With this being season number 1, I have a feeling that this database is going to expand a lot over the next few years!
The Tableau Dashboard
Jett helped me build an interactive dashboard (Figure 3). This dashboard allows him to see the following:
- Which characters he owns
- Which characters he doesn’t own
- Which characters are duplicates and how many duplicates he has
- How many unique characters he owns
- How many characters he still needs to collect
Of course, the dashboard allows him to filter by:
- Collection Category
- Whether he owns the characters or not
- Whether characters are duplicates or not
Additionally, the matrix can be configured to any number of columns through a parameter setting.
The Growing Collection
At this point, all Jett is focused on is collecting more, more, and more GG’s (Figure 4a, 4b). What he doesn’t realize is that these little dudes are expensive!
The makers of this collection (Moose Toys) are ingenious because these rubbery little things probably cost less than $0.05 to make and they generally sell for $1 to $1.50 each. The price can go as high as $10 apiece, if you buy the limited editions packaged with another toy. Yikes, I wish I had thought of this idea (or Shopkins, or any of the other series they make).
To earn money to buy these toys, Jett has to be a good boy and he has to do some household chores. It is amazing how motivated a 4-year old can be when he wants something! So on certain Saturday mornings, if he has been good during the week and has done his work, we visit Toy’s R Us or Target to see which packages contain the right characters to help Jett grow his collection. During the week, he plays with these all the time.
The Value of This Work
Now that we have our dashboard built, we will bring his tablet (Figure 5) to the store with us to make sure we are optimizing our purchases. The funny this is this: Jett has this database memorized. He knows exactly what he owns and what he needs. This is truly amazing to me.
For me, this work is a labor of love and has helped Jett to count to higher numbers, categorize, recognize characters (Video 1) and to identify their collection number. He already has asked me to define every term used to name the characters.
His vocabulary has exploded with words like Tasteless, Putrid, Horrid, Disgusting, Chunky, Dodgey, etc. Jett can tell me with 100% accuracy the name of every character and which category they come from. He has not nailed-down the rarity yet, but I’m sure that will be coming soon.
Update 8/13/16 – Well, soon came sooner than I expected (2 weeks). Jett definitely knows the rarity assignments. If you want to see how I know this, watch this video of him!
The Amazing Cookie SwirlC
For a professional view of the Grossery Gang appeal, watch this video that was produced by Cookie SwirlC.
This gal is a marketing machine with amazing vocal skills and charisma. Her voice can be mesmerizing and kids can watch her silly videos all day. With over nearly 3 million subscribers and over 3.3 billion video views since her humble beginning on YouTube in 2013, I guess she has figured out the secret formula for selling these items! Thanks for reading!