This project is an in-depth SQL-based analysis of an online music store's dataset. The primary aim is to provide valuable insights that can inform decision-making and contribute to the store's growth and success.
The project addresses several critical questions including:
sql
-
Q1: Who is the senior most employee based on job title?
-
Q2: Which country has the most invoices?
-
3: Who is the best customer in terms of spending?
-
Q4: Let's invite the artists who have written the most rock music in our dataset.
-
Return the Artist name and total track count of the top 10 rock bands.
-
Q5: Determine the most popular music genre for each country.
-
you can find more detailed analysis in the "music_analysis.sql" file
Here are the key findings from the analysis:
- Most Popular Genre: Rock
- Top Artist: Queens
- Favorite Song: "War Pigs"
- Average Album Price: $1
- Leading Country for Music Purchases: United States
This project equips the music store with actionable insights that can be used to enhance marketing strategies, improve product offerings, and foster business growth.