TechMart Inc. — Business Analytics Dashboard 2025

$5.31M

Total Revenue

$1.68M

Total Profit

31.7%

Avg Profit Margin

9,353

Transactions

1,198

Unique Customers

$567

Avg Order Value

7

4

US Regions

📅 Monthly Sales & Profit — Jan to Dec 2025

📈 Month-over-Month Revenue Growth %

🗓️ Quarterly Revenue & Profit Performance

🌏 Revenue by US Region

👤 Revenue by Customer Segment

🎯 Category Revenue vs Profit

💰 Profit Margin % by Category

🏆 Top 10 Products by Revenue

🏷️ Discount Bracket → Sales & Net Margin Impact

📊 Category Revenue Share — Treemap

🎂 Revenue & Profit by Age Group

💳 Revenue by Payment Method

🔄 Customer Loyalty Tier Distribution

📡 Segment Revenue vs Profit — Bubble Chart

📅 Revenue by Day of Week

📦 Revenue by Shipping Mode

🗺️ Regional Revenue Share — Donut

📈 Cumulative YTD Revenue vs Linear Target

🔬 What-If Scenario Analysis Engine

Adjust the sliders below to model future business scenarios. The projections update instantly, showing the revenue, profit, and margin impact of each assumption.

ℹ️ Baseline (2025 Actuals): Revenue $5,311,299 · Profit $1,677,063 · Margin 31.6% · 9,353 transactions

📈 Revenue Growth Assumption

+5%

e.g. new marketing campaign

💰 Profit Margin Shift (pp)

0 pp

e.g. COGS increase, pricing strategy

🏷️ Avg Discount Rate Change

e.g. promo season, discount cap policy

📦 New Product Category Revenue

$0K

e.g. launching Toys, Automotive

Projected Revenue

—

Projected Profit

—

Projected Margin

—

Est. Add. Transactions

—

📊 Scenario vs Baseline — Revenue & Profit

📈 Sensitivity Analysis — Growth Rate vs Projected Profit

⚠️ Discount Insight: Every 5% increase in avg discount rate compresses net profit margin by ~2.8pp. Discounts >20% result in negative margins on low-ticket items.

💡 Key Business Insights — TechMart 2025

Discounts erode profit faster than they drive volume: Discounts over 20% compress margins by ~15%, dropping from 31.7% to under 17%. A tiered discount cap strategy — limiting promotions to 15% for low-margin categories — could recover $130K+ in annual profit.
Electronics dominates but depends on thin margins: Electronics contributes 55.7% of revenue ($2.96M) but at a below-average margin. Bundling high-margin accessories could push category margin toward the 31.7% company average.
Weekend shoppers spend 12% more per transaction: Saturday and Sunday account for 24.7% of weekly revenue despite being only 2/7 days. A targeted weekend flash-sale strategy would amplify this pattern.
The 36–45 age cohort is the most valuable segment: This group generates $1.68M (31.7% of total) with the highest per-customer spend. Loyalty program enhancements here present the highest expected ROI.
Standard shipping is a hidden profit lever: 60.2% of orders use Standard shipping. Nudging toward First Class via free upgrade thresholds could improve satisfaction scores and reduce returns.
Q4 is disproportionately critical: Q4 generated $1.75M (32.9% of annual revenue). A supply chain stress-test for Q4 2026 demand — especially Electronics and Home & Kitchen — is strongly recommended.

📊 Revenue Concentration — Pareto Analysis

🔥 Profit Margin % Heatmap — Category × Region

🛍️ TechMart Inc. — Business Analytics Dashboard 2025