Welcome back to my blog series for Dashboard Week! This week we are tasked each day to produce a dashboard and blog as well as other deliverables such as a documented data prep workflow and wireframes. Today’s task was a bumpy road!
At first we were tasked with connecting to an API for https://genius.com/ (a website where you can read about the meanings of songs by your favorite artists. I chose to analyze songs by the Eagles as they are one of my favorite bands!
Connecting to the API
The morning started with reading through these API instructions for Genious.com: https://docs.genius.com/#/getting-started-h1. I registered my application through the API client management page and received my access token.
I then went to Alteryx, created my text input, and downloaded data from https://api.genius.com/search using my access token. As my cohort and I sifted through the data, we all failed to cache our workflow… therefore after 3 hours of work, we reached our call limit and we were temporarily banned from Genious.com for a month (whoops).
Change of Plans
Due to this crisis were instead given a data set of song lyrics from kaggle.com (https://www.kaggle.com/datasets/deepshah16/song-lyrics-dataset). I chose to analyze Ed Sheeran’s lyrics through a sentiment analysis.
Alteryx Part 2
I input my data set of Ed Sheeran song lyrics into Alteryx and used the text to columns tool to format my data set for a word cloud. I then exported the data as a Tableau Hyper Data extract file.
Wireframing
After importing the data set into Tableau playing around with charts in Tableau, I moved on to my wireframe. I knew my sentiment analysis would be a bar chart and I also wanted to include a word cloud.
I also started planning the types of containers I would need to have on my dashboard to execute my sketch.
Dashboard
Finally, I connected to TabPy in tableau and used the following formula for my sentiment analysis.
I then noticed the sudden drop in sentiment in 2013 and googled “Ed Sheeran 2013” to try to form a hypothesis as to what could have driven the decrease in sentiment in his lyrics. Pretty quickly I found that 2013 was during the Ed Sheeran and Taylor Swift Era. There were rumors flying that the two were dating, however Taylor Swift was also rumored to be dating Joe Jonas and Harry Styles. Unfortunately, Ed was caught up in love square and this may have resulted in depressing songs during 2013.
