How to Visualize Your Music Data

1) Acquire Your Streaming Data

1. Open up open.spotify.com in your web browser. 
2. Click on your name in the top right corner and then click on “Account.” 
3. Navigate to the left side of the page and click on “Privacy Settings.” 
4. Scroll down to the section labeled “Download Your Data” and look toward “Account Data.” Make sure to check the box next to “Select Account data.” 
5. (Optional) If you would like to look at your streaming data to date, you can also request your “Extended Streaming Data” by additionally checking the box next to “Select Extended streaming data.” 
6. After checking the applicable boxes, scroll down to the bottom of the page and click “Request Data.” 

You might be asked to verify your data request via your email inbox. After confirming, you should receive your account data from the previous year within the next 7 days. Your Extended Streaming Data may take up to 30 days to get compiled and sent to your inbox.

1.5) (Optional) Convert Milliseconds to Hours

When you download your Spotify data, the time measure they use is milliseconds, written as ms. While converting milliseconds to hours is an optional step, it makes your final viz easier to understand and digest. Feel free to skip down to the next section if you don’t want to translate the time. If you would like to change the units to hours, read below to learn how.

1. The first step will be to combine your streaming history files if you received more than one. You may have more than one depending on how much music you listened to. You will find these files after opening the .zip file that Spotify sent you. 
2. Next, merge however many streaming history files you have into one. I use this site to combine my JSON-type files. 
3. After combining them, you should have one JSON-type file that contains all of your streaming history.
4. Now, you’ll want to convert that combined streaming history file into an Excel or CSV file. Head to this website and scroll down until you see “Step 1,” upload your file, then convert it to an Excel file. 
5. We need to add the “Hours played” column to this new file. Open up the file in whatever spreadsheet editor you use. 
6. Create a new column in your data and label it “Hours played.” 
7. Underneath the title in the next row, input a formula that converts milliseconds (taken from the “msPlayed” column) to hours. This will be the quantity under “msPlayed” multiplied by 0.000000277778. My formula looked like “=E2*0.000000277778,” where E2 is the first value in the “msPlayed” column. 
8. Select the first box with the formula in it and press command+D if you have a Mac or Ctrl+D if you have a Windows computer. This will apply the formula to the entire column. If using sheets, drag the yellow circle all the way down the entire column to apply the formula.
9. Finally, we’ll convert our file with the “Hours played” column back into a JSON file to make it compatible with the rest of the original files. You can do so by uploading your new file to this website and converting it to a JSON file. 

This new JSON file will replace the “Streaming History File” referred to in the instructions below. The “Hours played” column and measure will replace any measures related to milliseconds or “msPlayed” in the instructions.

2) Load Your Data into Tableau

1. Open up the .zip file that Spotify sent you. Your data should open in a folder titled “My Data.” Depending on how long your streaming history is, there might be multiple Streaming History files which will need to be put in a union later on. 
2. For now, open up Tableau and, in the Connect Pane, click “JSON file.” Open up your streaming history file (if you have more than one, click on the first). 
3. Ensure all of the schema levels are selected and click OK. You should see the file in the canvas. You should see on the left side of the program, under “Files,” other JSON files within the MyData folder. If you have additional streaming history files, we will need to make a union with the additional streaming history files. 
4. Drag and drop the second streaming history file underneath the primary file on the canvas so that it highlights and shows “union.” A union has now been created between the two streaming history files. 
5. Ensure that the schema is entirely selected by clicking the arrow next to the file name and selecting “Select schema level.” Make sure everything is checked.
6. Repeat step 4 until all of your streaming history files are incorporated.
7. Now, we’ll incorporate a different file titled “Playlist1.” Hover over “data” in the menu and click “New Data Source.” Alternatively, click on the Tableau logo in the top left. 
8. In the Connect pane, click “JSON file” to then open the “Playlist1” file. 
9. Ensure all of the schema levels are selected and click OK. 

At this point in time, both data files have been successfully uploaded and we can start exploring our data!

Creating a union in Tableau 2022.2.2

3) Explore Your Data in Tableau

Switch over to Sheet 1 in the sheets tab on the bottom and start making different visuals! We’ll walk through some useful features in Tableau and how to make a sheet for your most played artists, then hand over the reins for you to draw your own insights.

Making Groups

