capstone

Project Details Table

Project description	This Analytics project was done for a leading beverage company. The project was focused on analyzing U.S. beverage market data to identify early success indicators, sustained growth drivers, and actionable product segments within Water, Functional Beverages, and Carbonated Soft Drinks categories. The team leveraged SQL, Python-based machine learning, and natural language processing (NLP) to transform structured sales metrics and unstructured product text (claims, ingredients, flavors) into predictive insights. The project delivered data-driven recommendations on flavor innovation, claim positioning, brand strategy, and portfolio prioritization, enabling PepsiCo stakeholders to better evaluate new product launches, and identify white-space opportunities.
Client	A leading Baverage Company
Domain	Consumer Packaged Goods (CPG) / Beverage Analytics
Platform, server and database	SQL, Python (pandas, scikit-learn, NLP), Jupyter Notebook
Methodology	Agile / Iterative Analytics Development
Responsibilities	•⁠ ⁠Analyzed and prepared large-scale beverage sales data using SQL and Python for modeling and insights generation. •⁠ ⁠Engineered structured and text-based features using NLP, PCA, and encoding techniques to support predictive modeling. •⁠ ⁠Built and evaluated regression models to identify early success and long-term growth drivers for beverage products. •⁠ ⁠Performed product segmentation and flavor/claim analysis to uncover white-space and innovation opportunities. •⁠ ⁠Collaborated with team members to •⁠ Translate analytical findings into executive-ready PowerPoint recommendations for PepsiCo stakeholders.
Achievements	•⁠ ⁠Identified key product claims and flavor families associated with high early-stage velocity and sustained growth, supporting data-driven innovation and portfolio strategy decisions. •⁠ ⁠Developed interpretable predictive models achieving consistent performance across beverage categories, enabling early identification of high-potential SKUs. •⁠ ⁠Delivered actionable product segmentation and white-space insights that highlighted opportunities for distribution expansion, flavor innovation, and emerging brand investment.