window-functions-in-sql

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.

SQL-based EDA project exploring a retail data warehouse. Includes database setup and analysis scripts for data exploration, dimension profiling, date range discovery, measures analysis, magnitude breakdowns and ranking using aggregates and window functions.

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.

Expert SQL analytics project — P&L, rankings, rolling returns & anomaly detection for a simulated trading firm

Databases in data science AGH Course repository

SQL Project | PostgreSQL | pgadmin

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

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.

End-to-End Data Cleaning and Preparation on a raw FIFA players dataset using PostgreSQL and pgAdmin 4.

End-to-end SQL Server analysis of the Olist Brazilian e-commerce marketplace — schema design, data-quality auditing, and business insights.

A hands-on SQL project simulating data analysis using fact and dimension tables, covering trends over time, cumulative metrics, performance breakdowns, segmentation, and reporting via SQL.

Data cleaning on a global tech layoffs dataset using MySQL

Developing a modern data warehouse on SQL Server, encompassing ETL workflows, data modeling, and analytical capabilities.

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.

A/B test analysis for Maven Fuzzy Factory comparing bounce rates between the original homepage (/home) and a new landing page (/lander-1). Using SQL to filter traffic, calculate bounce rates, and verify statistical significance with 95% confidence intervals. Includes business recommendations and next steps for implementation.

Analisador de gastos pessoais em SQL e pandas — com detector de assinaturas via window functions, notebook Jupyter e playground SQL ao vivo no navegador

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.

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.

This repository provides a comprehensive guide for building production-ready data warehouses using SQL Server. It walks through the complete process of implementing a modern data warehouse using Medallion Architecture (Bronze, Silver, Gold layers) with practical code examples and detailed.

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