Lighting Designs Sales Dashboard
Advanced Analytics & Forecasting | May 2025
Interactive Filters (Excel Slicers Simulation)
All Periods
Q4 2024
Q1 2025
YTD 2025
All Regions
Northeast
Southeast
West
Midwest
All Categories
LED Fixtures
Smart Lighting
Outdoor Lighting
Commercial Systems
Traditional Bulbs
Clear All Filters
$2.1M
Total Revenue
↗️ +18% YoY
15,247
Units Sold
↗️ +12% YoY
32%
Avg Profit Margin
↗️ +3% YoY
92%
Forecast Accuracy
↗️ +14% Improved
Monthly Revenue Trend
Product Category Performance
Regional Sales Distribution
Customer Segment Analysis
6-Month Revenue Forecast with Confidence Intervals
Solver Optimization Results
$1.8M
Optimized Revenue (Next 6M)
15%
Inventory Cost Reduction
98%
Optimal Fill Rate
$18K
Optimal Marketing Spend
Key Business Insights from PivotTable Analysis
LED Fixtures
dominate with 40% market share and highest margins (35%)
Northeast region
outperforms others by 22% - expansion opportunity identified
Q4 seasonality
shows 25% sales boost - inventory planning optimized
B2B customers
have 3x higher AOV than B2C - focus area for growth
Smart Lighting
category shows 45% growth potential - strategic investment
Price elasticity
analysis suggests 8% increase optimal for high-margin products