window-functions

ndleah/bitcoin-prices-analysis

💸 Bitcoin trading analysis

etfovac/WinAPI

Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL

SergeySenigov/data-engineer-practicum-portfolio

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

ellaclauz/SQL-FOR-DATA-ANALYSIS

SQL projects using the different functions from basic to advance

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.

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.

franckbinde/dannys_diner

SQL Challenge

Gino-Freud-Hobayan/8WeekSQL_Challenge

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

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

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

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.

yunusbagriacik/Digital-Filters-in-Audio-Signal-Processing

Digital FIR and IIR filters with intelligible Python codes using SciPy.

arnavailable/sql

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.

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.

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.

RafaelKarcz/CovidSQL

A comprehensive SQL project exploring COVID-19 data using CTEs, window functions, and views to analyze infection rates, mortality, and vaccination coverage across regions.

RafaelKarcz/ExpenseTracker

A set of SQL queries designed to analyze income and expenses, categorize spending, and track financial trends through various advanced operations like running totals, grouping, and filtering.

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.

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.

victorcezeh/alt-exam-poc

Alt school Fall semester DE exam questions.

Chaitanyaprasad60/SQL-Queries

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

Gopalkholade/Pizza-Sales-Analysis-with-SQL

Pizza Sales analytics with sql

HeatTransfer/7-Wonders

There are seven business-critical questions solved using SQL

joyou159/Signal-Equalizer

Desktop application for manipulating the frequency content of a signal using smoothing window functions

MuskanKhandelia/Famous_Paintings_Data_Analysis

data-analysis-sql

Pralhad789/SQL-Analytics-for-Elevating-ShopMart-Inventory-Management-and-Quality-Assurance

Optimized ShopMart's e-commerce sales performance, customer segmentation, inventory management, and quality assurance using advanced SQL techniques such as window functions, CTEs, joins, query optimization, and stored procedures.

Shubhamd1234/Pizza-Sales-Analysis-Using-SQL

An insightful analysis of pizza sales data using SQL to uncover trends and optimize business performance.

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.