GitHub topics: window-functions-in-sql

Repositories

EngIbrahim1/Data-Warehousing-and-Advanced-Data-Analytics

Data Analytics Project: Analyzed Promotions and Provided Tangible Insights to Sales Director

Language: TSQL - Size: 2.07 MB - Last synced at: 2 days ago - Pushed at: 2 days ago - Stars: 0 - Forks: 0

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.

Size: 4.15 MB - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 0 - Forks: 0

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.

Size: 336 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

husskhosravi/major_baseball_sql

SQL analysis of Major League Baseball data exploring player statistics, team performance and historical trends

Size: 1.53 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

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.

Language: TSQL - Size: 20.7 MB - Last synced at: about 2 months ago - Pushed at: 2 months ago - Stars: 40 - Forks: 17

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!

Language: Jupyter Notebook - Size: 191 KB - Last synced at: 7 days ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

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.

Language: HTML - Size: 10.3 MB - Last synced at: 19 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

LKEthridge/Data_Collection_and_Storage_-SQL-

A Data Collection and Storage project using SQL from TripleTen

Language: Jupyter Notebook - Size: 162 KB - Last synced at: 2 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

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.

Language: Jupyter Notebook - Size: 435 KB - Last synced at: 3 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

gogulamudigeethareddy/sql

sql along with a case study

Language: PLpgSQL - Size: 30.3 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

kinman-dev/1brc-using-sql

Demo of using window function with JOOQ & Springboot

Language: Java - Size: 436 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

pradyumna03/covid-exploration

Analyzing and cleaning of COVID-19 data using different SQL functionalities.

Size: 5.76 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Ked-Is-Keen/SQL_Scripts

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.

Language: TSQL - Size: 6.84 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0