Skip to content

This repository contains a SQL dataset of a music store and SQL queries to answer questions about the data. The results of the SQL queries can be found in the analysis.sql file. This repository can be used as a starting point for anyone who wants to learn how to use SQL to analyze data.

Notifications You must be signed in to change notification settings

avishek-choudhary/Music-Store-Analysis

Repository files navigation

SQL Project: Music Store Analysis

Read the full detailed article here.

Description

This project uses SQL to analyze the dataset of an online music store. 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.

Installation

To run this project on your machine you need to install any SQL-supported DBMS then follow the steps below:

  1. Create a database.
  2. Create tables using the schema diagram provided below.
  3. Import csv files provided in the dataset folder.

Note: If you are using PostgreSQL then restore the backup file of the database and save yourself some time.

Schema Diagram

Schema Diagram

Database and Tools

  • Postgre SQL
  • PgAdmin4

Credits

Throughout the development of this project, I have sought inspiration from a pivotal video source: https://youtu.be/VFIuIjswMKM

License

You can use this dataset to build your own project and practice your SQL skills.


Badges

postgresql YouTube

Questions Answered

The following are a few of the questions that are answered in the project (check out analysis.sql file for the rest):

  • What are the most popular genres of music?
  • What are the most popular artists?
  • What are the most popular songs?
  • What are the average prices of different types of music?
  • What are the most popular countries for music purchases?

Results

The results of the project are as follows:

  • The most popular genre of music is "Rock".
  • The most popular artist is "Queens".
  • The most popular song is "War Pigs".
  • The average price of an album is $1.
  • The most popular country for music purchases is the United States.

Conclusion

The project was successful in answering the set of questions about the store's business performance. The results of the project can be used by the store to make decisions about its marketing and product offerings.

About

This repository contains a SQL dataset of a music store and SQL queries to answer questions about the data. The results of the SQL queries can be found in the analysis.sql file. This repository can be used as a starting point for anyone who wants to learn how to use SQL to analyze data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages