EMMA WILCOX: Data Analyst

EMMA WILCOX: Data Analyst

  • Resume
  • Contact Me
  • OVERVIEW: Explore Recent Projects
  • About Me
  • DEEP DIVE: Full Data Analytics Portfolio
    • Descriptive Python and Tableau Analysis: RV Use on Public Lands
    • Descriptive Excel Analysis: GameCo
    • Descriptive Python Analysis: Instacart
    • Prescriptive Excel and Tableau Analysis: Planning for Influenza Season
    • Predictive Analysis: Customer Retention
    • Descriptive SQL and Tableau Analysis: Rockbuster
  • Blog

Tools: Python (Jupyter, pandas, numby, matplotlib, seaborn.) Link to full project

Challenge: Instacart wants to use insights from initial data and exploratory analysis to develop better segmentation of customers, and the marketing strategies to best reach them. The goal is to increase sales with greater understanding of any meaningfully distinct customer behaviors, such as late-night ordering, or regional dietary tendencies. Cleaned, transformed and integrated 5 datasets of department, product, customer and order information to engage with a dataframe in excess of 30 million rows, using Python libraries. Derived new variables and conceptualized numerous demographic subsets, testing with statistical analysis. Used visualizations and reporting narrative to answer key business questions about customer behavior and demographics.

Curiosity + Tenacity + Precision