top of page
Computer with Graph

Data Analysis

Screen Shot 2021-05-22 at 10.24.02 AM.pn

Covid-19 Mask Usage Visualization with Google BigQuery and Tableau

I use SQL to extract data from multiple tables in Google's BigQuery data warehouse. The data is then integrated into Tableau to create a dashboard revealing surprising trends in mask usage.

Screen%20Shot%202021-05-22%20at%2010.33_edited.jpg

Heart Disease Prediction Using a Random Forest Model in R

I use the Tidymodels packages in R to train and evaluate a random forrest model to predict heart disease risk with 84% accuracy.

Screen Shot 2021-05-22 at 11.01.44 AM.pn

Watershed Property Management – Short Term Rental Optimization

I predict profit growth for watershed property management if they were to convert their long term rental properties into short term, Airbnb style rentals. 

​

I use SQL to extract data from a MySQL database. Then I fit a linear regression model in Excel to predict short term rental occupancy rates, and calculate cash flow  and profits. The results are visualized in a Tableau dashboard.

Unknown.png

Red Wine Classification Using Logistic Regression in R

I fit a logistic regression model in R to predict Red Wine Quality with 88% accuracy.

©2020 by William Schulman. Proudly created with Wix.com

bottom of page