Back to Projects
Case Study
Data Analysis and Visualization

Spotify Music Streaming Analysis Dashboard

A Power BI dashboard that helps understand Spotify streams, artists, tracks, charts, playlists, music mode, and platform trends.
Live Production AppDiscuss Project
Spotify Music Streaming Analysis Dashboard cover image

Key Metrics Analyzed

Top Track Streams29bn
Total Streams489bn
Last Year Streams116bn
Apple Charts49K
Apple Playlist65K
Deezer Charts3K
Deezer Playlist367K
Spotify Charts11K
Spotify Playlist5M
Average Stream Per Year514.14M
Minor Energy64%

Overview & Objectives

This project analyzes Spotify music streaming data using Power BI. It helps users understand track performance, artist rankings, total streams, yearly stream trends, music mode, song popularity, chart presence, playlist performance, and relationships between Spotify and other music platforms. The dashboard includes three report pages. The first page focuses on track-level information, track stats, average stream per year, music attributes, track count calendar, streams over time, top track names, and stream distribution by mode. The second page focuses on top artists, total streams for top tracks, platform chart metrics, danceability and valence relationships, streams by day of week, chart ranking, and artist streams by mode. The third page compares Spotify performance with Deezer, Apple, and Shazam using monthly trend line analysis.

Project Goal

Build a clear Power BI dashboard that helps users explore music streaming performance, compare artists and tracks, analyze chart rankings, and understand Spotify trends against other music platforms.

The Business Problem

Music streaming data can be difficult to understand when streams, artists, tracks, charts, playlists, music attributes, dates, and platform rankings are analyzed separately. The dashboard needed to combine all of these fields into one clear report so users can compare songs, artists, platforms, and streaming trends easily.
Methodology

My Approach

  • 1I cleaned and prepared the Spotify music streaming dataset.
  • 2I created Power BI measures for total streams, top track streams, yearly streams, artist rankings, chart counts, playlist counts, and music attribute comparisons.
  • 3I designed dashboard pages for track overview, artist and chart analysis, and monthly platform comparison.
  • 4I added visual comparisons by artist, year, track, date, mode, day of week, platform chart, playlist, and streaming trend.
Implementation

Roadmap Execution

Data Preparation

Cleaned and prepared the Spotify music streaming dataset for analysis.

Data Modeling

Created the Power BI data model for artists, tracks, dates, streams, chart rankings, playlists, music mode, and audio attributes.

DAX Development

Built measures for total streams, average stream per year, top track streams, artist ranking, platform charts, playlist counts, and mode-based stream analysis.

Track Overview

Designed the track overview page with track info, track stats, music attributes, calendar heatmap, top tracks, streams over time, and mode distribution.

Artist and Chart Analysis

Created artist and chart analysis visuals for top artists, platform ranking, streams by week day, song popularity, and artist streams by mode.

Platform Comparison

Built comparison visuals to analyze Spotify performance against Deezer, Apple, and Shazam charts and playlists over monthly trends.

Key Features

Spotify track overview
Track information and stats
Average streams per year
Music attribute analysis
Track count calendar
Total streams by mode
Top track names by streams
Streams over time
Top artists by total streams
Top 10 track streams
Platform chart and playlist metrics
Relationship between danceability, valence, and popularity
Streams by day of week
Presence and rank on different charts
Spotify versus Deezer charts
Spotify versus Apple charts
Spotify versus Shazam charts
Spotify playlist comparison with Apple and Deezer

Business Impact

Helps compare top Spotify artists and songs in one place
Makes streaming trends easier to understand
Shows chart and playlist performance across platforms
Supports better music performance analysis
Reduces manual music data exploration by using one interactive Power BI dashboard

Challenges Overcome

  • Combining artist, track, stream, chart, playlist, music attribute, and date data into one dashboard
  • Making song and artist performance easy to compare
  • Showing platform ranking relationships clearly
  • Comparing Spotify with Apple, Deezer, and Shazam metrics
  • Designing simple visuals for music trend analysis
Outcomes

Final Outcomes & Learnings

  • The final dashboard gives a clear view of Spotify track performance, top artists, streaming trends, chart presence, playlist performance, and cross-platform comparisons.
  • Users can quickly identify top songs, top artists, major versus minor mode streams, platform ranking patterns, and monthly performance relationships between Spotify, Apple, Deezer, and Shazam.

Project Gallery & Screenshots

Power BI Spotify dashboard showing track information, track stats, average streams per year, track count calendar, top tracks, streams over time, and mode distribution
Power BI Spotify dashboard showing top artists, total streams, chart metrics, playlist metrics, artist rankings, song popularity, and streams by mode
Power BI Spotify dashboard comparing Spotify charts and playlists with Deezer, Apple, and Shazam using monthly trend lines

Technologies Used

Power BIPower QueryDAXExcelData ModelingData Visualization

Data Sources

Spotify streaming datasetArtist dataTrack dataMusic attribute dataChart ranking dataPlaylist dataApple chart dataDeezer chart dataShazam chart dataDate and calendar data

Need similar outcomes in your business?

Let's scope your metrics and construct dashboards tailored to your parameters.

Discuss Similar Projects