Project Information
- Category: Data Analysis
- Client: Personal Project
- Project Date: Feb, 2024
- Project URL: GitHub Repository
- Tool & Tech: PostgreSQL, PgAdmin4
SQL Project: Music Store Analysis
This project involves analyzing a music store database using PostgreSQL and PgAdmin4. Key queries include:
- Senior Most Employee by Job Title
- Countries with Most Invoices
- Top 3 Values of Total Invoice
- City with the Best Customers
- Best Customer
- Rock Music Listeners
- Top 10 Rock Bands
- Tracks Longer Than Average
- Amount Spent by Each Customer on Artists
- Most Popular Music Genre for Each Country
- Top Customer for Each Country
The project provides insights into customer behavior, sales trends, and popular music preferences, offering a comprehensive view of the music store's performance.