jrgem / music_library

Music library project analyzing personal music listening data gathered from iTunes using SQL and Tableau.

SQL Music Library Database

Music library project analyzing personal music listening data gathered from iTunes using SQL and Tableau.

---

Timeline

• Gathered relevant music data from personal iTunes library.
• Manually created a database with gathered statistics utilizing SQL (PostgreSQL and pgAdmin4).
• Continued using SQL to query insights for music database analysis and resolve questions.
• Created a meaningful and interactive visualization dashboard using Tableau.

---

Entity-Relationship Model & Data Set

• SQL Database Table Queries: Table 1 - Artist | Table 2 - Album | Table 3 - Song

---

Music Library Insights

• Top 30 most played albums and songs based on individual song count.
• Total hours and play count spent listening to music per year since 2005.
• Most popular genre analyzed by total album play count.
• Most popular music artists of all time including their country of origin.
• Precise artist, album, and song playtime queries.