In honor of the new Avengers movie, we blogged about our favorite superhero-themed vizzes last week. We loved seeing how people have visualized everything, from the history of Marvel comics to the evolution of “Avengers” covers!
This week, we couldn’t wait to look at the data from opening weekend itself. We were also curious to see how the release stacked up against another big event last weekend, the boxing match between Floyd Mayweather and Manny Pacquiao.
So we went to Google Trends to compare searches for “Avengers,” “Mayweather,” and “Pacquiao.” And since the Kentucky Derby also took place this weekend, we threw that search term in as well! We were a little surprised by what we found:
Interested to explore why the boxing fight was so much more popular than the Avengers? We put all the data in a spreadsheet so you can analyze it yourself. Download it now!
We did a small amount of data cleanup so you can start working with this data right now. But when you download it, you’ll notice the first tab still needs a little formatting help. It has a popularity score for each keyword (this represents its relative search volume). However, it doesn’t actually have a field labeled “popularity score.”
Luckily, this isn’t a problem in Tableau 9.0. With our new auto data prep feature, you can pivot the search term fields when you bring them into Tableau. This allows you to put the popularity scores in a single column: