This portfolio showcases a collection of personal SQL query projects using Microsoft SQL server. These projects demonstrate a range of technical skills to analyze data, providing insights that help businesses better understand and address their needs.


U.S. Bike Sales SQL Query

This SQL query aggregates data to build a comprehensive table for creating a dashboard to analyze sales trends over multiple years.

It gathers data related to customer sales, units sold, different brands that were sold, and the states and stores where the sales took place.

If you would like to review a copy of this SQL project, you can download it via my Github link

—> Add files via upload · CarsonTate601/U.S.-Bike-sales-SQL-Query@67b6248 (github.com)

Covid Portfolio Project SQL Query - Vaccinations vs Death 2020 to 2021

In this SQL script, I conducted an in-depth analysis of multiple datasets related to COVID-19 vaccinations and deaths for the years 2020 and 2021. Utilizing various data exploration techniques, I examined the impact of COVID-19 across different regions and countries.

If you would like to review a copy of this SQL project, you can download it via my Github link

—> Add files via upload · CarsonTate601/PortfolioProjects@1251bf2 (github.com)