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.

SQL-based end-to-end analysis of 100K+ e-commerce orders (Olist dataset), covering revenue growth, logistics performance, and RFM customer segmentation to drive business insights.

Advanced SQL project analyzing e-commerce sales using joins, CTEs, and window functions. Includes sample data (CSV) and queries with business insights.

Analyzing the 2023 data analyst job market using SQL — top-paying roles, in-demand skills, and optimal skills by salary-to-demand ratio.

📊 End-to-end SQL data analysis project on Indian Election dataset | PostgreSQL | Advanced SQL | Data Modeling | Insights

A diverse collection of SQL-based projects that solve practical business problems using relational data. From global economics to urban transport and marketing analytics, these projects highlight strong proficiency in data querying, joins, CTEs, and window functions.

SQL analysis of Forbes Global 2000 using CTEs, window functions, subqueries and views.

Exploration of Covid 19 official dataset using SQL queries. Data cleaning of Nashville housing dataset for effective modelling and analysis.

SQL project analyzing MLB schools, salaries, careers, and comparisons. Explores top schools, team spending, player career spans, team loyalty, batting hand trends, and decade-by-decade height/weight changes using advanced queries and analytics.

First practice post-LaunchCode graduation to review the various SQL skills we learned throughout the course.

A curated collection of beginner-to-medium level SQL interview questions, practical queries, and real-world case studies designed for Data Analyst roles. Covers joins, subqueries, window functions, aggregations, and business-oriented problem solving.

Transforms raw sales and dimension data into two key analytics views—customer_report and product_report—within the gold schema using T-SQL. Includes customer segmentation, product ranking, sales trends (YoY, moving averages), and revenue contribution analysis.

SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL

Global layoffs analysis 2020–2026 using pure SQL — CTEs, window functions, DENSE_RANK, 12 queries, 875K layoffs

This repository contains more python and sql exercises, done during the bootcamp on Data Analytics at Adalab.

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.

End-to-end SQL analysis of a bike-sharing dataset covering data validation, ride duration patterns, peak-hour demand, station-level net flow, and month-over-month user growth using advanced SQL concepts.

A collection of SQL queries demonstrating CTEs, joins, and aggregation for analytical reporting.

E-commerce database design and analysis using SQL queries, CTEs and Views.

An end-to-end retail analytics pipeline designed to analyze sales performance, stock management, product trends, and category-level insights using transactional retail data. Also involves automated repeatable data analysis workflows