Welcome to Spotify Wrapped 2024, a personalized dashboard created to showcase my listening habits, trends, and behaviors throughout the year. This project reflects the unique relationship between my work productivity and music preferences, uncovering insightful and amusing patterns.
Spotify Wrapped 2024 Dashboard
The goal of this project was to craft a personalized 2024 Spotify Wrapped, built entirely from my own listening data. By analyzing trends and preferences, this dashboard provides a deeper understanding of how my music choices align with my work habits and overall year.
- Analyze Listening Trends: Understand how my playtime correlates with significant events like starting a new job.
- Showcase Favorites: Highlight my most and least favorite songs and artists of the year.
- Reveal Platform Preferences: Explore my dominant platforms (spoiler: Windows reigns supreme).
- Create a Storytelling Dashboard: Use Spotify's color palette to design an interactive and visually appealing report.
The data used in this project was directly exported from my personal Spotify account. This involved:
- Exporting JSON Files: Retrieving my listening data from Spotify.
- Data Transformation: Converting JSON to CSV, standardizing platform details, and filling missing values with defaults using both Python and Power Query.
- Final Input: Feeding the cleaned and transformed data into Power BI Report part for analysis and visualization.
This dashboard was built in Power BI, leveraging Spotify's brand colors for a consistent and engaging design. Here's how the project unfolded:
-
Data Preparation:
- Focused on 2024 listening data only, ensuring relevance to the wrapped theme.
- Standardized platform details and filled missing data.
-
Key Insights Analysis:
- Playtime Trends:
Listening resumed in April 2024 after a break, coinciding with starting my new job. I realized I primarily listen while working, explaining the inactivity in January to March. - Monthly Playtime:
Analyzed monthly averages (~21 hours/month) and identified August 2024 as the peak month with 46 hours.
- Playtime Trends:
-
Music Insights:
- Favorite Artist: LXNGVX, with "Montagem Mysterious Game" as the top song.
- Most Skipped Song: Cry Me A River (which deserved a second chance 😅).
-
Platform Preferences:
Windows usage dominated over macOS and Android, reinforcing my music-at-work habit.
Explore the interactive dashboard for a visual breakdown of the insights:
-
Monthly Playtime Trends: See how listening patterns evolved over the year.
-
Top Songs and Artists: Discover my most loved and most skipped tracks.
-
Platform Preferences: A clear picture of my platform usage.
Overall, Spotify Wrapped 2024 captures a year of productive listening with a total of 250 hours of playtime, far exceeding the average user’s annual 61.5 hours. It tells a story of how music intertwined with my work habits, revealing my top tracks, artists, and platforms.
Future improvements could include incorporating data from other years to identify long-term trends and analyzing the impact of external events (e.g., vacations, job changes) on listening habits.
For questions, collaborations, or feedback, feel free to reach out! Connect with me on LinkedIn or check out more of my projects on GitHub.
A big thank you to Spotify for providing the data export option and to Maven Analytics for hosting the challenge that inspired this project.
Thank you for exploring my project, and I hope it resonates with you as much as it does with me!
