Skip to content

Repository files navigation

Music Store Database Analysis

A SQL project built using PostgreSQL to analyze a digital music store database and generate business insights from customer, sales, artist, and genre data.

📌 Overview

This project solves real-world business problems using SQL, covering customer analytics, sales performance, artist popularity, and market trends through basic to advanced SQL queries.

🛠️ Tech Stack

  • PostgreSQL
  • SQL
  • pgAdmin 4
  • Git & GitHub

🧠 SQL Concepts

  • SELECT, WHERE, GROUP BY
  • ORDER BY, HAVING
  • Aggregate Functions
  • Joins
  • Subqueries
  • CTEs
  • Recursive CTEs
  • Window Functions

📊 Business Analysis

  • Customer Spending Analysis
  • Sales Performance Analysis
  • Artist & Genre Analysis
  • Country & City Revenue Analysis
  • Customer Segmentation

📂 Repository Structure

Music-Store-Database-Analysis ├── Dataset ├── SQL_Queries ├── Documentation ├── Screenshots └── README.md

📄 Documentation

  • 📘 Project_Report.pdf
  • 📊 Business_Insights.pdf
  • ⚡ Query_Optimization.md
  • 🗂️ ER_Diagram.png

🚀 Skills Demonstrated

• PostgreSQL • Relational Databases • Data Analysis • Business Intelligence • Query Optimization**

About

SQL-based business analytics project using PostgreSQL to analyze customer behavior, sales performance, artist popularity, and genre trends through advanced SQL queries on the Chinook Music Store database.

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors