DSND Term 2 Portfolio Exercise: Optimize promotion offers for Starbucks

This repository contains files for my Codebasics Challenge #9: Analyse Promotions and Provide Tangible Insights to Sales Director

Promotion planning optimization project for pharmaceutical supply chains

Atliq Mart 🛒, a prominent retail giant with over 50 supermarkets in the southern region of India, conducted a large-scale promotion during the festive seasons of Diwali 2023 🪔 and Sankranti 2024 🪁 on their Atliq branded products.

Analysis simulated data of the Starbucks Rewards mobile app and implementation of machine learning models to predict individual offer portfolios for each customer

AI-powered semantic search and analysis for FMCG promo copy. Find, classify, and re-use high-performing headlines using LLMs, emotion analysis, and KPI filters. Modular Python project with Streamlit dashboard—showcasing practical data science and modern NLP for marketing.

End-to-end Excel VBA data model for evaluating price elasticity, promotion lift, and sales performance. Automates data preparation and integration, calendar mapping, KPI computation, and scenario simulations for FMCG analysis.

End-to-end FMCG sales analytics dashboard built with Power BI, analyzing sales performance, promotion impact, margin risk, and inventory exposure across 3 years of data.

📊 Analyze price elasticity and promotion effectiveness in FMCG using an automated Excel VBA model for insightful sales performance evaluation.