Music Store Database Analysis
A SQL project built using PostgreSQL to analyze a digital music store database and generate business insights from customer, sales, artist, and genre data.
This project solves real-world business problems using SQL, covering customer analytics, sales performance, artist popularity, and market trends through basic to advanced SQL queries.
- PostgreSQL
- SQL
- pgAdmin 4
- Git & GitHub
- SELECT, WHERE, GROUP BY
- ORDER BY, HAVING
- Aggregate Functions
- Joins
- Subqueries
- CTEs
- Recursive CTEs
- Window Functions
- Customer Spending Analysis
- Sales Performance Analysis
- Artist & Genre Analysis
- Country & City Revenue Analysis
- Customer Segmentation
Music-Store-Database-Analysis ├── Dataset ├── SQL_Queries ├── Documentation ├── Screenshots └── README.md
- 📘 Project_Report.pdf
- 📊 Business_Insights.pdf
- ⚡ Query_Optimization.md
- 🗂️ ER_Diagram.png
• PostgreSQL • Relational Databases • Data Analysis • Business Intelligence • Query Optimization**