Welcome to my SQL-based analytical project where I explored customer behavior, sales performance, music genre trends, and employee support data from a digital music store database using Microsoft SQL Server Management Studio (SSMS 20).
The goal of this project is to:
- Understand sales performance across countries and cities
- Identify top-performing customers and employees
- Analyze music trends like top-selling genres and media types
- Create reusable SQL views for business insights
- Top Revenue-Generating Country
- Top 5 Customers by Revenue
- Monthly Revenue Trend
- Average Invoice per Customer
- Revenue by Billing City
- Top Purchased Track
- Most Popular Genre by Sales
- Revenue by Media Type
- Top Artists by Track Count
- Customers Supported Per Employee
- Customers with No Purchases
- Top Performing Employee
- Reusable View (
customer_spending)
Through this project, I was able to:
- ✅ Understand key revenue streams and customer behavior
- ✅ Identify top genres, artists, and media types contributing to sales
- ✅ Discover employee performance patterns and areas of customer drop-off
- ✅ Gain confidence writing advanced SQL queries like joins, aggregations, and views
- ✅ Practice real-world SQL problem solving used in Data Analyst roles
 SQL Server (SSMS 20) |
 SQL |
 Excel |
 Relational Schema |
Nirav Trivedi
Data Analyst
🔗 LinkedIn
💻 GitHub
- If you liked this project, feel free to star ⭐ the repository and share your feedback or suggestions. I'm always open to learning and collaboration!