SQL Case Studies solved using Microsoft SQL Server and PostreSQL

This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.

A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.

Built a Data Model, Implemented Basic to Advanced SQL Queries

This project builds and analyzes a small transactional e-commerce database using SQL (SQLite). Main focus: Applying SQL to reach structural correctness before analytical output.

This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.

data-modeling-analysis-sql

Analysed an SQL case study by querying an IMDb-style relational dataset in MySQL using multi-table joins to identify high-performing genres, ratings trends, and talent insights for data-backed content recommendations and strategies.

This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics.

Answering ad-hoc business questions about Rockbuster’s film inventory, customer data, and payment records to support their transition to an online video rental service.

A SQL project to analyze music store data. Find the results of given data with the help of answering the questions using queries.

An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL — from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.

This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.

LeetCode SQL 50

Explores an E-Commerce dataset and generate various analytics and insights from customers' past purchase behavior.

A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.

Advanced SQL project analyzing financial transaction datasets to uncover fraud patterns, suspicious transfers, balance inconsistencies, and high-risk accounts using CTEs, recursive queries, and window functions.

🔍 Explore raw data through SQL for deep analytics, transforming insights into final reports on customer and product performance.