Welcome to my SQL portfolio! This repository contains a collection of my SQL projects, showcasing my skills in data cleaning and exploratory data analysis (EDA). Each project includes detailed SQL scripts and explanations to demonstrate my approach and methodology.
- Project: LAcity.gov Web Traffic
- Description: This project involves cleaning and transforming >8 million rows of raw web traffic data to prepare it for analysis. The dataset includes information on web traffic metrics such as page views, unique visitors, and sessions.
- SQL Skills Used: Data Cleaning, Data Transformation, Data Type Conversion, Handling Missing/Incorrect Values.
- View SQL Script
- Original dataset from here.
- Project: Coffee Survey
- Description: This project involves cleaning and transforming raw coffee survey data to prepare it for analysis. The dataset includes information on drinkers' preference, demographic, and extensive attributes related to brew preference, with 98 columns and 4k+ entries.
- SQL Skills Used: Data Cleaning, Data Transformation, Data Type Conversion, Handling Missing Values, Normalization.
- View SQL Script
- Original dataset from here.
- Project: LGBTQIA+ Movies
- Description: This project involves analyzing the 10k LGBTQIA+ movies dataset to identify trends, patterns, and insights. The goal is to understand the release trends, geographical distribution, and popularity of LGBTQIA+ movies.
- SQL Skills Used: Common Table Expressions (CTEs), Window Functions, Aggregations, Group By, Joins, Date Functions, Data Cleaning, Data Normalization.
- View SQL Script
- Original dataset from here.
- Project: Tech Layoffs
- Description: This project involves cleaning and transforming raw layoff data, and analyzing the layoff data. The goal is to understand the impact and distribution of layoffs across different tech sectors during COVID-19 until present.
- SQL Skills Used: Data Cleaning, Data Transformation, Data Type Conversion, Common Table Expressions (CTEs), String Manipulation, Window Functions, Aggregations, Group By, Joins, Date Functions.
- View Data Cleaning SQL Script
- View EDA SQL Script
Feel free to explore the projects and SQL scripts to see my work in action. If you have any questions or feedback, please don't hesitate to reach out!
Note: To view the SQL scripts, navigate to the respective file paths provided in each project description.