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.
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.
- Run create.sql to create the necessary tables in your database.
- 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).
- Install the necessary packages and run insert_data.py! Make sure to ensure it is connected to your database properly.
- Set your database as a datasource in the Tableau workbook.
- Enjoy your listening history visualized!