Portfolio

Data Analytics Capstone

Check out the dedicated page for my data analytics capstone project, which looks at factors that affect attendance to Major League Baseball games.

Data Analytics Projects

Excel Project: Airbnb Rental Analysis in San Diego, CA

Using real-world data from Airbnb, I analyzed which neighborhoods in San Diego were most popular with customers, provided some possible reasons for their popularity, and made some recommendations for potential investors looking to buy housing units to rent on Airbnb.

Excel Project: Kickstarter Fundraising Goal Analysis

This project used data acquired from Kickstarter to analyze which factors could increase the chances of a fundraiser being successful and meeting its goal.

Power BI Project: Food Distributor Sales

For this project, I analyzed two years of sales data for a fictional food distribution company to answer questions and present insights that the client could then use to adjust their strategy. See the project page here.

Tableau Project: United States Presidential Election Data

This project used a dataset consisting of counties in the continental United States and the political party that won the majority of votes in each county, from 2000 through 2020. Using Python, I computed whether each county changed party preference from the previous election (i.e., from Democrat to Republican, from Republican to Democrat, or stayed the same). I then used Tableau to visualize this data onto a county map of the continental United States. Take a look at the Tableau visualization below, or read more about the project here.

SQL Project: Gender Wage Gap in the United Kingdom

This project used real-world data submitted by companies in the United Kingdom regarding pay disparity between female and male employees. Read more about it in the project page.

SQL Project: SQL Ladder

This ladder consists of a series of increasingly complex SQL queries that demonstrates my thought process and query selection used to solve the challenges presented.

Miscellaneous Projects

Random Music Album Picker

A fun little project you can find here that randomly selects a top album from the year 2000 onward. It links to the album on Spotify (if available) and to the search page on Apple Music; if the album is unavailable on either streaming platform, it will link to a third-party website to listen to and/or purchase the album.