This repository will include all my data analysis work using SQL (MySQL & PostgreSQL), including my coursework and my work from DataCamp Projects, which are conducted in Jupyter Notebook.
| Project Name | Description | Topic |
|---|---|---|
| Optimizing Online Sports Retail Revenue | Dived into product data such as pricing, reviews, descriptions, and ratings, as well as revenue and website traffic, to produce recommendations for an online sports clothing company's marketing and sales teams. | Data manipulation, Joins, CTE |
| Analyzing Unicorn Companies | Analyzed information about unicorn companies worth over $1 billion using PostgreSQL database. | Importing & Cleaning Data |
| The Golden Age of Video Games | Use joins and set theory to analyze video game critic and user scores as well as sales data for the top 400 video games released since 1977. | Data manipulation, Joins, Set Theory |
| Analyzing Key Metric in Business Data | Wrote SQL queries to calculate key metrics that businesses use to measure performance on real-world datasets. | Data Manipulation, Window Functions, MAU Monitor, ARPU |
| Analyzing Motorcycle Part Sales | Derive insights about motorcycle part sales over time across multiple warehouse sites. | Data Manipulation |
| Analyze Olympics Dataset | Wrote SQL queries to explore the Olympics Database practicing how to turn messy data into clean, organized reports. | Data manipulation, Importing and cleaning data, Window functions, Layered calculations |
| Analyzing Historic Business | Use joining techniques and manipulation tools to answer questions about historic businesses. | Data Manipulation, Joins |
| Analyzing Industry Carbon Emissions | Use Intermediate SQL skills to explore a dataset about product carbon emissions. | Data Manipulation |