This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

• UpdatedMar 26, 2025
• TSQL

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

• UpdatedAug 9, 2025
• TSQL

This repository features SQL-based analysis on bike rentals and the NFT market. The bike rental project explores customer trends, peak rental times, and revenue insights, while the NFT case study analyzes sales trends, blockchain transactions, and market dynamics. Built using SQL queries for data cleaning, aggregation, and joins in MySQL.

• UpdatedJan 26, 2025

SQL case studies and exercises from my studies at Mate Academy. This repository contains queries for data analysis, transformations, and optimization, covering topics like joins, window functions, and aggregate queries. A learning journey in SQL for data analytics.

• UpdatedMar 28, 2025

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.

• UpdatedFeb 15, 2025
• HTML

This repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge

• UpdatedOct 16, 2025

Using complex SQL queries, including PostgreSQL window functions, to answer specific business questions. Notably using multiple named subqueries, views to extract data from a database to address specific problems.

• UpdatedJul 30, 2024
• Jupyter Notebook

• UpdatedJan 13, 2025
• SQL

This repository contains a collection of SQL scripts that demonstrate various analysis techniques, such as change over time, cumulative, performance, data segmentation, part-to-whole analysis.

• UpdatedAug 6, 2025
• TSQL

bunch of SQL Window function query examples

• UpdatedJul 21, 2024

SQL_Notes: Learn SQL concepts through practical application! This repository contains concise notes on key SQL concepts, commands, and techniques, illustrated by solutions to LeetCode SQL challenges and exercises from other sources. Sharpen your SQL skills by understanding the why behind the code!

• UpdatedApr 7, 2025
• Jupyter Notebook

Developed a data processing pipeline to transform Canadian banking data using PySpark on Databricks. The pipeline standardizes, cleans, and enriches raw financial datasets for downstream analytics and reporting.

• UpdatedJul 26, 2025
• Jupyter Notebook

This repository contains SQL scripts for analyzing ERP and CRM data from the gold layer of the data warehouse built in PostgreSQL-Data-Warehouse-Project. It covers both exploratory data analysis and advanced analytics techniques like trend analysis, cumulative metrics, performance tracking, data segmentation, and part-to-whole evaluation.

• UpdatedMay 5, 2025

Built a Data Model, Implemented Basic to Advanced SQL Queries

• UpdatedJan 12, 2024

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis

• UpdatedJun 20, 2025
• TSQL

Danny Ma's #8WeekSQLChallenge case study solutions.

• UpdatedDec 30, 2023

This project mirrors real-world data analysis workflows using advanced SQL techniques. It covers: 🔍 Exploratory data analysis (EDA) 📈 Change-over-time and cumulative metrics 🧾 Customer and product reporting ✅ Data validation and integrity checks

• UpdatedNov 2, 2025

MySQL code using subqueries and window functions

• UpdatedOct 18, 2023

Case Study #1 - Danny's Diner

• UpdatedSep 1, 2023

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.

• UpdatedSep 27, 2025
• TSQL