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

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.

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

This project showcases the use of SQL to analyze retail sales data for insights on customer behavior, product performance, and sales trends. It involves table creation, data cleaning, exploration, and answering real-world business questions using SQL.

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.

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 analysis of Forbes Global 2000 using CTEs, window functions, subqueries and views.

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

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

SQL Data Cleaning and EDA on World Layoffs Dataset using MySQL

Analysis of Total coronavirus cases, deaths and vaccination data of countries around the world using Microsoft SQL server. Data taken from the website: ourworldindata

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.

This project focuses on executing advanced SQL queries on an airline database to derive meaningful insights. The queries analyze key aspects of airline operations, such as ticket bookings, passenger records, flight schedules, and aircraft details. It leverages essential SQL techniques, including joins, CTEs, aggregations and a lot more.

SQL queries developed as part of a data analysis project. Includes analysis of job data, queries for insights into job categories, salaries, and customer behavior. Techniques used include JOINS, CTEs, subqueries, and aggregate functions. Inspired by DataNerd's YouTube tutorial: https://www.youtube.com/watch?v=7mz73uXD9DA

SQL journey from foundations to production: window functions, CTEs, stored procedures, and real-world data cleaning projects

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.