SQL Project - This is build to analyze music dataset which helps to boost a sales of new song that is about to launch.
🎵 Music Store Data Analysis
📌 Project Overview
This project focuses on analyzing a music store database using SQL to extract meaningful business insights. The goal is to answer real-world questions related to customers, sales, revenue, and music trends.
🎯 Objectives Analyze customer behavior and purchasing patterns Identify top-selling artists, tracks, and genres Evaluate revenue distribution across different countries Extract insights that can help improve business decisions 🛠️ Tools & Technologies SQL (MySQL / PostgreSQL compatible) Database Concepts (Joins, Subqueries, Aggregations, Window Functions)
🗂️ Database Schema The database consists of multiple tables such as:
customer invoice invoice_line track album artist genre employee
📊 Key Analysis Performed
-
Customer Analysis Identify top customers based on total spending Find customers from different countries
-
Sales & Revenue Insights Total revenue generated Revenue by country Highest invoice totals
-
Music Trends Most popular genres Top-selling artists Most purchased tracks
-
Advanced SQL Queries Use of JOINs to combine multiple tables GROUP BY & Aggregations for summaries Subqueries for deeper insights Window Functions for ranking and analysis
📈 Insights Gained A small group of customers contributes a large portion of revenue Certain genres dominate sales globally Popular artists significantly impact overall sales Revenue distribution varies significantly across countries