Music Store Analysis

A music store analysis SQL project involves examining and extracting valuable insights from a database related to a music store. The database contains tables with information about customers, employees, sales transactions, products (music albums or tracks), and inventory.

Tools Used:

1. MySQL 🐬
2. MySQL WorkBench 🛠️

Music Store Database Analysis

This repository contains SQL queries for analyzing a music store database. The database includes information about albums, artists, customers, invoices, and tracks. The queries provide insights into employee hierarchy, top-performing countries, customer spending, and more.

Table of Contents

• Prerequisites
• Database Schema
• Queries
  • Basic
  • Moderate
  • Advanced
• How to Use
• Contributing

Prerequisites

Make sure you have a MySQL database set up with the provided schema. You can find the SQL script for creating the database here.

Database Schema

The database schema includes tables for albums, artists, customers, invoices, tracks, and more. For a detailed overview, refer to database_schema.md.

Queries

Basic

1. Senior Most Employee: Find the senior most employee based on job title.
2. Top Invoiced Countries: Identify countries with the most invoices.
3. Top 3 Invoices: List the top 3 invoices based on the total amount.
4. Best City for Music Festival: Determine the city with the highest sum of invoice totals.

Moderate

1. Rock Music Listeners: Retrieve the email, first name, last name, and genre of all Rock music listeners.
2. Top 10 Rock Bands: List the top 10 rock bands based on the total number of tracks.
3. Longest Tracks: Return track names with a song length longer than the average, ordered by song length.

Advanced

1. Customer Spending on Artists: Find the amount spent by each customer on artists.
2. Popular Genre by Country: Determine the most popular music genre for each country.
3. Top Customer by Country: Identify the customer that has spent the most on music for each country.

How to Use

1. Clone the repository: git clone https://github.com/your-username/music-store-database.git
2. Set up your MySQL database using the provided script: mysql -u username -p < database_setup.sql
3. Run the queries in your MySQL environment or preferred database management tool.

Other Projects

Explore some of my other projects:

• HR ANALYTICS DASHBOARD 📊
• SALES DATA ANALYSIS 🛒
• Netflix Data Analysis using Python 🎬
• Bank Loan Analysis using Tableau 💼
• Blog Me Sentiment Analysis using Python 📰
• Music Store Analysis using MySQL 🎶

Contributing

Feel free to contribute by adding new queries, improving existing ones, or providing suggestions for better analysis.