Projects
Each project on this page represents a real business question I worked through end to end, from raw data to findings and recommendations I could actually stand behind. My hope is that the work here gives a clear picture of how I think as an analyst and what I could bring to a team.
Projects are organized into three tracks: Predictive Analytics, Data Visualization, and Forecasting. Each card links to a dedicated page with findings, recommendations, methodology, and key takeaways, with reports, slides, and code attached where applicable.
Predictive Analytics
Sun Country Airlines: Customer Segmentation
Business Question: Who are Sun Country's customers, and how can the airline grow loyalty enrollment and shift bookings to its direct channel?
Applied K-Means clustering to 15,144 customer records to identify 5 actionable segments, translating findings into three targeted campaigns tied to leadership's goals around Ufly enrollment, direct channel growth, and vacation package differentiation.
Predicting Employee Churn
Business Question: Which employees are most at risk of churning (leaving), and what organizational factors drive that risk?
Built and compared logistic regression and decision tree models on 4,653 employee records, achieving 79% recall on the churn class and identifying tenure, compensation tier, and education as the primary drivers of voluntary turnover.
Data Visualization
Adult Learn-to-Play Analysis
Business Question: Does participation in the Adult Learn-to-Play program drive sustained Rinks retention and Anaheim Ducks ticket purchasing, and where are the highest-leverage opportunities to deepen participant engagement?
Led SQL querying and Power BI dashboard development for a UCI MSBA Capstone engagement with the Anaheim Ducks and The Rinks, analyzing 1,285 unique LTP participants across registration trends, cohort retention, post-LTP program progression, and Ducks ticket sales crossover.
LAFC & BMO Stadium: Fan Experience Analysis
Business Question: What do five years of fan feedback tell us about where LAFC and BMO Stadium should focus to grow revenue and improve the fan experience from 2026 to 2030?
Analyzed 9,246 fan survey responses across LAFC matches, concerts, and ACFC events at BMO Stadium using Python-based sentiment analysis and theme classification, then built a multi-page Tableau dashboard and business plan to inform the club's 2026–2030 strategy.
UCI Basic Needs: CalFresh Analysis
Business Question: How are UCI Basic Needs Center's CalFresh assistance services performing across four years of data, and what operational changes would most improve program efficiency and student access?
Built a multi-page interactive Tableau dashboard tracking 6,261 CalFresh appointment records across 4 years, surfacing trends in Enrollment Party growth, no-show patterns, student eligibility reach, and seasonality.
Letterboxd: Movies as a Business and a Taste
Business Question: What do box office trends and personal viewing data reveal about film as both a cultural and commercial product?
A live window into film as both a personal passion and a commercial product, combining my personal ratings, watchlist, and physical media collection with box office and budget data that auto-updates over time.
Forecasting
Applied Forecast Modeling
Business Question: How can forecasting techniques be applied to real business problems across industries?
A collection of forecasting projects from BANA 290, applying causal and time series modeling techniques to real-world datasets. Projects include linear regression, ARIMA, and logistic regression built in Alteryx and visualized in Tableau.