Spotify Wrapper

With this project, I didn't want to create a crisp report, but I wanted to reflect a feeling of discovery, which is music (and spotify) to me. At first sight, a dj mixer is overwhelming, but once you get the hang of it, it's an amazing tool. I tried to keep that feeling in the report.

• Important data preparation:
  • Added an additional column with unique track+artist id's as tracknames are used by multiple artists. Did the same for the album.
  • Did not use the skipped column as it seems the definition changed in october '22 (example: reason end: fwdbtn is considered as skipped, before this date it is not)
  • Created a column with an URL to the track
  • Modeled the data
• Main indicators:
  • Artist, song, distinct song trend (by year and month)
  • TopN artist, song, album
  • Number of days listened to Spotify
  • Listening time (in Minutes, Hours or Days)
  • Used device / platform
  • Day and Time of day of listening
  • Number of Songs that I played (1, 2, 3,..., x)-times
• Visualization:
  • Created an ON/OFF effect for the dj mixer
  • I used a lot field parameters
  • 12 bookmarks were created on the dj mixer page (and we all love configuring them, don't we?). Some are triggered by buttons that are on top of a (dummy) slicer to keep the visual effect of my other tile slicers
  • The equalizer was created with a deneb visual
  • Foresaw the option to customize the look and feel by adapting the color of the slicers
  • Added a "help" page that comes on top of the mixer
  • For the top N songs (top N can be chosen) , a link to the spotify track was added using an svg
  • Added dynamic titles