Skip to content

Fun work with my Spotify listening history and Tableau!

Notifications You must be signed in to change notification settings

msohaill/spotify-tableau

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Analyzing Spotify Listening History With Tableau!

In this repository, I've included some files that I used in order to analyze my Spotify listening history using Tableau Desktop! Hope you find it useful as well. You can view the dashboard I created here.

My Spotify Dashboard

How to use:

Pre-requisites:

  • Familiarity with PostgreSQL (and a running server/database)
  • Tableau (of course!)
  • Your technical Spotify listening information (obtained by emailing [email protected]).
  • A database GUI (i.e., DBeaver), if you prefer.

  1. Run create.sql to create the necessary tables in your database.
  2. Add your endsong_#.json files to the array on line 13 in insert_data.py. Also make sure to add the client id and client secret variables for the Spotify API (lines 66-67).
  3. Install the necessary packages and run insert_data.py! Make sure to ensure it is connected to your database properly.
  4. Set your database as a datasource in the Tableau workbook.
  5. Enjoy your listening history visualized!

About

Fun work with my Spotify listening history and Tableau!

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages