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.
These challanges were asked on this webiste.
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.
This project presents a fictional case study analyzing the operations of a textile company, FabricFlow, using SQL. The dataset includes information about products, sales, inventory, suppliers, and purchases. The goal is to derive actionable insights to improve operational efficiency, inventory management, and supplier performance.
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é.
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.
Built a dimensional data warehouse on 60K+ sales transactions and 18K+ customers — designed fact/dimension tables and a centralized SQL reporting view to replace fragmented manual queries with a single business-ready analytics layer.
Using Microsoft SQL queries to explore Covid 19 deaths and vaccinations percentages throughout the world.
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.
End-to-end global tech layoffs analysis using SQL data cleaning with window functions and CTEs, EDA and interactive Tableau dashboard | 2020-2024
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.
Building a modern data warehouse in SQL Server by integrating ETL processes, data modeling, and analytics.
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.
Repository for MYSQL windows function projects
5-module SQL analytics project on quick-commerce data — funnel, cohort, profitability, rider utilisation, and growth analytics
MySQL
SQL Exercise Repository - Sharpen Your Skills!
Repository containing SQL codes for data analysis
To associate your repository with the windowsfunction topic, visit your repo's landing page and select "manage topics."