Skip to content

Muskantak1098/sql-projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

#First Project:-Mini_project:- Monthly expense analysis

This project demonstrates how SQL can be used to analyze real-life expense data, calculate business-relevant metrics, and generate insights that support better financial decision-making. To track and analyze monthly expenses. To identify highest spending categories. To calculate key metrics and KPIs using SQL.

#Second Project:- Online_Book_Store

Wrote SQL Queries for data retrieval, filtering, aggregation, and reporting. Includes advance query using JOINS, GROUP BY, HAVING, COALESCE. Analyze book sales, customer orders to determine sold books, remaining stocks and top spending customers. Generated insights such as total revenue, genre-wise book.

#Third Project:- Zepto E-Commerce Data Analysis

Data exploration using SQL (missing values, duplicates, categories) . Data cleaning (zero pricing, converting paise to rupees) . Business analysis using SQL (revenue, stock analysis, product segmentation) . Identified patterns in pricing, discounts and inventory to support strategic business decisions.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published