Featured Projects

Bot Battles Player Analysis

Bot Battles is a mobile game available in North America. This analysis examines player demographics and a year of in-game activity to investigate activity patterns and establish player profiles. An introduction to the game can be found here. The analysis is broken into parts:

  • Part 1: Loading and cleaning the data in PostgreSQL.
  • Part 2: An exploratory data analysis to familiarize myself with the game and its data.
Python and PostgreSQL
Data Cleaning, Visualization
SQLAlchemy, Pandas, Matplotlib, Seaborn, Statsmodels, SciPy

ElectroniCart Sales Analysis

ElectroniCart is an online electronics retailer that has collected a wealth of data from 100k+ orders since being established in 2019. This project aims to provide insights and recommendations on trends in sales, refunds, and performance of the recently introduced loyalty program.

Google BigQuery SQL, Excel, Tableau
Data Cleaning, Pivot Tables, Visualization

Quality Health Marketing Report

Quality Health is a medical insurance company that launched 57 ads spanning twelve marketing campaigns in 2019. This project analyzes the performance of each campaign, its impact on signups, and subsequent patient claims and proposes adjustments for future marketing budgets.

Tableau, Google BigQuery SQL
Visualization