Interactive Music Dashboard (Updates Daily)

• Insights include dominant genres for each region, song reach, artist chart dominance, and time trends

• Filter by region, genre, artist, or song by clicking on it

• Sort by artist, title, release date, or number of charts by clicking on the header.

• Backend:

  • A Python script scrapes all regional Apple Top 100 lists daily and loads the data into a local database

  • Views in the database are used to transform the data.

  • Another Python script queries the database daily and uploads the data to a google sheet

  • The Tableau Public dashboard is linked to the google sheet

• Insights include average rankings across platforms, differences in user preferences between platforms, dominant categories among top 100 podcasts, plus trend information for categories and individual podcasts

• Quickly find the dominant categories or find a podcast to listen to in any category

• Filter by platform (Apple/Spotify/Both), podcast, or category

• Sort by rank, duration, or title

• Backend:

  • A Python script scrapes Apple Top 100 podcasts while another scrapes Spotify

  • Both are loaded into a local database

  • Views in the database are used to transform the data.

  • Another Python script queries the database daily and uploads the data to a google sheet.

  • The Tableau Public dashboard is linked to the google sheet

Interactive Podcast Dashboard (Updates Daily)