Build software better, together

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.

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.

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.

Used SQL to analyze cancellations, peak hours, and driver performance to optimize food delivery operations.

🚀 Welcome to the SQL Mastery Repository! 🚀

Repository for MYSQL windows function projects

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.

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 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

Using Microsoft SQL queries to explore Covid 19 deaths and vaccinations percentages throughout the world.

• Updated Nov 21, 2024

Building a modern data warehouse in SQL Server by integrating ETL processes, data modeling, and analytics.

MySQL

SQL Exercise Repository - Sharpen Your Skills!

Analysis using SQL

Repository containing SQL codes for data analysis