GitHub topics: window-functions-in-sql
Harshal-Narkhede/sql-exploratory-data-analysis-project
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
Size: 1.41 MB - Last synced at: 2 days ago - Pushed at: 2 days ago - Stars: 0 - Forks: 0
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: 5 days ago - Pushed at: 5 days 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: 6 days ago - Pushed at: 7 months ago - Stars: 115 - Forks: 65
Raunak-DA-45/SQL_Data_Analytics_Project
A comprehensive collection of SQL scripts for data exploration, analytics, and reporting. These scripts cover various analyses such as database exploration, measures and metrics, time-based trends, cumulative analytics, segmentation, and more.
Language: TSQL - Size: 2.1 MB - Last synced at: 8 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0
ggommes/End-to-End-Data-Project-Dental-Clinic-Performance
Estudo de caso completo (end-to-end) de análise de dados de uma clínica odontológica no Brasil (2020–2025). Utilizando SQL e Power BI, o projeto revela tendências de receita, fluxo de pacientes e desempenho da clínica. Os resultados apoiam decisões baseadas em dados para impulsionar a eficiência e o crescimento.
Size: 1.45 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0
pushkarguptaaa/Advanced-SQL-Analytics-Project
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.
Language: TSQL - Size: 5.22 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0
arshadbu15/Indian_census_Analysis
SQL analysis of Indian census data.
Size: 30.3 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0
wejde-n/sql-data-analytics-project
📊 Explore and analyze data effectively with SQL scripts designed for data analysts and BI professionals to enhance reporting and insights.
Language: TSQL - Size: 4.93 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0
annettelynn/Window-Function-SQL
A window function performs a calculation across a set of table rows that are somehow related to the current row.
Language: TSQL - Size: 7.81 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0
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.
Language: TSQL - Size: 5.99 MB - Last synced at: about 1 month ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0
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.
Language: Jupyter Notebook - Size: 206 KB - Last synced at: 4 days ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0
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.
Language: TSQL - Size: 3.5 MB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0
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.
Language: TSQL - Size: 5.38 MB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0
ameerahrazali/mlb-analysis
A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.
Size: 42.7 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0
Afrijalrasya/SQL-data-analytics-project
Repositori ini berisi kumpulan script SQL yang mendemonstrasikan berbagai teknik analisis, seperti perubahan dari waktu ke waktu, kumulatif, kinerja, segmentasi data, analisis per-bagian ke-keseluruhan.
Language: TSQL - Size: 3.76 MB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0
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.
Language: TSQL - Size: 829 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0
jackrit88/sql-data-analytics-project
Explore SQL scripts for data analytics and reporting. Perfect for data analysts and BI professionals. Boost your data exploration skills! 🐙📊
Language: TSQL - Size: 6.39 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0
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
Language: TSQL - Size: 6.94 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0
gogulamudigeethareddy/sql-hands-on
sql along with a case study
Language: PLpgSQL - Size: 44.9 KB - Last synced at: 5 months ago - Pushed at: 5 months 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: 4 months ago - Pushed at: 5 months 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: 6 months ago - Pushed at: 6 months 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: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0
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: 5 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0
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.
Language: TSQL - Size: 3.51 MB - Last synced at: about 1 month ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0
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.
Size: 1.14 MB - Last synced at: 4 months ago - Pushed at: 9 months ago - Stars: 1 - 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: 6 months ago - Pushed at: 9 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: 11 days ago - Pushed at: 10 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: 5 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0
kinman-dev/1brc-using-sql
Demo of using window function with JOOQ & Springboot
Language: Java - Size: 436 KB - Last synced at: over 1 year ago - Pushed at: over 1 year 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: over 1 year ago - Pushed at: over 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
sarutlaa/SQL-Analysis-on-Instagram
Built a Data Model, Implemented Basic to Advanced SQL Queries
Size: 5.86 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
MuskanKhandelia/Digital_Music_Store_Analysis
data-modeling-analysis-sql
Size: 196 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
Neyaz-oo7/8-Week-SQL-Challenge
Case Study #1 - Danny's Diner
Size: 6.84 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0
