Analytics & Strategy

Portfolio

Concise project decks with clear takeaways—preview instantly or download a polished PDF to dive deeper.

Technical Projects

Reports Tableau
Wine Analytics

Gallo Winery — Preliminary Wine Analysis

Explored 13,050 global wine records to map how type and geography influence price and quality. Sparkling wines led on both metrics while Rosé lagged; t-tests confirmed statistically significant differences across regions and informed sourcing strategy.

  • Skills: Descriptive analytics, two-sample t-tests
  • Tools: Tableau storytelling, Python/R/SQL stack
Download PDF
Excel Reports Tableau
Pricing Strategy

Gallo Winery — Wine Pricing Model & Tableau Dashboard

Built correlation, single, and multiple regression models connecting price with rating, vintage, and rating counts. Identified sparkling wines as premium outliers and delivered a Tableau dashboard plus data roadmap for more robust pricing decisions.

  • Skills: Correlation, regression diagnostics
  • Tools: Tableau filters, Python/R/SQL
Download PDF
Excel Reports
Customer Analytics

Credit Card Behavior — Taiwan (≈25k customers)

Tested gender-based billing differences and seasonal payment shifts. Men carried ~$125 higher balances and September payments surpassed April by ~$15, shaping acquisition and retention tactics for marketing and finance.

  • Skills: Two-sample & paired t-tests
  • Tools: Confidence intervals, experiment-to-action translation
Download PDF
Excel Reports
Retail Pricing

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

Analyzed 26k SKUs to measure Walmart’s pricing delta. ANOVA and Fisher intervals confirmed Walmart’s consistent undercut across major competitors, inspiring recommendations for precision price lifts and bold price-match messaging.

  • Skills: ANOVA, pairwise confidence intervals
  • Tools: Large-scale data cleaning & merchant segmentation
Download PDF
Excel Reports
Financial Modeling

EPS Drivers — NYSE (1,501 companies)

Modeled EPS via EBT, operating margin, and pre-tax margin. Highlighted EBT as the strongest lever, flagged negative margin relationships, and framed the model as directional guidance with future data-expansion plans.

  • Skills: Multiple regression, significance testing
  • Tools: Model diagnostics, financial storytelling
Download PDF
Excel Reports
Lending Strategy

Debt Predictors — SoFi (≈2,000 clients)

Built a debt prediction model using demographics and financial behavior. Identified key predictors, surfaced multicollinearity watch-outs, and provided actionable targeting for consolidation outreach teams.

  • Skills: Multiple regression, diagnostics
  • Tools: Residual analysis, predictive screening
Download PDF
Reports
Résumé Snapshot

Jake Moore — Professional Résumé

One-page overview connecting analytics coursework to client-facing wins. Features technical toolkit mastery, campus leadership, and quantified consulting outcomes ready for recruiter review.

  • Highlights: SQL · Python · Tableau · Excel
  • Bonus: Certifications & quantified achievements
Download PDF