Analysis on Spotify's Top Songs in 2023

Welcome to My Project where I've analyzed Spotify's Top Tracks Using SQL, Hope You Like It! 

The Dataset can be found in Kaggle 

The dataset contains a comprehensive list of the most famous songs of 2023 as listed on Spotify. The dataset offers a wealth of features beyond what is typically available in similar datasets. It provides insights into each song's attributes, popularity, and presence on various music platforms. The dataset includes information such as track name, artist(s) name, release date, Spotify playlists and charts, streaming statistics, Apple Music presence, Deezer presence, Shazam charts, and various audio features. 

(Link : https://www.kaggle.com/datasets/nelgiriyewithana/top-spotify-songs-2023/data)

OVERVIEW OF THE DATA:

Artists with Most Songs in the List along with their Rank

Top 5 Streamed Songs in 2023

Top 5 Streamed Songs with Multiple Artists(Collaborations)

All Distinct Artists Sorted Alphabetically

How Many Top Songs are in more than 500 Spotify Playlists and have more than one artist?

How Many Songs are made by a single artist and have surpassed 1 billion streams?

How Many Songs are made by multiple artists and have surpassed 1 billion streams?

Top 5 Songs that have the word 'love' in them

Grouping Songs into Quartiles to determine Most and Least Popular Songs

Running Total Amount of Streams for Taylor Swift

Determining Grooviness of All Songs (based on danceability)

Most Streamed Song for all distinct artists in the list

Artists with most songs in the Top Songs List

What Percentage of Songs in the List were actually released in 2023?

Taylor Swift's Top Songs (by streams)

Artists with Most Songs Surpassing 100 Million Streams

Top Songs Released in 2023 (by Streams)

Most Energetic Songs

Tracks which charted the Most on Apple Charts

Tracks which appeared in Most Spotify Playlists

Songs which appeared the Most on Spotify Charts

Hope You Enjoyed My Analysis, Feel free to check out My Other Projects, Thank You!