Skip to content
/ Music-Store-Data-Analysis-Project-using-SQL Public

"I extensively analyzed a dataset with SQL, focusing on sales and customer data from a digital music store. Through SQL queries, I explored insights into store performance, popular genres, top-selling albums, and customer behavior."

1 star 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

MansiTamrakar05/Music-Store-Data-Analysis-Project-using-SQL

BranchesTags

Repository files navigation

I've analyzed the dataset using SQL to assist the Music Store in gaining insights into its business growth by addressing basic inquiries.

Database and Tools

  • Postgre SQL
  • PgAdmin4

Concepts used for this project

  • Aggregation functions like sum, average, count
  • Window functions
  • sub-queries
  • Common Table Expression(CTEs)
  • Joins: Self-join,Right join, Inner join

Schema- Music Store Database
MusicDatabaseSchema

About

"I extensively analyzed a dataset with SQL, focusing on sales and customer data from a digital music store. Through SQL queries, I explored insights into store performance, popular genres, top-selling albums, and customer behavior."

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published