Analyzing Spotify’s Most Streamed Songs of 2024
personal project
About Spotify
Spotify is a digital music streaming service that offers access to millions of songs, podcasts, and videos. Spotify boasts a library of over 70 million songs from a diverse range of record labels and media companies. Spotify also has a large number of playlists created by users and the Spotify algorithm.
methodology
Cleaned and transformed raw streaming data in MySQL by standardizing formats, removing duplicates, converting data types, and creating a staging table to isolate and analyze Spotify-specific metrics for 2024’s most streamed songs.
Analyzed artist performance, track popularity, playlist metrics, and temporal trends to uncover insights on music release strategies, streaming behavior, and content patterns using advanced SQL queries.
© 2025 Rilloraza