Used
Tools:SQL
Project
Type:Data CleaningExploratory Data Analysis
Relevant Link
Type
Personal
Detailed Reports
SQL Projects
- 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.
- More detailed overview.
- 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: Table Alteration, Data Manipulation, Data Type Conversion, Handling Missing Values, Normalization.
- View SQL Script
- Original dataset from here.
- More detailed overview.
- Project: LGBTQIA+ Movies Exploration
- 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.
- More detailed overview.
- Project: Layoffs Data Cleaning
- 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
Detailed Reports