Music_Store_Analysis_Using_SQL

Analysing Music Store Data

In this repository, I aim to explore the fascinating world of music through the lens of data. Using SQL (Structured Query Language), In this I analyze the vast datasets containing information about artists, albums, songs, and more. extract valuable insights from the music data, such as the most popular genres, and top-charting artists. SQL's simplicity and efficiency empower to manipulate large volumes of music data with ease. From aggregating play counts and calculating average song lengths.

Analysis

. Senior most employee based on job title.

. Countries have the most Invoices.

.City that has the highest sum of invoice totals.

. Genre of all Rock Music listeners.

. Top 3 values of total invoice.

and many more.

Prior Knowledge

Step To Start

1. Always start with creating Database in the SQL platform.

2. Then Import CSV file. Below procedure and screenshot show how to import the CSV dataset in SQL SERVER.

3. First go to the Explorer window section.

4. Left-click on database in the Explorer window

5. Then select the Task option

6. And last go to Import Flat file section and select CSV files and import it.

Schema-