ConsumerFlow is a professional Business Intelligence (BI) dashboard designed for the FMCG sector specifically modeled after the distribution and sales logic of Indian MNCs like Marico. It provides real-time visibility into warehouse health, regional performance, and inventory risks.
- 🇮🇳 Indian Market Localization: Custom formatting for currency in Lakhs (L) and Crores (Cr), aligning with Indian corporate reporting standards.
⚠️ Predictive Risk Alerts: Calculates Days of Inventory (DOI) to automatically highlight stock-out risks before they happen.- 🌍 Regional Intelligence: Segments performance across North, South, East, and West regions to identify local growth opportunities.
- 💡 Automated Recommendations: A built-in strategy engine that suggests trade promotions and inventory rebalancing based on current sales velocity.
- Frontend: Streamlit (Python-based Web Framework)
- Data Processing: Pandas & NumPy
- UI/UX: Custom CSS for enterprise-grade dark-theme styling.
- Deployment: Streamlit Community Cloud.
app.py: The core application logic and UI.marico_inventory.csv: The backend dataset containing product levels and sales figures.requirements.txt: Configuration file for cloud deployment.README.md: Project documentation.
This project demonstrates the ability to bridge the gap between Information Technology and Business Management. It proves competence in data cleaning, predictive logic, and user-centric design essential skills for a modern Data Analyst or Product Manager.
Developed by Tanisha Suvarna | IT Graduate 2026