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.
-
Updated
Mar 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.
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.
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.
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
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.
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.
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
A window function performs a calculation across a set of table rows that are somehow related to the current row.
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 repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.
A collection of T-SQL scripts I written throughout my journey as a Data Analyst, Data Engineer, and BI Developer. They demonstrate the use of window functions, calculating dates, dynamic SQL, stored procedures, and other out of the box solutions.
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.
Building a modern data warehouse with SQL Server,including ETL processes,data modeling , data analytics and dashboarding
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 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.
Building a modern data warehouse with sql, including ETL processes, data modelling, and analytics.
Data Analytics Project: Analyzed Promotions and Provided Tangible Insights to Sales Director
Add a description, image, and links to the window-functions-in-sql topic page so that developers can more easily learn about it.
To associate your repository with the window-functions-in-sql topic, visit your repo's landing page and select "manage topics."