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
| # | Project | Domain | Analysis Type | Key SQL Concepts | Core Focus |
|---|---|---|---|---|---|
| 01 | Walmart Retail Insights Optimization | Retail | Business Performance Analytics | Window Functions, Aggregations | Store Performance Analysis |
| 02 | Swiggy Food Delivery Analysis | Food Delivery | Customer & Restaurant Analytics | JOINs, Subqueries, DDL/DML | Restaurant Performance Insights |
| 03 | Big Basket Product Performance Analysis | E-Commerce / Retail | Product & Pricing Analytics | CTEs, Views, Stored Procedures | Pricing & Product Insights |
📁 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
| Category | Tools & Technologies |
|---|---|
| Database | MySQL |
| SQL Concepts | Window Functions · Subqueries · CTEs · Views · Stored Procedures |
| Analytics | Data Filtering · Aggregations · Business Reporting · Performance Analysis |
| Database Operations | DDL · DML · Constraints · Table Management |
| Tools | Git · GitHub · MySQL Workbench |
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