Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
01-31-2018 20:59 PM - last edited 10-22-2018 02:35 AM
A year in review - oh how we danced!
This report looks at the daily top 200 songs treamed on Spotify, over almost 60 countries that Spotify thinks is worthy of including in their charts. We focus on the top streamed songs and the heaviest hitting artists, telling a story with fun visuals.
All streaming data is scraped from :
https://spotifycharts.com/regional/global/daily/latest
Features of each song were pulled from the Spotify API:
https://developer.spotify.com/web-api/
Additionally, we have some fun indexes:
The Heat index!
Looks at the daily average temperature, as reporteded by
ftp://ftp.ncdc.noaa.gov/pub/data/ghcn/daily/by_year/
The Wage index!
The average wage index of a songs streamers by country, OECD data available from data.world
DataWorld.Dataset("oecd", "wage-levels")
Scraped Data:
https://www.dropbox.com/s/t6lhg4tfrxshxlx/Data.zip?dl=0
Attached PBIX has disabled some data load to model for space saving.
eyJrIjoiMzJmMDgwYjEtYTAwNy00YWYxLTgzYTEtMzBkYzk0M2MzZGU3IiwidCI6IjhmNzlmMTgzLWU3YjUtNDUwOS1hMmY0LTg1Y2I1MDIyMDllMCIsImMiOjN9
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on