Portfolio 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 →