I built an interactive UK Playlist Intelligence Dashboard that transforms Spotify UK Top 50 playl...I built an interactive UK Playlist Intelligence Dashboard that transforms Spotify UK Top 50 playl...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
I built an interactive UK Playlist Intelligence Dashboard that transforms Spotify UK Top 50 playlist data into practical insights for artists, labels, and music marketing teams. The dashboard explores artist appearances, track popularity, collaborations, albums, explicit-content trends, and song-duration patterns to help users understand what performs well in the UK playlist ecosystem.
Users can filter the dataset by artist, album, date, popularity, and content type, then explore KPI summaries and interactive visualizations. The project also includes downloadable filtered CSV data and business-focused insights to support playlist strategy, release planning, and promotional decisions.
Technologies used: Python, Streamlit, Pandas, NumPy, Plotly, Matplotlib, Seaborn, NetworkX, Jupyter Notebook, and CSV data analysis.
This is what a real data cleaning job looks like before it becomes an elegant bar chart — duplicate rows, missing values, inconsistent formatting, all sorted out with Python and Pandas.
#collage attempt: a look inside the data analyst's actual desk, not just the pretty output.
3 mistakes that will eventually make this board useless. 📉
I've reviewed several client dashboards over the years, and the same 3 problems show up over and over:
1️⃣ Too many charts, no clear takeaway — if I can't tell what to do after looking at it, it's decoration, not a dashboard.
2️⃣ Colors with no consistent meaning — red means "unacceptable" on one chart and "category 3" on the next. Pick a system and stick with it.
3️⃣ No comparison point — a number alone means nothing. "Revenue: $12,480" tells you nothing. "Revenue: $12,480 (+18% vs last month)" tells you everything.
Fix these three, and your data stops being numbers on a page — it starts being something people actually use to decide.
What's the most common dashboard mistake you've seen? 👇