Projects

US Bikeshare Data Explorer

A rebuild of my Udacity data science capstone — originally a text-based command-line Python script — as a fully interactive web application for exploring trip patterns, popular stations, and rider demographics across three major U.S. bikeshare systems.

Python · Pandas · Streamlit · Plotly

View project →

Video Store SQL Analysis

Four SQL case studies built on a fictional video rental database — the dataset was assigned, the techniques are not. Each page demonstrates a transferable analytical pattern: relating non-adjacent data, testing a result against an expectation, inferring preference from product attributes, and constructing a product attribute that doesn't exist as data at all by parsing unstructured text.

SQL · PostgreSQL · JavaScript · Chart.js · SVG

View project →