Featured Projects (WIP)

Personal / analytics projects demonstrating data cleaning, SQL joins, and Tableau visualizations

I use data visualization to clarify patterns and turn complex information into intuitive visual stories.

I’ve worked on a number of mapping and visualization projects to strengthen skills in:

  • data collection and cleaning
  • normalization
  • spatial analysis

Projects —

  • Retail Market Basket & Affinity (Retail Personalization)
  • Maine Trail CX & Utilization (User Sentiment | Experience Metrics)
  • IBM BI Full-Stack Capstone (PostgreSQL | Excel | Tableau)
  • Chicago Public Safety Queries (SQL)

1. Retail Basket Affinity

Retail Affinity Analytics: Market Basket Optimization & Customer Segmentation

Category: Retail Personalization & Basket Intelligence

Tools: SQLite / SQL CTEs, Excel Pivot Tables, Tableau

Summary: Understanding how routine transactional data translates into tailored personalization is critical for balancing retention with commercial value.

This project models a synthetic relational dataset of 500 grocery transactions across four PineMart store locations in Maine, utilizing advanced SQL self-joins and Common Table Expressions (CTEs) to calculate product pairing support percentages (such as identifying a 14.97% attachment rate between potato chips and salsa).

The analysis bridges technical data modeling with actionable CX strategies, to optimize both store merchandising and customer loyalty.

2. Maine Hiking Log

Maine Trail Experience: Friction Mapping & Effort-to-Reward Analysis

Category: Human-Centered CX Analytics | Behavioral Segmentation & Retention

Tools: SQLite / SQL Analytics, Excel Pivot Tables, Tableau

Summary: Standard outdoor trail directories primarily categorize hikes by basic physical metrics—such as distance, elevation gain, and general difficulty.

However, from a user experience perspective, these surface-level specs fail to capture the behavioral trade-offs and operational friction points (remote travel distance, safety concerns, monotonous terrain, or underwhelming views) that actually drive user satisfaction and repeat intent.

This project evaluates 28 distinct hiking experiences across Maine to map environmental and logistical friction against aesthetic payoff, quantifying how specific pain points impact retention while isolating “high-efficiency delighters” that deliver maximum scenic reward with minimal physical cost.


3. IBM BI Full-Stack Capstone

Summary: This project analyzes retail sales performance across multiple regions and product categories. I built a complete BI workflow to uncover trends, identify inefficiencies, and generate actionable insights.

Tools: Excel/Sheets, PostgreSQL, Tableau

Skills: Data cleaning, statistical analysis (Excel), dashboard design

Link: IBM: BI Analysis final project


4. Chicago Crime Dataset

Summary: As part of my IBM: BI coursework, I used the Chicago Public Schools dataset to explore Chicago crime data.

It demonstrates my ability to query structured datasets, identify patterns, and translate raw data into insights.

Queried tables include CHICAGO_PUBLIC_SCHOOLS, CENSUS_DATA, and CHICAGO_CRIME_DATA.

a. Query showing the average school’s safety score:

SELECT AVG(Safety_Score) FROM 'chicago_public_schools';

b. Query for which types of crimes have been recorded at gas station locations:

SELECT DISTINCT PRIMARY_TYPE FROM 'chicago_crime'
WHERE LOCATION_DESCRIPTION = 'GAS STATION';

c. Query using crime count GROUP BY:

SELECT
ce.community_area_name,
COUNT(*) AS theft_count
FROM CHICAGO_CRIME_DATA cr
JOIN CENSUS_DATA ce
ON cr.community_area_number = ce.community_area_number
WHERE cr.primary_type = 'THEFT'
GROUP BY ce.community_area_name
ORDER BY theft_count DESC;

d. Query joining CHICAGO_CRIME_DATA and CENSUS_DATA to look at theft incidents alongside the poverty levels of their respective neighborhoods:

SELECT
cr.primary_type,
ce.community_area_name,
ce.percent_households_below_poverty
FROM CHICAGO_CRIME_DATA cr
JOIN CENSUS_DATA ce
ON cr.community_area_number = ce.community_area_number
WHERE cr.primary_type = 'THEFT'
ORDER BY ce.percent_households_below_poverty DESC
LIMIT 10;