.png){kind=link}
Welcome to the Spotify Streaming Insights (2010–2019) project — a comprehensive Excel-based analysis exploring the top songs and artists of the decade. This project uses Microsoft Excel to uncover trends in genre popularity, playlist influence, and platform dominance, all drawn from actual stream data.
This analysis seeks to answer the following key questions:
- Who were the most streamed artists and songs between 2010 and 2019?
- What genres performed best across the decade?
- How do playlist and chart appearances influence total stream counts?
- Which song features (e.g. mode, energy, danceability) are common among top-performers?
The dataset was obtained from DataCamp Workspace and includes:
- Song name, Artist, and Release Year
- Total Streams
- Chart and Playlist appearances across platforms
- Genre and song attributes (BPM, Energy, Mode, etc.)
This analysis was performed entirely in Microsoft Excel and includes:
- PivotTables for grouped analysis
- Charts and Dashboards (Bar, Line, Donut, Cards, etc.)
- Calculated metrics for stream totals, genre share, and platform comparison
- Ed Sheeran emerged as the most streamed artist with 16.57B streams.
- Adele’s "Hello" led as the top-streamed song (~3.92B streams).
- Dance Pop dominated the genre category with over 200B streams.
- Playlist and chart presence had a strong positive correlation with stream counts.
- Most top-performing songs were released between 2015 and 2019.
- 🎯 Focus marketing efforts on playlist pitching across multiple platforms.
- 🚀 Consider releasing songs early in the year to maximize stream accumulation.
- 🎼 Track musical features (e.g., Major key, Dance Pop genre) that align with audience preferences.
- 📈 Encourage consistent artist presence with multiple hit releases over time.
- 🌍 Leverage YouTube & Apple playlist dominance to drive long-term visibility.
- X (Twitter): @demibolt_
- LinkedIn: Oluwademilade Adeniyi
- Clone the repository
git clone https://github.com/Demibolt007/Spotify-Streaming-Insights-2010-2019.git