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.
Built a Data Model, Implemented Basic to Advanced SQL Queries
data-modeling-analysis-sql
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.
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.
This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
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.
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.
LeetCode SQL 50
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.
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.
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.
Add a description, image, and links to the common-table-expressions topic page so that developers can more easily learn about it.
To associate your repository with the common-table-expressions topic, visit your repo's landing page and select "manage topics."