Music Store SQL Analytics Project

Overview

The Music Store SQL Analytics Project is designed to analyze a dataset from a music store, utilizing SQL queries to answer various business-related questions. This project aims to provide insights into customer behavior, sales trends, and employee performance within the music retail environment.

Table of Contents

• Project Structure
• Questions and Queries
• Database Schema
• Getting Started
• Usage
• Contributing
• License

Project Structure

The repository is organized as follows: Music-Store-SQL-Analytics-Project/ ├── questions/ │ ├── question1.sql │ ├── question2.sql │ └── ... ├── schema/ │ └── schema_image.png └── README.md

Questions and Queries

This project addresses multiple analytical questions related to the music store. Each question has a corresponding SQL query file located in the questions/ directory. Some example questions include:

1. What is the total revenue generated by each genre?
2. Which employee has the highest number of sales?
3. What are the top-selling albums in the last year?
4. Which country has the most customers?

Each SQL file contains the query used to extract relevant data from the database.

Database Schema

The database schema is visualized in the schema/schema_image.png file. It includes tables such as:

• Customers
• Employees
• Albums
• Genres
• Invoices

This schema outlines the relationships between different entities in the music store database.

Getting Started

To set up this project locally or run it online, follow these steps:

1. Clone the Repository: git clone https://github.com/clawnic/Music-Store-SQL-Analytics-Project.git

2. Install a Database Management System (DBMS):

• Use MySQL, PostgreSQL, or any other compatible DBMS.

3. Create Database:

• Create a new database in your DBMS and import the necessary tables based on the provided schema.

4. Run Queries:

• You can run your queries online using DB Fiddle.
  • Copy the SQL scripts from the questions/ directory.
  • Go to DB Fiddle, select your preferred SQL dialect (e.g., MySQL).
  • Paste your queries into the editor and execute them to see results.

Usage

To use this project effectively:

• Review each question and its corresponding query.
• Analyze the results obtained from executing the queries.
• Modify or extend queries as needed for further analysis.

Contributing

Contributions are welcome! If you have suggestions for improvements or additional queries, please fork the repository and submit a pull request.

License

This project is licensed under the MIT License - see the LICENSE file for details.

---

Last updated: Saturday, January 11, 2025