Music library project analyzing personal music listening data gathered from iTunes using SQL and Tableau.
- 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.
- SQL Database Table Queries: Table 1 - Artist | Table 2 - Album | Table 3 - Song
- 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.