Welcome to my SQL Case Studies Portfolio! This repository showcases various real-world case studies where SQL is used to solve data-driven problems through insightful queries and analysis. These projects reflect my understanding of database management, query optimization, and analytical thinking using Structured Query Language (SQL).
- 🗃️ Data Extraction and Transformation (ETL)
- 🧮 Aggregations and Window Functions
- 🧹 Data Cleaning using SQL
- 📊 KPI Calculations
- 📈 Trend Analysis and Reporting
- ⛓️ Joins, Subqueries, CTEs, and Views
- 🔎 Real-world Business Insights using SQL
| Case Study Title | Description | Link to Queries |
|---|---|---|
| 🧠Data Science Job Case-Study | This case study analyzing global trends in the Data Science job market using advanced SQL techniques. The project involves solving 8 practical business problems using structured data and showcases my ability to derive insights using SQL. | 🔗 View SQL |
| 🧠fictional online retail company's database Case-Study | This project simulates a fictional online retail company's database and demonstrates a wide range of SQL skills, including database design, data manipulation, and query development for reporting and analytics. | 🔗 View SQL |
| 🧠Shark Tank India Case-Study | This case study analyzing trends in the Shark Tank India using advanced SQL techniques. The project involves solving 10 practical business problems using structured data and showcases my ability to derive insights using SQL. | 🔗 View SQL |
📌 Each folder contains the SQL queries, the dataset (if applicable).
- SQL Server / MySQL / PostgreSQL
I'm Shreyank Kasable, a Data Science passionate about solving business problems through data. I specialize in SQL, and storytelling with numbers.