Skip to content

Files

Latest commit

 

History

History
48 lines (31 loc) · 1.71 KB

README.md

File metadata and controls

48 lines (31 loc) · 1.71 KB

Music Store Analysis🎵

🎻Project Description:
This project uses SQL to analyze the dataset of an online music store.

The objective of the project is to gain valuable insights into the store's operations, Customer Segmentation, trends ,artist effectiveness, artist growth, customer interest and money spent by customer.

The goal of the project is to answer a set of questions about the store's business performance and help in its growth by making better decisions.

🎻Tool Used:
MySQL(Queries, Subqueries, Joins, CTE, Window functions, Aggregate functions)using this I have analyze data.

🎻Tables Used:
album artist customer employee invoice genre invoice_line media_type playlist playlist_track track

🎻Queries of the Project:

Q1: Who is the senior most employee based on job title?

Q2: Which countries have the most Invoices?

Q3: What are top 3 values of total invoice?

Q4: Which city has the best customers? We would like to throw a promotional Music Festival in the city we made the most money.

Q5: Who is the best customer? The customer who has spent the most money will be declared the best customer.

Q6: Write query to return the email, first name, last name, & Genre of all Rock Music listeners.

Q7: Let's invite the artists who have written the most rock music in our dataset.

Q8: Return all the track names that have a song length longer than the average song length.

Q9: Find how much amount spent by each customer on artists? Write a query to return customer name, artist name and total spent

Q10: We want to find out the most popular music Genre for each country.

Q11: Write a query that determines the customer that has spent the most on music for each country.