Music Store Analysis

SQL

The Music Store Sales Analysis project involves a comprehensive examination of a music store's sales data to extract meaningful insights. The project utilizes SQL queries to analyze various aspects of the store's operations, including employee hierarchy, invoice distribution, top customers, and popular genres.
 

Key Analyses and Findings:​

 

Senior Most Employee:

• Identified the senior-most employee based on job title and hierarchy levels.

​

Countries with the Most Invoices:

• Determined the countries with the highest number of invoices, helping to understand geographical sales distribution.

​

Top Invoice Values:

• Retrieved the top three invoice values to understand high-value transactions.

​

City with Best Customers:

• Identified the city with the highest sum of invoice totals, indicating the most lucrative customer base.

​

Best Customer:

• Find the customer who has spent the most money, recognizing the top customer by total spending.

​

Rock Music Listeners:

• Listed email, first name, and last name of all Rock music listeners ordered alphabetically by email.

​

Top Rock Artists:

• Identified the top 10 rock artists by the number of tracks, helping to focus on popular artists for promotions.

​

Tracks Longer than Average Length:

• Returned track names and their lengths for songs longer than the average song length, sorted by duration.