Analyzed a Music Store database using SQL to uncover customer behavior, sales trends, top artists, and revenue insights.
This project analyzes a relational Music Store database using SQL queries to solve real-world business problems and generate meaningful insights.
- Customer purchasing behavior
- Revenue analysis
- Genre popularity
- Artist performance
- Country-wise sales trends
- Customer spending patterns
The project demonstrates strong SQL skills including joins, aggregations, subqueries, CTEs, and window functions.
- MySQL
- MySQL Workbench
- Senior most employee
- Countries with highest invoices
- Best customer
- Top Rock artists
- Most popular genre by country
- Customer spending analysis
- Joins
- Aggregate Functions
- Subqueries
- CTEs
- Window Functions
- USA generated the highest revenue
- Rock music is highly popular
- Top customers contribute major sales