Skip to content

Yagneshvaghashiya/music-data-analysis-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

7 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🎧 Music Data Analysis using SQL

πŸ“Œ Project Overview

This project analyses a music database to extract insights about customer behaviour, popular genres, and revenue trends.

πŸ“Š Key Insights

  • Top customers by spending
  • Most popular music genres
  • Revenue distribution by country

πŸ›  Tools Used

  • SQL
  • SQLite
  • DB Browser for SQLite

πŸ“‚ Files Included

  • WSDA_Music.db (Database)
  • analysis_queries.sql (SQL queries)

πŸš€ What I Learned

  • Writing complex SQL queries
  • Data aggregation and joins
  • Extracting business insights from data

About

SQL project analysing music database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors