INTERACTIVE SALES DASHBOARD (HTML/CSV-driven)

FILE STRUCTURE:
→ Single HTML file (self-contained, no server required)
→ CSV data embedded or loaded from URL
→ Shareable via email or link
→ Works offline after first load
→ Browser compatibility: Chrome, Safari, Firefox (ES6)

KPI CARDS (Top of dashboard):

1. TOTAL REVENUE (Current Month)
→ Value: $487,234
→ Change: +12 percent vs prior month (green up arrow)
→ Target: $500,000 (92 percent to goal)
→ Trend sparkline: 12-month history

2. PIPELINE VALUE (Opportunities)
→ Value: $2.1M
→ By stage: Qualified 45%, Demo 30%, Negotiation 25%
→ Variance: $180k below forecast

3. AVERAGE DEAL SIZE
→ Value: $47,850
→ +8 percent vs 12-month average
→ Top customer segment: Enterprise (size: $125k avg)

4. CLOSE RATE
→ Value: 28 percent
→ vs industry benchmark 22 percent (exceeding)
→ Conversion by source: Inbound 35%, Outbound 22%

5. SALES CYCLE LENGTH
→ Value: 47 days (avg)
→ vs 60-day target (beating forecast)

FILTERS (interactive, multi-select):
→ Date range: Custom calendar picker (default: current month)
→ Salesperson: Dropdown with all reps (select multiple)
→ Region: North, South, East, West, International
→ Product: SaaS, Consulting, Support, Licenses
→ Deal stage: Prospecting, Qualified, Demo, Negotiation, Won, Lost
→ Revenue band: Custom range slider (e.g., $10k-$100k)

YEAR-OVER-YEAR COMPARISON:
→ Chart: Revenue by month (current year vs prior year, overlaid)
→ Interaction: Hover shows exact values and percent change
→ Export: Download comparison as CSV

DETAIL TABLE (sortable, paginated):
→ Columns: Salesperson, Customer, Product, Amount, Stage, Close Date, Days Open, Probability
→ Sortable: Click column header to sort ascending/descending
→ Filterable: Input boxes under headers for text search
→ Pagination: 50 rows per page; jump to page via dropdown
→ CSV export: "Download" button exports filtered view

FORMULAS (calculated in browser):
→ YoY percent change = (current - prior) / prior * 100
→ Weighted pipeline = SUM(amount * probability / 100) by stage
→ Average close time = SUM(days_open) / deal_count
→ Forecast accuracy = actual_closed / forecast_closed

DESIGN:
→ Color palette: Green (positive variance), Red (negative), Gray (neutral)
→ Responsive: Stacks on mobile; 2-column on tablet; 3-column on desktop
→ Print-friendly: Remove filters, fit KPIs to single page
→ Dark mode toggle: Respects system preference (prefers-color-scheme)