GitHub topics: window-functions-in-sql

Repositories

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: 1 day ago - Pushed at: 1 day 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: 3 days ago - Pushed at: 4 days ago - Stars: 0 - Forks: 0

ggommes/Data-analysis-project

This repository features SQL scripts for in-depth data analysis of a dental clinic in Brazil (2020-2025). It explores various analytical techniques, including revenue and patient trends, cumulative performance, and data segmentation, providing actionable recommendations for business growth and operational efficiency

Size: 39.1 KB - Last synced at: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

humlamadan/advanced_sql_data_analytics_project

Advanced SQL Data Analytics project showcasing data analysis techniques and reporting. Explore insights with SQL views on customer and product data. 🐙📊

Language: TSQL - Size: 831 KB - Last synced at: 15 days ago - Pushed at: 15 days 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: 17 days ago - Pushed at: 17 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: 18 days ago - Pushed at: 18 days 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.75 MB - Last synced at: 22 days ago - Pushed at: 22 days 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: about 1 month ago - Pushed at: about 1 month 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: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

gogulamudigeethareddy/sql-hands-on

sql along with a case study

Language: PLpgSQL - Size: 44.9 KB - Last synced at: about 2 months ago - Pushed at: about 2 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: about 1 month ago - Pushed at: 2 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: 3 months ago - Pushed at: 3 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: 3 months ago - Pushed at: 3 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: 4 months ago - Pushed at: 4 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: about 2 months ago - Pushed at: 4 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: about 1 month ago - Pushed at: 6 months ago - Stars: 1 - Forks: 0