Portfolio

Gallo Winery — Preliminary Wine Analysis

Analyzed 13,050 wine records to understand how type and geography affect price and quality. Sparkling wines performed best, Rosé worst. Used t-tests to validate regional differences and guide sourcing decisions.

• Skills: Descriptive analytics, two-sample t-tests
• Tools: Tableau storytelling, Python/R/SQL stack

Gallo Winery — Wine Pricing Model & Tableau Dashboard

Built regression models linking price to rating, vintage, and popularity. Found sparkling wines command premium prices. Created interactive Tableau dashboard to support pricing strategy.

• Skills: Correlation, regression diagnostics
• Tools: Tableau filters, Python/R/SQL

Credit Card Behavior — Taiwan (≈25k customers)

Tested gender and seasonal payment patterns. Men carried $125 higher balances on average. September payments exceeded April by $15. Results shaped marketing and retention strategies.

• Skills: Two-sample & paired t-tests
• Tools: Confidence intervals, experiment-to-action translation

Walmart vs. Amazon/Macy's/Overstock — Women's Shoes

Compared 26k shoe prices across retailers. ANOVA confirmed Walmart consistently undercuts competitors. Recommended targeted price adjustments and aggressive price-match messaging.

• Skills: ANOVA, pairwise confidence intervals
• Tools: Large-scale data cleaning & merchant segmentation

EPS Drivers — NYSE (1,501 companies)

Modeled earnings per share using EBT, operating margin, and pre-tax margin. EBT proved the strongest predictor. Identified unexpected negative margin relationships worth investigating.

• Skills: Multiple regression, significance testing
• Tools: Model diagnostics, financial storytelling

Debt Predictors — SoFi (≈2,000 clients)

Predicted client debt levels using demographics and financial behavior. Identified key risk factors and multicollinearity issues. Enabled better targeting for consolidation offers.

• Skills: Multiple regression, diagnostics
• Tools: Residual analysis, predictive screening

Introduction to Data Science — Module 0

Introduction to Data Science — Module 1

Introduction to Data Science — Module 2

Introduction to Data Science — Module 3

Introduction to Data Science — Module 4

Introduction to Data Science — Module 5

Introduction to Data Science — Module 6

BNAN277 — Discussion 6

Applied analytics discussion with business case analysis.

• Skills: Data-driven decision making
• Tools: Excel modeling, statistical analysis

BNAN277 — Discussion 7

Advanced analytical methods applied to business scenarios.

• Skills: Predictive modeling, forecasting
• Tools: Excel advanced functions, data analysis