sql-data-cleaning

SQL Portfolio Projects. Highlights SQL skills including CTE"s, Views, Temp Tables, altering and updating tables....

SQL projects using the different functions from basic to advance

Explore COVID-19 data using SQL techniques like joins, CTEs, window functions, and aggregate functions. Also, clean Nashville Housing data with SQL scripts. Repository includes queries, skills used, and dataset sources.

This project explores global life expectancy trends using the Analyst Builder platform. It showcases interactive dashboards and visual analytics to uncover relationships between life expectancy and factors such as GDP, healthcare spending, and country development status.

Used Car Market Analysis: Identifying Depreciation Cliffs & Brand Power This project analyzes a dataset of 16,951 used vehicle listings to uncover market trends, calculate exact depreciation milestones, and identify which vehicle configurations command the highest premium in the secondary market.

Clean and standardize Nashville Housing dataset using SQL queries for improved data quality and structure.

Portfolio Project: SQL Data Exploration, Tableau Visualization, SQL Data Cleaning and Correlation in Python

SQL-based data cleaning project for Nashville housing dataset, standardizing dates, addresses, and removing duplicates.

End-to-end SQL project analyzing global layoffs (2020-2023) through comprehensive data cleaning and exploratory analysis.

A comprehensive SQL project focused on cleaning and analyzing global tech layoff data to uncover trends in funding, industries, and workforce reductions

Cohort Retention Analysis of an Online Retail platform

Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.