window-functions-in-sql
There are 50 repositories under window-functions-in-sql topic.
DataWithBaraa/sql-data-analytics-project
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.
CyprianFusi/Using-our-SQL-skills-to-answer-business-questions
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.
dannydave/sql-data-analytics-project
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.
lasyakonduru/E-Commerce-Analysis-Using-Advanced-SQL
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.
shubhamgoyal575/SQL-Project-Collection
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.
YuliiaHudz/SQL-Case-Studies
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.
CharlesEmil/sql-data-analytics-project
This repository includes a collection of SQL scripts showcasing various analytical techniques, such as trend analysis, cumulative calculations, performance evaluation, data segmentation, and part-to-whole analysis.
ChojoGebutsu/PostgreSQL-Data-Analytics-Project
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.
LKEthridge/Data_Collection_and_Storage_-SQL-
A Data Collection and Storage project using SQL from TripleTen
Pranj302/SQL-Portfolio-Project
SQL Data Analysis and Estimation Projects
TheArkitekt/SQL_project
Аналитический проект из ad-hoc запросов к базе данных с данными об авиаперевозках
Abubakar-colla/SQL-DATA-WAREHOUSE-PROJECT
Building a modern data warehouse with sql, including ETL processes, data modelling, and analytics.
Afrijalrasya/SQL-data-analytics-project
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.
AhAdly/sql-data-analytics-project
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.
ameerahrazali/mlb-analysis
A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.
annettelynn/Window-Function-SQL
A window function performs a calculation across a set of table rows that are somehow related to the current row.
arshadbu15/Indian_census_Analysis
SQL analysis of Indian census data.
Daniel-Kav/spotify-data-2023-analysis
Welcome to the "Spotify Music Analysis - 2023" project! Here, we're exploring a carefully compiled dataset showcasing the standout songs of 2023, as documented by Spotify. This dataset goes beyond the usual song collections, offering a complete look into each track's characteristics, popularity, and visibility across different music platforms.
Daniel-Kav/sql-data-warehouse
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.
Danitilahun/SQL_Notes
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!
DishaAggarwal31/8-Weeks-SQL-Challenge
This repository contains the solutions of the 8 case studies for The 8 Weeks SQL Challenge
EngIbrahim1/Data-Warehousing-and-Advanced-Data-Analytics
Data Analytics Project: Analyzed Promotions and Provided Tangible Insights to Sales Director
ggommes/End-to-End-Data-Project-Dental-Clinic-Performance
End-to-end data analytics case study of a dental clinic in Brazil (2020–2025). Leveraging SQL and Power BI, the project uncovers trends in revenue, patient flow, and clinic performance. Results support data-driven decisions to boost efficiency and growth.
HAIDERatGH/sql-data-analytics-project
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
husskhosravi/major_baseball_sql
SQL analysis of Major League Baseball data exploring player statistics, team performance and historical trends
leestephy/LeetCode-SQL-50
LeetCode SQL 50
LeohangRai/sql-window-functions-examples
bunch of SQL Window function query examples
mi7773/advanced_sql_data_analytics_project
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.
piyushkumar2025/Analytical-SQL-Project-Exploring-Trends-Segmentation-KPIs
A complete SQL analytics project using a simulated data warehouse. It analyzes sales, customer, and product data with CTEs, joins, window functions, subqueries, and views to deliver insights on trends, segmentation, and KPIs, showing how SQL enables data-driven decisions without BI tools.
Rasheeda-Sultana/sql-data-analytics-project
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.
tatv047/sales-data-warehouse-and-data-analysis
Building a modern data warehouse with SQL Server,including ETL processes,data modeling , data analytics and dashboarding
theatashaikh/datawarehousesql
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.
YousefMostafa24/sql-analytics-project
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
Yukta026/BankSight-Financial-Volatility-Insight
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.