Skip to content

Latest commit

 

History

3 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Spotify-dashboard

🎧 Spotify Analytics Dashboard – Power BI

An interactive Spotify Analytics Dashboard built using Power BI to explore songs, artists, popularity trends, and album insights. This dashboard provides a clean UI inspired by Spotify with deep analytical insights for music data exploration.


📊 Dashboard Preview

🏠 Home

Landing page with Spotify-themed UI and navigation to all report pages.

📈 Overview

  • Total Distinct Songs
  • Count of Artists
  • Average Duration
  • Average Popularity
  • Songs by Album Type
  • Explicit vs Non-Explicit Distribution
  • Avg Popularity by Month
  • Distinct Songs by Month

🎤 Artists Analysis

  • Artist by Songs

  • Songs by Popularity

  • Songs by Hit

  • Artist-level metrics:

    • Avg Duration
    • Avg Popularity
    • Max / Min Popularity
    • Hit Ratio

🎵 Songs Analysis

  • Song by Artist filter

  • Songs by Popularity

  • High Popularity Songs

  • Song level table with:

    • Release Date
    • Album Type
    • Avg Duration
    • Popularity Metrics

✨ Features

✅ Spotify-style UI design ✅ Interactive filters and slicers ✅ Artist-level analytics ✅ Song-level insights ✅ Popularity trend analysis ✅ Album type comparison ✅ Explicit vs Non-explicit analysis ✅ Monthly trend visualization ✅ Clean and modern dark theme


🛠️ Built With

  • Microsoft Power BI
  • Power Query
  • DAX Measures
  • Data Modeling
  • Custom Visual Formatting

📂 Dataset Details

The dataset includes:

  • Song Name
  • Artist
  • Album Type
  • Release Date
  • Duration
  • Popularity
  • Explicit Flag
  • Track Metrics

📊 Key Insights

  • Most songs are released as Albums vs Singles
  • Popularity varies significantly by Artist
  • Monthly trend shows declining average popularity over time
  • Few artists dominate high popularity hits
  • Explicit tracks form a significant portion of total songs

🎯 Project Objectives

  • Practice Power BI dashboard design
  • Apply DAX measures
  • Build interactive report navigation
  • Create Spotify-themed UI
  • Analyze music dataset

📸 Dashboard Pages

  • Home
  • Overview
  • Artists
  • Songs

🚀 How to Use

  1. Download .pbix file
  2. Open in Power BI Desktop
  3. Use navigation buttons
  4. Apply filters
  5. Explore insights

👨‍💻 Author

Prince Gupta First Power BI Project – Spotify Dashboard


⭐ If you like this project

Give it a ⭐ on GitHub and feel free to fork!


About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors