Personal Projects - Database
Project Title: Music Store Analysis
Tools Used: MySQL
Project Description: This project analyzes a music store database using MySQL to understand customer behavior, sales performance, and artist popularity. The analysis includes finding the highest-ranking employee, identifying the countries with the most invoices, and determining the top-spending customers. It also looks at the most popular music genres in different countries, the best cities for promotional events, and which customers prefer Rock music. By using SQL queries, the project aims to help improve sales strategies, boost customer engagement, and guide marketing decisions.
Concepts Used: SQL (MySQL), Window Functions (e.g., RANK, DENSE_RANK), Aggregate Functions (e.g., SUM, COUNT), Joins (INNER JOIN), Subqueries, CTE (Common Table Expressions), Data Analysis Queries, Sorting and Filtering Data, Grouping Data (GROUP BY), Ordering Results (ORDER BY)
GitHub: Open GitHub Repository
*Upcoming
Project Title: Pizza Sales Analysis
Tools Used: MySQL
Project Description: This project focuses on analyzing pizza sales data to derive important business insights using SQL. The analysis covers key metrics like the total number of orders, overall revenue, and popular pizza types. It also explores order patterns by time, distribution of pizza categories, and revenue trends. The project aims to offer a clear view of sales performance to guide business strategies
Concepts Used: SQL, Aggregation Functions (SUM, COUNT, AVG), Joins, Subqueries, Grouping, Window Functions, Date Function
GitHub: Open GitHub Repository
