Sales & Profitability Optimization Dashboard
Discount impact analysis, regional performance comparison, product margin analysis, seasonal pattern detection, and what-if scenario simulation with an interactive Streamlit dashboard.
Simulation Note: This project uses a synthetic/sample dataset. Financial impact, savings, ROI, and SLA-cost estimates are modeled scenarios for analytical demonstration and do not represent actual NTC financial figures.
Modeled Estimate (synthetic data)
Interactive Dashboard
Margin by Discount Band
Revenue & Margin by Region
Margin by Product Category
Monthly Revenue Trend
Business Problem
Revenue is growing but profitability is declining. Management needs to understand discount impact, regional gaps, and product performance.
Methodology
Data Loading
Loaded sales transaction dataset with discount levels, regional breakdowns, product categories, seasonal patterns, and margin data
Data Preparation
Cleaned and transformed data, calculated margin percentages, created discount bands, and derived seasonal metrics
Multi-Dimensional Analysis
Analyzed discount-volume correlation, regional performance gaps, product margin distribution, and seasonal patterns with statistical testing
Dashboard & What-If
Deployed Streamlit dashboard with interactive what-if scenario simulation for discount governance and regional optimization
Key Insights
Ineffective Discount Strategy
Weak correlation between discount and volume (r=0.12) — discounts don't drive significant volume increase. Discounts reduce margin by 15-25% depending on category.
Optimal Discount Band
Optimal discount band is 1-10% (highest margin at 42%). 30%+ discounts reduce margin to 18% with minimal volume benefit.
Regional Performance Gap
40% variance between top and bottom regions. North has highest revenue but lowest margin (too many discounts). West has highest margin but lowest revenue.
Product Margin Disparity
Electronics has highest revenue but lowest margin (28%). Beauty has highest margin (55%) but only 8% revenue share. 20% of products generate 80% of profit (Pareto).
Seasonal Revenue Patterns
40% variance between peak (December) and trough (January) months. Q4 accounts for 35% of annual revenue. Summer months show 15% higher margin than winter.
Business Recommendations
Modeled Estimate (synthetic data)Tighten Discount Governance
Cap discounts at 20% without approval. Expected impact: +8% profit improvement ($240K annually). Implementation: tiered approval process.
Category-Specific Strategies
Restrict discounts on low-margin categories (Electronics, Grocery). Allow flexible discounts on high-margin categories (Beauty, Clothing). +12% margin improvement.
Regional Optimization
Increase marketing in high-growth regions (West, South). Reduce discounts in over-discounted regions (North). +15% revenue growth in targeted regions.
Seasonal Planning
Pre-build inventory for Q4 peak season. Launch promotions in low-season months to smooth demand. Reduce seasonal variance by 25%.
Technical Highlights
Discount Analysis
- ▸Pearson/Spearman correlation testing
- ▸Discount band optimization
- ▸Margin impact quantification
Regional & Product
- ▸ANOVA for regional revenue comparison
- ▸Pareto principle identification
- ▸Category-specific margin analysis
What-If Simulation
- ▸Discount cap scenario modeling
- ▸Regional marketing allocation
- ▸Seasonal inventory planning
Dataset
Sales transaction dataset with discount levels, regional breakdowns, product categories, seasonal patterns, and margin data.
Project Outcome
Modeled Estimate (synthetic data)Identified $240K+ annual profit improvement opportunity through discount governance and category-specific strategies. The what-if scenario tool enables management to model the impact of discount caps and regional marketing allocation before implementation.