🎵 SQL Music Store Analysis

📂 Project Overview

This project analyzes a relational music store database using MySQL to extract valuable business insights related to customer spending, revenue trends, and popular music genres. The project demonstrates SQL querying skills through multi-table joins, aggregations, and business-driven problem solving.

---

🎯 Objective

• To perform end-to-end SQL analysis on a music store dataset.
• To answer key business questions related to sales, customers, and product preferences.
• To apply SQL techniques like joins, aggregations, and subqueries to solve real-world scenarios.

---

🛠️ Tools & Technologies

• MySQL Workbench
• SQL (Joins, Aggregations, Subqueries)

---

📁 Dataset Description

• Database: Music Store Database
• Tables Used:
  • Customer
  • Invoice
  • Invoice Line
  • Track
  • Genre
  • Employee
  • Artist
• Key Fields:
  • Customer details (name, country)
  • Invoice amounts and locations
  • Music genres and track details

📐 Database Schema Diagram

---

📝 Key Analysis Performed

1. Identified the top customers based on total spending.
2. Determined the countries and cities generating the most revenue.
3. Analyzed the most popular music genres among customers.
4. Found the best-selling invoices and top-spending customers.
5. Provided insights that can guide business decisions like targeted marketing and genre-based promotions.

---

📈 Sample Business Questions Solved

• Who is the senior-most employee in the company?
• Which countries have the most invoices?
• What are the top 3 invoice totals?
• Which city has the best customers based on total revenue?
• Which music genre is the most popular across different countries?