This project analyzes Spotify track performance data using PostgreSQL to uncover insights related to artist popularity, track engagement, and platform performance (Spotify vs YouTube). The analysis focuses on answering business-driven questions and presenting results through a clean, executive-friendly Power BI dashboard.
- Identify top-performing artists and tracks based on engagement
- Compare Spotify streams vs YouTube views
- Understand how audio features influence popularity
- Provide quick, high-impact insights through a minimal, structured dashboard
- Database: PostgreSQL
- Query Language: SQL
- Visualization: Power BI
- KPI overview of total tracks, artists, streams, and views
- Top 10 artists and tracks by engagement
- Platform performance comparison (Spotify vs YouTube)
- Advanced analysis: Top 5 artists and their top 3 tracks
- Audio feature impact analysis (energy/danceability vs engagement)
- A small number of artists account for a significant share of total engagement
- Certain tracks perform better on Spotify than YouTube, indicating platform preference
- High-energy and highly danceable tracks tend to attract higher engagement
- Top artists consistently have multiple high-performing tracks rather than a single hit
