Intern Dashboards: Spotify Insights on World Music

Data

Intern Dashboards: Spotify Insights on World Music

by Sripriya Vemula
//

Being an avid music lover, I always wondered about various factors that make up an entire song. This project provided me an opportunity to do so. I stumbled upon an amazing data source in Kaggle that had authentic Spotify data with a lot of key features for each song scraped using Spotify’s API. Once I obtained the dataset, I sanitized the data (eliminated tracks that brought in characters beyond the ASCII range), created some calculated fields to better understand insights and starting building my dashboards.

My Tableau story consists of three dashboards:

The first dashboard shows some basic stats that provide an overall flavor of the dataset used for this purpose. Feel free to choose your artist of choice and click on the song to play some music while looking through!

(Key assumption: If a song has mutliple artists, only the primary artist has been given ownership . For example, “Perfect” has both Ed Sheeran and Beyonce, but in this analysis, the song will only appear under Ed Sheeran’s list of tracks.)

The second dashboard digs a bit deeper into each genre to see the spread of different attributes such as temp, valence etc. of the Top 50 songs within each genre. Note that in some genres, you will be able to see a lot more than 50 data points. This is because Spotify usually rates songs with a popularity score between 0-100 and if more than one song have the same score, they have been ranked the same in this analysis to give an accurate analysis. 

The last dashboard aims to see if popularity changes because of two key factors of any song: whether it has explicit content or not and the mode in which the track has been composed. 

KeepWatch by InterWorks

Whether you need support for one platform or many, our technical experts have you covered.

More About the Author

Sripriya Vemula

BI Intern
How to Use MIN_BY / MAX_BY in Snowflake If you are familiar with SQL, you would be familiar with the concept of aggregate functions. For those who are still a bit fuzzy on ...
The Latest With Tableau Pulse: Make It Work for You! If you attended the latest Tableau Conference earlier this spring, or if you’ve spent any time considering the feasibility of a ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!