🔎 Objective:
Conducted an in-depth analysis of Spotify’s 2024 song list to provide insights into song performance. Key questions addressed included:
- How do explicit and non-explicit tracks compare in performance?
- Which metrics non-explicit songs perform better over explicit ones?
- What criteria does each track excel in?
- Which tracks scored the highest in one or more performance metrics?
- Which artists have the most songs on the list?
- How does the #1 ranked track compare to the best-performing tracks across different platforms?
📊 Results:
- Data Enrichment: Added country data using ISRC codes for deeper geographic insights.
- Performance Insights: Identified tracks with top performance across various metrics for detailed analysis.
- Data Visualization: Created dynamic pivot charts to reveal:
- Top 10 artists with the most charting songs based on best rankings.
- Explicit vs. non-explicit track distribution with average track scores.
- Top 10 countries producing charting songs.
- Performance breakdown of explicit vs. non-explicit songs across metrics and rankings.
- Simple Dashboard: Designed a user-friendly dashboard integrating all visualizations, including a country slicer for customized analysis.
📈 Tools Used:
• Microsoft Excel (Pivot Tables, Pivot Charts, Dashboards)
• Data Cleaning & ISRC Code Integration
