🎵 Digital Music Store Analysis Using SQL

📌 Project Overview

This project analyzes a Digital Music Store database using SQL to answer real-world business questions related to customers, sales, revenue, and employee performance.

The objective is to extract meaningful insights from relational data and demonstrate SQL skills commonly used in Data Analyst roles.

---

🛠 Tools & Technologies

• PostgreSQL
• pgAdmin 4
• SQL
• Git
• GitHub

---

🗄 Database Schema

The database contains the following tables:

• Artist
• Album
• Track
• Genre
• MediaType
• Playlist
• PlaylistTrack
• Employee
• Customer
• Invoice
• InvoiceLine

---

📊 Business Questions Solved

Q1. Who is the senior most employee?

Used ORDER BY and LIMIT to identify the highest-ranking employee.

Q2. Which countries have the most invoices?

Used GROUP BY and COUNT() to analyze invoice distribution across countries.

Q3. What are the top 3 invoice totals?

Used ORDER BY DESC and LIMIT to identify the highest invoice values.

Q4. Which city generates the highest revenue?

Used SUM() aggregation to determine the city contributing the most revenue.

Q5. Who is the best customer?

Joined Customer and Invoice tables to identify the customer with the highest spending.

---

📈 SQL Skills Demonstrated

• SELECT

• WHERE

• ORDER BY

• GROUP BY

• Aggregate Functions

  • COUNT()
  • SUM()

• INNER JOIN

• LIMIT

• Business Analytics

---

🎯 Key Learnings

• Writing business-focused SQL queries
• Working with relational databases
• Performing customer and sales analysis
• Extracting actionable business insights
• Improving SQL problem-solving skills

---

👨‍💻 Author

Krishan Choudhary

Data Analyst

LinkedIn: https://www.linkedin.com/in/krishan-choudhary-69894235b/