Music Store Data Analysis

Welcome to the Music Store Data Analysis project! This repository contains code and documentation for analyzing a music store database. The goal is to derive insights from the data, such as customer purchasing patterns, popular genres, and sales trends.

Table of Contents

• Introduction
• Dataset
• Schema Diagram
• Database & Tool

Introduction

In this project, we perform an in-depth analysis of a music store's data. The dataset includes information about customers, invoices, invoice items, tracks, albums, artists, and genres. By analyzing this data, we can uncover trends and patterns that can help the music store optimize its operations and marketing strategies.

Dataset

The dataset used in this project is a SQL database that includes the following tables:

• customers
• employee
• invoice
• invoice_line
• track
• album
• artist
• genre
• media_type
• playlist_track
• playlist

Schema Diagram

Database & Tool

• MySQL 8.4
• MySQL Workbench 8.0 CE