To highlight specific metrics on our charts and graphs, we’ll need to learn how to make groups. Just select all of the values you want to be included in a group then right-click on the metric and select “Group.” It should have a paperclip icon. You can rename the group by right clicking on its name in the legend on the right and select “Edit Alias…” Now that the group is created, you can go to the Color mark and select your color preference.

Select points to make a group and rename them to make your worksheet easier to understand in the legend.

Using Tooltips

Tooltips are created automatically in Tableau but you can also edit them to say exactly what you want it to say! You can change labels or wording to make it easier to understand by clicking on the Tooltip square in the Marks pane. This will open up a text editor where you can add and edit text describing points on your worksheet. Texts in a gray box are drawing statistics directly from the sheet mentioned.

Make changes to tooltips by selecting the tooltip card and editing within the text box.

Making Worksheets

1. Rename the worksheet by right-clicking the tab on the bottom and click rename.
2. Drag the “Artist Name” dimension to the Rows shelf.
3. Drag the “Ms Played per Document” (or “Hours Played”) measure to the Columns shelf. Confirm that this appears as the Sum of Ms played by looking at the green pill. It should read SUM(Ms Played per Document).
4. Reorganize the graph to sort descending in the toolbar.
5. Apply any filters you would like by going to the Analysis menu, hovering over filters, and then filtering either axis (Ms preferred).

6. Follow the same process as above to make the following suggested charts or make your own to explore any questions you might have of your own data! Feel free to rename any labels or values on the charts to make the data easier to understand.

Follow the same process as above to make the following suggested charts or make your own to explore any questions you might have of your own data! Feel free to rename any labels or values on the charts to make the data easier to understand.

Recommended Charts

1) Acquire Your Streaming Data

1. Head on over to privacy.apple.com in your web browser and sign in with the Apple ID you use for Apple Music. 
2. Complete any authentication required to sign in and then click “Request a copy of your data.” 
3. Check the box to the right of “Apple Media Services Information.” This will give you access to a few different types of data, including your music data. 
4. Scroll down to the “Continue” button and you’ll be directed to a page where you can pick the maximum file size you’d like a single file to be. The larger the maximum file size, the less divided your data will be. 
5. Click “Complete Request” and you will receive a confirmation email saying that you will receive your listening data within 7 days.

2) Load Your Data into Tableau

Open up the .zip file that Apple sent you. Your data should open in a folder titled “Apple Media Services Information.” You’ll need to open this file and then open a .zip file titled “Apple_Media_Services.” Once you open the zip and the corresponding file, you should see a folder titled “Apple Music Activity.” Our desired file is “Apple Music - Play History Daily Tracks.”

Now, open up Tableau and, in the Connect Pane, click “More…” and open to the play history file from above. You should see on the left side of the program, under “Files,” other csv files within the same folder.

3) Explore Your Data in Tableau

Switch over to Sheet 1 in the sheets tab on the bottom and start making different visuals. We’ll walk through some useful features in Tableau and how to make a sheet for your most played tracks, then hand over the reins for you to draw your own insights.

Making Groups

To highlight specific metrics on our charts and graphs, we’ll need to learn how to make groups. Just select all of the values you want to be included in a group then right-click on the metric and select “Group.” It should have a paperclip icon. You can rename the group by right clicking on its name in the legend on the right and select “Edit Alias…” Now that the group is created, you can go to the Color mark and select your color preference.

Select points to make a group and rename them to make your worksheet easier to understand in the legend.

Using Tooltips

Tooltips are created automatically in Tableau but you can also edit them to say exactly what you want it to say! You can change labels or wording to make it easier to understand by clicking on the Tooltip square in the Marks pane. This will open up a text editor where you can add and edit text describing points on your worksheet. Texts in a gray box are drawing statistics directly from the sheet mentioned.

Make changes to tooltips by selecting the tooltip card and editing within the text box.

Making Worksheets

1. Rename the worksheet by right-clicking the tab on the bottom and click rename.
2. Drag the “Track Description” dimension to the Rows shelf.
3. Drag the “Hours” measure to the Columns shelf. Confirm that this appears as the Count of Hours by looking at the green pill. It should say CNT(Hours).
4. Reorganize the graph to sort descending in the toolbar.
5. Apply any filters you would like by going to the Analysis menu, hovering over filters, and then filtering either axis (Hours preferred).

Follow the same process as above to make the following suggested charts or make your own to explore any questions you might have of your own data! Feel free to rename any labels or values on the charts to make the data easier to understand.

Recommended Charts