GitHub topics: window-functions

Repositories

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.

Language: Jupyter Notebook - Size: 230 KB - Last synced at: about 15 hours ago - Pushed at: about 16 hours ago - Stars: 1 - Forks: 0

Peter-Opapa/sql_server_Analysis_project

This project builds upon my earlier SQL Server Data Warehouse by performing in-depth analysis using the business-ready data in the Gold layer. It includes SQL scripts for exploratory data analysis (EDA), trend analysis, segmentation, and insights generation.

Size: 22.5 KB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

eurora-labs/ferrous-focus

Cross-platform focus tracker for Linux (X11), macOS and Windows

Language: Rust - Size: 137 KB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 1 - 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: 7 days ago - Pushed at: 7 days ago - Stars: 0 - Forks: 0

manishamanchana/sql-learning

🧠 Structured SQL Learning Repository | Beginner to Advanced Topics + Real Projects 🎯 Covers core SQL skills, window functions, performance tuning, and hands-on data warehousing/EDA projects

Size: 239 KB - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 0 - Forks: 0

SergeySenigov/data-engineer-practicum-portfolio

Проекты курса Инженер данных на платформе Yandex Practicum

Language: Python - Size: 6.75 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 6 - Forks: 4

VeronSheva/HR_dashboards

Interactive HR dashboard using Tableau & MySQL – explore employee trends, performance, attrition, and salary insights.

Size: 8.56 MB - Last synced at: 13 days ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

Tharadol07969/sql_sales_analytic

A comprehensive collection of SQL scripts for data exploration, analytics, and reporting.

Language: TSQL - Size: 966 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

rogui-manal/Data-Analysis-with-SQL

This repository contains a comprehensive collection of SQL scripts based on a learning project aimed at practicing data exploration, analytics, and reporting techniques using SQL.

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

NivedhaAk/world-layoffs-sql-project

SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL

Size: 4.88 KB - 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: 3 months ago - Pushed at: 3 months ago - Stars: 40 - Forks: 17

PoojaVishwakarm/SQL-Exploratory-Data-Analysis-EDA-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: 1.42 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

jatomsplamkakj/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert

Repo containing materials from MySQL Bootcamp

Size: 1.95 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

kmdawkins/portfolio-project2

SQL Database Normalization and Advanced Queries

Language: PLpgSQL - Size: 16.1 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

whoisalisha/BOM-Business-Analyst-Technical-Case-Study-Assignment

BOM(Bill of Materials) Business Analyst Case Study Solution using Python, Pandas manipulation and Visualization Technique

Size: 1.95 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

ndomah/MySQL-Bootcamp-Go-from-SQL-Beginner-to-Expert

Repo containing materials from MySQL Bootcamp

Size: 586 KB - Last synced at: 3 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

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.

Size: 3.89 MB - Last synced at: 4 months ago - Pushed at: 5 months ago - Stars: 1 - Forks: 0

egorumaev/2024-colab-sqlite-postgresql

SQL-запросы в Google Colab с помощью SQLite и PostgreSQL

Language: Jupyter Notebook - Size: 473 KB - Last synced at: 4 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Prajjwol09/MySQL

The purpose of this repository is to provide a comprehensive guide to MySQL for beginners. It covers the basic concepts and operations involved in using MySQL.

Size: 28.3 KB - Last synced at: 7 days ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

muryulia/8-Week-SQL-Challenge

#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies

Size: 980 KB - Last synced at: 5 months ago - Pushed at: about 3 years ago - Stars: 41 - Forks: 17

HeatTransfer/7-Wonders

There are seven business-critical questions solved using SQL

Size: 3.91 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

Gopalkholade/Pizza-Sales-Analysis-with-SQL

Pizza Sales analytics with sql

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

SwethaAshervadam/RSVP_Movies_Assignment

RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2023.

Size: 112 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

victorcezeh/alt-exam-poc Fork of JesuFemi-O/alt-exam-poc

Alt school Fall semester DE exam questions.

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

maithilid12/Analyzing_Paper_Company_Database

Used Postgres SQL to analyze Parch and Posey Paper Company data

Language: TSQL - Size: 489 KB - Last synced at: over 1 year ago - Pushed at: almost 5 years ago - Stars: 0 - Forks: 0

Jaswin-J/Film-Rental-Analysis

Creating Report for decision making in Film Rental Store

Size: 796 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

ndleah/bitcoin-prices-analysis

💸 Bitcoin trading analysis

Language: SQL - Size: 1.11 MB - Last synced at: about 2 months ago - Pushed at: almost 4 years ago - Stars: 7 - Forks: 4

arnavailable/sql

Size: 4.88 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

MuskanKhandelia/Famous_Paintings_Data_Analysis

data-analysis-sql

Language: Jupyter Notebook - Size: 6.45 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

dmarks84/Ind_Project_Movie-Database-SQLite

Independent Project - I joined and manipulated data from disparate tables of movie information using Python & SQLite; defined schema, created tables/views, queried data, etc. Utilized CTE's, Window Functions, and other DDL, DQL, DML, and DCL scripts.

Language: Python - Size: 2.67 MB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 1

Theofilusarifin/E-Commerce-Data-Analysis-with-Elastic-Search

This project involves comprehensive e-commerce data analysis using SQLite and Elasticsearch. It starts by importing the Kaggle E-commerce dataset into SQLite for initial exploration and basic data cleaning. Then, Elasticsearch is employed for indexing and querying, enabling further analysis.

Language: Jupyter Notebook - Size: 7.08 MB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Theofilusarifin/Analyzing-eCommerce-Business-Performance-with-SQL

In any company, measuring business performance is crucial for tracking, monitoring, and evaluating the success or failure of various business processes. Therefore, this project aims to analyze the business performance of an eCommerce company, considering several business metrics: customer growth, product quality, and payment types.

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

Gino-Freud-Hobayan/8WeekSQL_Challenge

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

Size: 1.23 MB - Last synced at: 4 months ago - Pushed at: over 1 year ago - Stars: 2 - Forks: 0

Chaitanyaprasad60/SQL-Queries

This is a list of complex SQL Queries I have practiced.

Size: 1.46 MB - Last synced at: 4 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

jianninapinto/COVID19_Crisis

Used SQL queries to perform data analysis of the COVID-19 pandemic, exploring key trends, statistics, and insights sourced from Our World in Data.

Size: 13.1 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

tknishh/data-lemur-sql-solution

SQL solutions for DataLemur including all difficult levels.

Size: 5.86 KB - Last synced at: 3 months ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

pujaitridas/10dayschallenge

This repository hosts IVY's SQL Internship(July 2023): 10-Days Challenge, which offers participants the opportunity to practice their SQL skills through a series of progressively challenging tasks.

Size: 303 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Harkirat78/CovidAnalysis-DataExplorationSQL

SQL project that analyzes large amounts of data specifically related to Covid-19 deaths and vaccinations

Size: 23.6 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

tzelleke/postgres-notes

Personal notes on PostgreSQL

Language: Jupyter Notebook - Size: 563 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

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.

Size: 46.9 KB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 1 - Forks: 0