The Grammys are you set to air on Sunday, Feb. 12 on CBS. I’ve always enjoyed watching the award show. I used to watch every year when I was a young’en. Now life is busier and news is easier to acquire, so I haven’t sat and watched in several years now. But that hasn’t stopped me from paying attention.

Now that I have some Tableau chops, I wanted to a way to quickly and easily learn and discover some new music from the nominees. And that’s what I’ve done.

Below are screenshots, click here for the interactive version

grammy1grammy2

It’s a well known fact, in the data industry that the majority of time spent on a data visualization is spent on wrangling the data. This project is NO exception. I spent no less than 20 hours just compiling the data for this.

The first step was to gather all the nominees. Wikipedia makes that fairly simple. Simple cut and paste into excel and then do a little of formatting and you’ve got yourself a nice clean dataset.

The next part was that because this was a music viz, I knew I wanted to incorporate music somehow. I’ve also seen several examples of other vizzes that incorporated Spotify embedding links. So it was decided, it was done. I was dead set on gathering embed links for all the nominees. Easy peezy, right? Well, kinda.

Though not really. Because its not as simple as using the text string of [nominee]+[song or album]. No, each song and album have their own unique link made of random characters. Spotify makes it really easy to grab the embed code as a option in the context menu of any selection. So it turned into the task of going through each and every single row (426) and grabbing that link.

I will say, Spotify is pretty amazing and the depth and breadth of music is never ending. Interestingly 90% of all 2017 Grammy Nominations are on Spotify. Beyonce, obviously, is not. She’s on Tidal with her hubby, Jay-Z. So her plus a few others had to be YouTube links.

So apart from being able to discover and listen to some of the lesser known categories, what I enjoyed the most was creating the playlists for Producer of the Year, Non-Classical. These nominees produced some of the more well known songs of the past year. Combined they produced 35 songs. So now you can listen for trends across songs & artists from the same producer.

From one viz, come the next idea. Looks like I’m going to be working the history of the Grammy awards…

Until next time!

If you’d like to have a look at the raw data, click here

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s