Skip to main content
Streamlit Dashboard — Portfolio Project

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.

PythonPandasNumPySciPyPlotlyStreamlit

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)

+6.7%
Profit Improvement
r=0.12
Discount-Volume Correlation
40%
Regional Variance
42%
Optimal Margin
35%
Q4 Revenue Share
$240K
Annual Savings

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

Step 1

Data Loading

Loaded sales transaction dataset with discount levels, regional breakdowns, product categories, seasonal patterns, and margin data

Step 2

Data Preparation

Cleaned and transformed data, calculated margin percentages, created discount bands, and derived seasonal metrics

Step 3

Multi-Dimensional Analysis

Analyzed discount-volume correlation, regional performance gaps, product margin distribution, and seasonal patterns with statistical testing

Step 4

Dashboard & What-If

Deployed Streamlit dashboard with interactive what-if scenario simulation for discount governance and regional optimization

Key Insights

01

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.

02

Optimal Discount Band

Optimal discount band is 1-10% (highest margin at 42%). 30%+ discounts reduce margin to 18% with minimal volume benefit.

03

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.

04

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).

05

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)
01

Tighten Discount Governance

Cap discounts at 20% without approval. Expected impact: +8% profit improvement ($240K annually). Implementation: tiered approval process.

+$240K/yr
02

Category-Specific Strategies

Restrict discounts on low-margin categories (Electronics, Grocery). Allow flexible discounts on high-margin categories (Beauty, Clothing). +12% margin improvement.

+12% margin
03

Regional Optimization

Increase marketing in high-growth regions (West, South). Reduce discounts in over-discounted regions (North). +15% revenue growth in targeted regions.

+15% revenue
04

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.