On the final day of the Tableau Dashboard week, we were given a data set from Kaggle and asked to explore the impact of music on mental health. The link to the data set is https://www.kaggle.com/code/udokaa/music-and-mental-health-analysis.
Introduction: Data cleaning/preparation using Alteryx
The file was relatively smaller than the previous dashboard challenges. I used Alteryx to make sure the data was cleaned and prepared for analysis. The age groups were created for analysis of music consumption by age, the data table was rearranged to analyse the data by the different music categories, and the final file was created to prepare dashboards in Tableau.
Visualisation using Tableau
Next, I created two dashboards. The first dashboard focused on how the different trends in music consumption, the number of hours spent listening to music per day, favourite music genre, and music streaming services by the different age groups. Some interesting insights gained from the dashboard include the age group 10-19 spend the most time listening to music at an average of 6.5 hours per day, and this age group also love to explore new artist and genres of music. Other interesting insights include: rock and roll and POP music are the most popular music genres in all age groups, and Spotify is the number one music streaming service in the age groups from 10 to 49.
Next, I analysed the impact of mental health in each age group, which was based on the responder’s score of their mental health based on a scale of 0 to 10 and how music affects their mental health. To conclude, the key insight from this dataset is that in all age groups, music does have a significant impact on improving mental health in all age groups.
And there you go, proof that music is not only good for your soul but also for your mental health!.