A curated collection of real-world SQL case studies and analytics projects designed to showcase practical database querying, business analytics, and data analysis skills using MySQL.

These projects demonstrate hands-on experience with advanced SQL concepts including Window Functions, CTEs, Subqueries, Views, Stored Procedures, Data Aggregation, and Business Reporting across multiple business domains.

This portfolio demonstrates practical experience in solving real-world business problems using SQL-driven analytics workflows.

Each project focuses on transforming raw business datasets into actionable insights through structured querying, analytical reporting, and database optimization techniques.

Target Roles: Data Analyst · SQL Developer · BI Analyst · Analytics Engineer · Reporting Analyst

📁 Folder: Project-1_walmart-retail-insights-optimization

Business Problem: Analyze Walmart retail sales data to uncover store performance trends, department-level insights, and seasonal business patterns.

Approach: Developed SQL-driven analytical workflows using aggregations, filtering logic, and window functions to evaluate retail business performance.

• Store-wise and department-wise performance analysis
• Holiday impact analysis
• Rolling averages and trend detection using window functions
• Data cleaning and filtering with WHERE and CASE
• Aggregate analysis using GROUP BY and ORDER BY

MySQL · CASE · JOINS · GROUP BY · ORDER BY · Window Functions

🔗 Repository Link:
https://github.com/shivee-code

📁 Folder: Project-2_swiggy_food_delivery_analysis

Business Problem: Analyze restaurant performance and customer satisfaction metrics to identify operational and customer experience insights.

Approach: Built SQL queries and relational analysis workflows to evaluate restaurant ratings, delivery trends, and cuisine performance metrics.

• Top-rated and most reviewed restaurants
• Cuisine and area-wise performance
• Delivery time, price filtering, and average rating insights
• Creation of customer feedback table
• Use of DELETE, UPDATE, and constraints

MySQL · DDL/DML · Filters · Aggregates · JOINs · Subqueries · Table Creation

🔗 Repository Link:
https://github.com/shivee-code

📁 Folder: Project-3_product_performance_analysis_BigBasket

Business Problem: Analyze product pricing, customer preferences, and sales performance to support business decision-making and pricing strategies.

Approach: Applied advanced SQL concepts including CTEs, window functions, views, and stored procedures for product-level analytics and reporting.

• Ranking products by sale price using window functions
• Lead/Lag analysis of pricing trends
• Top-rated products per category using CTEs
• Views for beauty & hygiene data and discount calculation
• Stored procedures for dynamic pricing and category queries

MySQL · Window Functions · CTEs · Views · Stored Procedures · CASE · Subqueries

🔗 Repository Link:
https://github.com/shivee-code

SQL-Projects-Portfolio/
│
├── Project-1_walmart-retail-insights-optimization/
│   ├── walmart_analysis.sql
│   └── README.md
│
├── Project-2_swiggy_food_delivery_analysis/
│   ├── swiggy_analysis.sql
│   └── README.md
│
├── Project-3_product_performance_analysis_BigBasket/
│   ├── bigbasket_analysis.sql
│   └── README.md
│
└── README.md   ← You are here

• SQL Analytics: Complex Querying · Data Aggregation · Business Intelligence Reporting
• Advanced SQL: Window Functions · CTEs · Views · Stored Procedures · Subqueries
• Database Operations: Table Creation · Constraints · UPDATE · DELETE · Data Management
• Business Analysis: Retail Analytics · Product Performance · Customer Insights
• Data Transformation: Filtering · Ranking · Trend Analysis · Performance Evaluation
• Problem Solving: Translating business requirements into analytical SQL solutions

This portfolio is built to:

• Demonstrate SQL proficiency in real-world business scenarios
• Practice and showcase analytical problem-solving workflows
• Build job-ready projects for Data Analytics and BI roles
• Strengthen advanced SQL and database management skills

Shivam Kumar

Aspiring Data Analyst & BI Developer focused on:

• SQL & Database Analytics
• Business Intelligence & Reporting
• Data Visualization & Insights
• Data Cleaning & Transformation
• Enterprise Analytics Solutions

LinkedIn:
https://www.linkedin.com/in/shivam-kumar-2a0371246/

GitHub:
https://github.com/shivee-code

"Without data, you're just another person with an opinion." — W. Edwards Deming