BikeShare Case Study In R

In this project, we take a look at data for a fictional company named Cyclistic. The analysis spans a 12-month period from December 2021 to November 2022. The Dataset is cleaned, analyzed, and corresponding visuals are created to help recommend some next steps for the company to take to increase the amount of members.

Scanner Data Cleaning and Exploration in SQL

In this project, I use Microsoft SQL server to clean and analyze POS Scanner Data. Utilizing SQL queries to take a look at total sales per month and the differences between the top and bottom selling products.

Scanner Data Dashboard in Tableau

In this Dashboard, I utilize the data from the Scanner Data project giving us various types of visuals to represent my findings. These include total sales per month and the differences between the top and bottom selling products devided by SKU and SKU category.

Covid Exploration in SQL

In this project, I use SQL server to do a deep dive into the global covid 19 data from the start of the pandemic until march 2021. Utilizing SQL queries to take a look at total cases vs the population, and total loss of lives in each country, amongst others.

COVID Dashboard in Tableau

In this Dashboard, I utilize the data from the deep dive on the Covid data giving us various types of visuals to represent my findings. These include total global covid numbers from the start of the pandemic, total deaths per continent, the percentage total of the population infected in each continent, and percentage of the population infected by month with a potential forecast of what future numbers could look like.

Data Cleaning of Nashville Housing in SQL server

In this Project, I cleaned data using SQL server demonstrating basic cleaning techniques such as changing date formats, joins, separating information into new columns, and more.