Skills Experience

SQL

I have experience writing MySQL queries to gather and clean data needed to answer client business questions.

Spreadsheets

I have also used both Microsoft Excel and Google Sheets to turn raw data into easy-to-understand data visualizations, like charts or pivot tables.

Presentation

With crafted visualizations and knowledge of the raw data, I've presented insights and possible solutions to clients, both on-site and remotely.

Python

Recently, to take my analysis skills further, I've been teaching myself Python, including data forward libraries such as Pandas and Matplotlib.

Relevant Projects

Rating Game Roles with Python and SQL

An exercise evaluating comparative ratings of roles in a social deduction game, using Pandas, pyodbc, and Microsoft Access.

Visualizing K-pop Data

Using Pandas, Matplotlib, and Seaborn so visualize K-pop data to answer specific questions about the industry.

Predicting the Champions League with Python

A Python program to simulate the group stage and playoff rounds of the 23/24 UEFA Champions League, then write the results to a .csv and display them with matplotlib.

Data Cleaning 311 Requests with Pandas

A data cleaning exercise using pandas to make Austin 311 requests more usable for analysis. Austin make their 311 requests publicly available, and data was queried via BigQuery.

Predicting Pokemon Types with Machine Learning

An exercise to get a feel for using machine learning tools from scikit-learn to predict Pokemon types based on their stats.

Tracking Book Reading with Google Sheets

A spreadsheet for tracking books acquired and read over 2024 using a combination of vlookups and filters to create a convenient dashboard.