Add Track Name next to Track URL on Rows.Add SUM(Streams) to Columns and Track URL to Rows. Now that we’ve seen the most popular artists, let’s do the same with songs. Now we can see that Drake consistently has a lot of tracks in the Top 200 and these tracks get a lot of stream time. Since we’re showing the relationship between two variables, let’s see this in a scatterplot view instead.But remember, just because an artist has the most tracks in the list doesn’t mean they have the most streams. Sort from greatest to least to see the artist with the most tracks in the data set. We quickly see that there are over 50,000 tracks within the data set. Note that we’ll be using the Track URL field as a unique identifier when we’re doing distinct counts of tracks since some songs may be named the same thing. Let’s start by analyzing the most popular tracks in Spotify’s Top 200 list. Drag the Spotify_Daily_Streaming CSV onto the Canvas.In the Connect pane, select “ Text file” and open the Spotify CSV we just downloaded. Note: I performed this for all available countries and dates prior to July 1st, 2019 and combined the csv’s into one file called Spotify_Daily_Streaming. Click “Download to CSV” in the top right-hand corner.For the purpose of this analysis, we will choose Daily and use the date dropdown to select the most recent date. You can also choose to select Daily or Weekly data. For this analysis, we’re going to focus on Global data so we can see listening habits by country. Use the dropdowns to filter by your specific country or select Global to see all country data.For this analysis, we will choose Top 200. Select Top 200 or Viral 50 depending on the purpose of your analysis-to see top tracks or trending tracks.Navigate to to download data from Spotify’s Top Charts.Reference Materials Toggle sub-navigationįollow these steps to learn how to get the latest data from Spotify’s charts and bring it into Tableau for analysis.Teams and Organizations Toggle sub-navigation.Plans and Pricing Toggle sub-navigation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |