Our third day of Dashboard Week required us to connect to Music & Mental Health data on Kaggle to make a dashboard to show a story we found.

The first thing that jumped out as me was all the different music genres in the data so I decided to focus my analysis on how the different music genres affect mental health.

 

In Alteryx

The data was quite clean, though the main change I made was to take all of the different genre frequency columns and transpose the data so there was a row per respondent and genre. The other processing included creating a row ID and coding the Likert scale values numerically.

 

In Tableau

I began by exploring relationships with age, number of hours listening to music and other factors not related to the music. I didn’t find much of interest so I decided to look at the frequencies that different respondents listened to different genres, and also look at how their favourite genre was related to how they felt that music affected their mental health conditions. I then wanted to see if different initial mental health conditions seemed correlated with whether they felt that music affected their mental health conditions and found a great trend there. I tried a few other things but ended up wanting to look at how the average age and number of different genres listened to varied with the respondents’ different favourite genres. I hope you enjoy the result!

 

 

Dashboard Week Day 4 – Music & Mental Health

Hunter Iceton
Author: Hunter Iceton

Hunter Iceton is an enthusiastic and positive individual. He graduated from Sydney Uni in 2017 with a Bachelor of Commerce (Liberal Studies) majoring in Finance, Marketing and Quantitative Business Analytics. For the next few years, Hunter spent his time creating and releasing music, while tutoring primary and high school students in Mathematics and Business Studies. Hunter is now excited to be joining The Data School, looking forward to approaching analytics with a creative perspective. In his spare time, Hunter enjoys continuing to create music, reading philosophy and cooking plant-based dishes. Otherwise, he can usually be found at a restaurant, a bar or an art gallery.