#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.