Windows API (WinAPI) functions and system calls with categories in JSON format, including arguments (SAL notation) and more.
The "Harnessing SQL for Sales Insights and Improvement" project involved comprehensive analysis of sales data extracted from SQL Server, imported into MySQL for data preparation, cleaning, normalization, and in-depth analysis using various SQL commands and functions.
Exploratory Analysis of the Indian Census data using SQL
Designed a SQL + Power BI retail analytics solution by investigating source-system data anomalies (30 product IDs linked to multiple product names, 16 product names associated with multiple product IDs), preserving 8 valid split-shipment transactions, implementing surrogate-key based star schema modeling, and an interactive business dashboard.
SQL case study analyzing Foodie-Fi, a subscription streaming service, using MySQL. Covers customer churn, plan upgrades, and a from-scratch payments table with mid-cycle proration logic. Part of the 8 Week SQL Challenge by Danny Ma.
A growing collection of SQL analytics solutions covering CTEs, aggregations, subqueries and window functions
ShopEasy, an online retail business, is experiencing a decline in customer engagement and conversion rates, despite investing heavily in marketing campaigns.
An enterprise-scale SQL logistics audit diagnosing spatial and temporal fulfillment friction across 32M+ transaction rows to optimize warehouse routing and labor utilization.
A SQL-based case study solving 10 real-world ad-hoc business requests for a consumer goods company, demonstrating proficiency in advanced SQL techniques like Window Functions and CTEs.
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.
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.
A complete MySQL Data Analytics project demonstrating SQL fundamentals, business analysis, EDA, CTEs, Joins, Views, and Window Functions.
Analysis of Covid-19 related deaths and vaccinations using SQL
End-to-end SQL analytics on 500K+ e-commerce transactions using CTEs, Window Functions, and advanced aggregations
MySQL window-function analysis + Kimball star schema on public housing inspection data
End-to-end SQL analysis of a Food Delivery database using MySQL, covering EDA, joins, subqueries, CTEs, window functions, and business insights for data-driven decision-making.
SQL analytics case study on a simulated Indian OTT platform — 12 business questions covering revenue, churn, and engagement analysis, solved with joins, correlated subqueries, self-joins, and window functions (gaps-and-islands, NULL-safe anti-joins) in MySQL.
Presentations that i made during learning period of Data Analytics at Excelr
Advanced SQL business analysis project solving real-world business problems using JOINs, CTEs, Window Functions, Aggregations, and Subqueries.
To associate your repository with the windows-functions topic, visit your repo's landing page and select "manage topics."