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

#Fourth project :- Advanced Data Analytic Project A comprehensive data analytics project covering 7 core analytical techniques applied to real-world datasets using SQL Server.

#Analysis TypeDescription:- 1)Changes Over Time -- Track trends and patterns across time periods 2)Cumulative Analysis -- Running totals and progressive growth metrics 3)Performance Analysis -- Benchmarking and KPI evaluation 4)Part-To-Whole Analysis -- Percentage contribution and composition breakdown 5)Data Segmentation -- Customer/product grouping by behavior or attributes 6)Customer Report -- Consolidated view of customer-level insights 7)Product Report -- Consolidated view of product-level insights