Rudi’s Bakery Analyst Intern
*
Rudi’s Bakery Analyst Intern *
Led a comprehensive sales analytics project for Rudi’s Bakery, a gluten-free and organic baked goods company, to identify underperforming retailers, optimize inventory strategies, and inform expansion planning across 14 Colorado cities.
Cleaned and transformed over 300K records from store sales, product returns, and regional demographics. Built multiple regression models and applied KMeans clustering and Isolation Forest to segment store performance, detect anomalies, and correlate product returns with sales losses.
Revealed that education level was the strongest predictor of sales success, surpassing income and population. Recommended strategic expansion into higher education, mid-income cities like Boulder and Longmont.
Developed targeted SKU-level product recommendations using clustering, improving alignment between inventory and regional preferences.
Tools: Python, Pandas, Scikit-learn, KMeans, Isolation Forest, Excel, Regex