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. Click any card below to visit its dedicated project page.
Projects span two tracks, Data Visualization and Predictive Analytics. Each card links to a dedicated page with findings, recommendations, methodology, and key takeaways, with reports, slides, and code attached where applicable.
Letterboxd: Movies as a Business and a Taste
Planned
A live, auto-updating window into film as both a personal passion and a commercial product, pairing my own ratings, watchlist, and physical media collection with box office and budget data to explore what they reveal about film as culture and commerce.
Deliverables: Power BI Dashboards
Technical Skills: TBD
STP Dashboard
06/2026-08/2026
Restructured HCA's manual STP (Speed-to-Proficiency) Tracker around a relational, class-level data model built on Jira-linked primary and foreign keys, then automated the pipeline with Power Query and delivered five interactive Tableau dashboards giving leadership self-service visibility into training performance, cutting monthly reporting effort by 60%.
Deliverables: PowerPoint Presentation, Tableau Dashboards, Written and Recorded Guides/Tutorials
Technical Skills: Excel, Tableau, Power Query, Jira, Enterprise Data Restructuring, Workflow Automation
Adult Learn-to-Play Analysis
01/2026-06/2026
Led SQL and Power BI development for a UCI MSBA Capstone with the Anaheim Ducks and The Rinks, analyzing 1,285 Adult Learn-to-Play participants to determine whether the program drives lasting retention and ticket purchasing, and where engagement could be deepened.
Deliverables: Written Report, PowerPoint Presentation, Power BI Dashboards
Technical Skills: SQL, Power BI, Retention Analysis, Marketing Analytics
LAFC & BMO Stadium: Fan Experience Analysis
04/2026
Analyzed 9,246 fan survey responses across five years of LAFC matches, concerts, and ACFC events using Python-based sentiment analysis, then built a multi-page Tableau dashboard and business plan identifying where LAFC and BMO Stadium should focus to grow revenue and improve the fan experience through 2030.
Deliverables: PowerPoint Presentation, Tableau Dashboards
Technical Skills: Python, Tableau, TextBlob, NLP/Sentiment Analysis, Business Strategy
UCI Basic Needs: CalFresh Analysis
01/2026-03/2026
Built a multi-page interactive Tableau dashboard on four years of CalFresh appointment data (6,261 records) for UCI's Basic Needs Center, surfacing Enrollment Party growth, no-show patterns, and eligibility trends to identify where program efficiency and student access could improve.
Deliverables: Tableau Dashboards
Technical Skills: Excel, Data Cleaning, Tableau, Program Evaluation
Sun Country Airlines: Customer Segmentation
06/2026-07/2026
Applied K-Means clustering to 15,144 Sun Country Airlines customer records to identify 5 actionable segments, translating findings into three targeted campaigns tied to Ufly loyalty enrollment, direct channel growth, and vacation package differentiation.
Deliverables: Report, Slides, Code
Technical Skills: Python, Elbow Method, EDA, Clustering, Customer Analytics, Segmentation
Predicting Employee Churn
09/2025-12/2025
Built and compared logistic regression and decision tree models on 4,653 employee records to identify which employees were most at risk of voluntary turnover, achieving 79% recall on the churn class and surfacing tenure, compensation tier, and education as the primary drivers.
Deliverables: Report, Slides, Code
Technical Skills: Python, Cross Validation, Decision Tree, Machine Learning, HR Analytics, Classification