GitHub topics: windowsfunction
SalimM21/Football-Data-Engineering-avec-PySpark-Databricks-et-Power-BI
Construction d’un pipeline PySpark pour l’analyse des performances footballistiques saison par saison, avec calcul de KPI, ranking des équipes et stockage optimisé en Parquet partitionné.
Language: Python - Size: 10.2 MB - Last synced at: 28 days ago - Pushed at: 28 days ago - Stars: 1 - Forks: 0
Sarvesh-Prajapati/database-codes
Repository containing SQL codes for data analysis
Language: SQL - Size: 5.7 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0
Rozay-DEV-24/Data-Analysis-with-SQL
This is an repo where I update my learning from SQL Advanced on Udemy.
Size: 7.81 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0
sidleerling/SQL-Project---Retail-Sales-Analysis-
SQL project on retail sales data (2,001 records) involving data cleaning, EDA, and insight generation using subqueries, CTEs, and window functions to uncover trends in customer behavior, sales, and product performance.
Size: 192 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0
Anjali25112/FAASOS-DUMMY-DATASET-ANALYSIS
Used SQL to analyze cancellations, peak hours, and driver performance to optimize food delivery operations.
Size: 1.64 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0
fauzan-syed/sql_advanced_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.51 MB - Last synced at: about 2 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0
Shriyaak/Retail-Sales-Analysis
Size: 44.9 KB - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0
arunkumarsp-ds/Analysis-of-Drop-in-Yammer-s-user-Engagement-using-PostgreSQL
Size: 1.55 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0
vishnupriya9629/Libraray-Management--SQL-Project
Analysis using SQL
Size: 1.85 MB - Last synced at: 5 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0
Ashish-kr-Srivastava/SOCIAL-MEDIA-DATABASE-ANALYSIS-SQL-PROJECT
I have recently worked on a project of analyzing a social media platform data on MS SQL SERVER. In this project I have used advanced SQL functions and keywords like Views, Indexes, CTE, Windows Functions and many more.
Size: 1.62 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0
kamat1993/MY-SQL
SQL Exercise Repository - Sharpen Your Skills!
Language: Jupyter Notebook - Size: 289 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0
udipta14/Social-Media-Database-Project
I have recently worked on a project of analyzing a social media platform data on MS SQL SERVER. In this project I have used advanced SQL functions and keywords like Views, Indexes, CTE, Windows Functions and many more.
Size: 5 MB - Last synced at: 4 months ago - Pushed at: about 2 years ago - Stars: 2 - Forks: 0
AAYUSMANN/social_media_analysis
This project involves designing and implementing a database system to handle various aspects of a social media platform. In this project i have used various advanced functions like cte,views,index and windows functions.
Size: 39.1 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0
udipta14/Olympic-Games-Analysis
The aim of this analysis was to extract valuable insights and answer a variety of questions related to the history, participation, and performance of nations and athletes in the Olympic Games. This project demonstrates my proficiency in Data Analysis, SQL Querying using advance functions like CTE, Joins, CASE, Pivot.
Language: TSQL - Size: 12.5 MB - Last synced at: 6 months ago - Pushed at: about 2 years ago - Stars: 2 - Forks: 0
TranLe99/SQL-DataExploration
Using Microsoft SQL queries to explore Covid 19 deaths and vaccinations percentages throughout the world.
Size: 1.95 KB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0
IbadDE/8-Week_SQL_Challenge
These challanges were asked on this webiste.
Language: SQL - Size: 1000 KB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 0 - Forks: 0