ZolileN/mamboo-dashboard

Retail intelligence dashboard built with Streamlit, Python, and SQL to analyse store performance, category profitability, inventory health, and promotion effectiveness for a multi-branch South African home and storage retailer. # Mamboo Retail Intelligence Dashboard A polished Streamlit analytics app for a fictional South African storage, plastics, and home retail chain. The project simulates a real-world retail BI workflow using Python, SQL, synthetic data generation, and interactive dashboards. ## What this project demonstrates - Retail KPI design for multi-branch operations - SQL-backed analytical modelling with SQLite - Streamlit app development for business stakeholders - Inventory and replenishment analysis - Promotion and discount effectiveness analysis - Portfolio-ready storytelling for GitHub and job applications ## Why this project works for a portfolio This is positioned as a decision-support dashboard rather than a generic sales report. The app answers the kinds of questions a retail operations manager, merchandising lead, or analyst would care about: - Which branches are strong but availability-constrained? - Which categories drive revenue versus margin? - Which SKUs should be protected, replenished, transferred, or rationalised? - Is discounting creating profitable growth? ## Tech stack - Python - Streamlit - SQLite - Pandas - Plotly - Faker / NumPy for synthetic data generation ## Dashboard modules ### 1. Executive Overview Answers: - How much revenue and gross profit did the business generate? - Which categories and stores contribute most to performance? - What are the key signals around stockouts and inventory velocity? ### 2. Store Performance Answers: - Which branches are leading or lagging? - Are weak stores suffering from low demand, low margin, or availability issues? - Which stores warrant operational intervention? ### 3. Category & SKU Analysis Answers: - Which categories and subcategories drive revenue? - Which SKUs are hero products versus underperformers? - How concentrated is value across the SKU base? ### 4. Inventory Health Answers: - Which products are at risk of stockout? - Which SKUs should be replenished first? - Where might inter-store stock trans …