window-functions
There are 108 repositories under window-functions 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.
muryulia/8-Week-SQL-Challenge
#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies
ndleah/bitcoin-prices-analysis
💸 Bitcoin trading analysis
SergeySenigov/data-engineer-practicum-portfolio
Проекты курса Инженер данных на платформе Yandex Practicum
ellaclauz/SQL-FOR-DATA-ANALYSIS
SQL projects using the different functions from basic to advance
etfovac/WinAPI
Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL
MaxLopezSalgado/sql-playground
This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.
franckbinde/dannys_diner
SQL Challenge
Gino-Freud-Hobayan/8WeekSQL_Challenge
SQL Case Studies solved using Microsoft SQL Server and PostreSQL
rahkum96/Olympics-Dataset-by-sql
120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.
SA01/spark-window-functions
This repository contains the code and examples for my article on Medium, which provides an introduction to Window Functions in Apache Spark.
1NarendraSingh1/BOM-Business-Analyst-Technical-Case-Study-Assignment
BOM(Bill of Materials) Business Analyst Case Study Solution using Python, Pandas manipulation and Visualization Technique
Ankush-Santra/SQL_Projects
This repository showcases a curated collection of my SQL projects, demonstrating skills from foundational concepts like SELECT, INSERT, and ALTER to advanced techniques such as CTEs and Window Functions.
arthurcurrycb/sql-sp-real-estate-analysis
Real estate market analysis in São Paulo using SQL and data from Zap Imóveis.
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.
dBalag/Metrocar-project
Metrocar is the final project of MS's Data Analyst course. By identifying user drop-offs, implementing dynamic pricing, and recognizing key user segments for targeted marketing, this project demonstrates my ability to enhance revenue and improve user experience.
dBalag/Nike-CTEs
Unlock the power of SQL’s Common Table Expressions (CTEs) to transform data analysis capabilities! In this project, I demonstrate how to leverage CTEs to answer complex business questions with clarity and efficiency. Whether you’re dealing with hierarchical data, simplifying complex queries, or improving readability, CTEs are a game-changer.
Develop-Packt/Aggregate-and-Window-Functions
This module enables you summarize and identify the quality of the data using concepts such as aggregation and window functions.
Dina-Hosny/Analyzing-Cutomers-Purchasing-Transactions-Behavior-Using-Analytical-SQL
A report uses customers transactions data to gain insights into customer behavior and optimize sales, revenue, customer retention, and churn
Dorianteffo/impact_analysis-SQL-Powerbi
Quantify the impact of large scale supply changes on the sales perfomance of a business
egorumaev/2024-colab-sqlite-postgresql
SQL-запросы в Google Colab с помощью SQLite и PostgreSQL
eurora-labs/ferrous-focus
Cross-platform focus tracker for Linux (X11), macOS and Windows
eydelrivero/extension-functions
Extending sqlite extension-functions to support median aggregate function as a window function. See https://www.sqlite.org/contrib. Forked from https://gitlab.com/liamh/extension-functions
Gopalkholade/Pizza-Sales-Analysis-with-SQL
Pizza Sales analytics with sql
Jaswin-J/Film-Rental-Analysis
Creating Report for decision making in Film Rental Store
Nargis45/SQL_youtube
I have started a new playlist called MySQL on my YouTube channel. Watch the videos to learn SQL from scratch.
neha-dev-dot/Pyspark-Tutorial
This repository is part of my journey to learn **PySpark**, the Python API for Apache Spark. I explored the fundamentals of distributed data processing using Spark and practiced with real-world data transformation and querying use cases.
NidhiDevrani/SQL-Ecommerce-Analysis
Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.
Nikhil-DA/sql-data-warehouse-project
A hands on SQL Data Warehouse project with mySQL, including ETL processes, data modelling and analytics.
osmanovabm/sql-data-analytics-project
This repository showcases an SQL data analytics project demonstrating Exploratory Data Analysis (EDA) and Advanced Analytics (CTEs, Window Functions, Subqueries, Views) in PostgreSQL.
sai-krishna-akkala/Sql_DataWareHouse_Project
End-to-end SQL Data Warehouse project implementing the Medallion Architecture (Bronze–Silver–Gold) using T-SQL. Covers data ingestion, cleansing, transformation, and modeling.
VladimirZelenokor1/CodeBasics-SQL
This repository contains solutions to exercises from "SQL Beginner to Advanced For Data Professionals" course by CodeBasics.
yunusbagriacik/Digital-Filters-in-Audio-Signal-Processing
Digital FIR and IIR filters with intelligible Python codes using SciPy.
laipching/sprint8_sql_data_storage
SQL queries and data storage: joins, aggregations and window functions to answer business questions.
Siva9100623079/SQL-Ecommerce-Analysis
About Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.
Vamsi0801/SQL-Ecommerce-Analysis
Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.