This challenge is organised by ZoomCharts in collaboration with Onyx Data’s DataDNA Challenge.
It is a Power BI Data Analytics Project.
The challenge is to create a visual report on Spotify’s 2023 top songs.
Onyx Data provided the dataset.
Guidelines for participating in the challenge are here:
ZoomCharts
Project
Data cleaning
The Raw file had data of 953 songs.
Data Cleaning steps:
Removed 4 duplicate songs (duplicate contains same name and same artist name). The songs have also identical data for streams, playlist numbers, & chart numbers etc.
I picked the highest numbers of each duplicate song and removed the small numbers data.
The song “Love Grows” at row number 576 (in Excel) had no stream data and low numbers in other data. I chose to ignore this song.
After cleaning the data, 948 songs were left.
Also created a month name column from the month number using DAX.
Dashboard
Statistics:
Total Songs = 948
Total Artist(s) = 644 (includes Solos and Multi Artists per song)
Total Streams = 488Bn
Sound Based Statistics:
All the sound-based statistics are the average % of all the songs.
danceability_% (It indicates how suitable the song is for dancing) = 66.97%
valence_% (Positivity of the song’s musical content) = 51.40%
energy_% (Perceived energy level of the song) = 64.26%
acousticness_% (Amount of acoustic sound in the song) = 27.16%
instrumentalness_% (Amount of instrumental content in the song) = 1.57%
liveness_% (Presence of live performance elements) = 18.17%
speechiness_% (Amount of spoken words in the song) = 10.16%
bpm (Beats per minute, a measure of song tempo) = 122.47
Mode of the song (major or minor):
60.01% of songs were in Major mode.
39.99% of the songs were in Minor mode.
Songs Based Statistics:
Most Streamed Song on Spotify in 2023:
| Song | Artist | Streams | Spotify Playlists |
| Blinding Lights | The Weeknd | 3703895074 | 43899 |
Most Streamed Artist on Spotify in 2023:
| Artist | Solo Songs | Total Streams | Spotify Playlists |
| Taylor Swift | 34 | 14053658300 | 132974 |
The Top 5 Streamed Songs:
| S.No | Songs | Streams |
| 1 | Blinding Lights | 3703895074 |
| 2 | Shape of You | 3562543890 |
| 3 | Someone You Loved | 2887241814 |
| 4 | Dance Monkey | 2864791672 |
| 5 | Sunflower – Spider-Man: Into the Spider-Verse | 2808096550 |
The Least 5 Streamed Songs:
| S.No | Songs | Streams |
| 1 | Overdrive | 14780425 |
| 2 | Gol Bolinha, Gol Quadrado 2 | 11956641 |
| 3 | QUEMA | 11599388 |
| 4 | Jhoome Jo Pathaan | 1365184 |
| 5 | Que Vuelvas | 2762 |
The Top 5 Streamed Artists:
| S.No | Artist(s) | Streams |
| 1 | The Weeknd | 14054897067 |
| 2 | Taylor Swift | 140536583300 |
| 3 | Ed Sheeran | 13908947204 |
| 4 | Harry Styles | 11608645649 |
| 5 | Bad Bunny | 9997799607 |
The Least 5 Streamed Artists:
| S.No | Artist(s) | Streams |
| 1 | Offset, JID | 24975653 |
| 2 | MC Pedrinho, DJ 900 | 11956641 |
| 3 | Sog, Ryan Castro, Peso Pluma | 11599388 |
| 4 | Arijit Singh, Vishal Dadlani, Sukriti Kakar, Shekar Rajivani, Kumaar | 1365184 |
| 5 | Carin Leon, Grupo Frontera | 2762 |
Top 5 Tracks in Spotify Playlists:
| S.No. | Track | Artist(s) | Spotify Playlists |
| 1 | Get Lucky – Radio Edit | Pharrell Williams, Nile Rodgers, Daft Punk | 52898 |
| 2 | Mr. Brightside | The Killers | 51979 |
| 3 | Wake Me Up – Radio Edit | Avicii | 50887 |
| 4 | Smells Like Teen Spirit – Remastered 2021 | Nirvana | 49991 |
| 5 | Take On Me | a-ha | 44927 |
Insights:
- The sound-based stats show that most of the popular songs streamed in 2023 are danceable and full of energy. Users liked cheering music this year.
- Most of the songs were released in January (133) and then in May (128).
- The least number of songs were released in August (45).
- The first of the month is the most common date to release the songs. A total of 94 songs were released on the 1st of the month.
- Most of the songs i.e. 60% of the songs are in Major mode.
Spotify’s brand colours and logos are used in accordance with the guidelines provided by Spotify.
Source: https://developer.spotify.com/documentation/design
Thank You!
Please comment and share this project on LinkedIn with your network if you find this project resourceful.
