Skip to content

A SQL project analyzing a music store database, covering customer behavior, sales trends, and artist/genre popularity. Includes advanced queries to generate insights into revenue, customer demographics, and top-performing tracks, albums, and artists.

Notifications You must be signed in to change notification settings

Samriddhi272/Music-Store-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

5 Commits
Β 
Β 
Β 
Β 

Repository files navigation

Music Store Analysis 🎢

This repository contains SQL queries used to analyze a sample Music Store database.
The analysis explores customer behavior, sales performance, and music genre trends.

πŸ“Œ About

The project demonstrates how SQL can be used for data analysis on relational databases.
It is designed as a practice/portfolio project for learning SQL and analytical thinking.

πŸ“Š Key Queries & Insights

  • Top customers based on total spending
  • Most popular music genres and tracks
  • Revenue analysis by country
  • Best-selling artists and albums
  • Customer distribution by location

πŸ› οΈ Tech Stack

  • SQL (PostgreSQL / MySQL compatible)
  • Sample Music Store dataset

πŸš€ How to Use

  1. Clone this repository: git clone https://github.com/samriddhi272/Music-Store-Analysis.git

About

A SQL project analyzing a music store database, covering customer behavior, sales trends, and artist/genre popularity. Includes advanced queries to generate insights into revenue, customer demographics, and top-performing tracks, albums, and artists.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published